2
votes
Google Sheets keyboard shortcut: 'Sort sheet AtoZ or ZtoA' on current column?
To sort ascending by the current column, press Alt+Shift+D S A.
To sort descending by the current column, press Alt+Shift+D S Z.
See the keyboard shortcuts help page.
1
vote
Accepted
Google Sheet how to combine data from same sheet to other sheet
Can you provide an example sheet to clarify the tables you want to merge and how you want the data portrayed?
You said you used an “array query” but I’m not clear on what you mean. A query produces an ...
1
vote
Accepted
Google sheets conditional format to highlight a column containing items from another list
Use indirect() to refer to another sheet in a conditional formatting custom formula rule, like this:
=countif(indirect("List!A2:A"), A2)
See your sample spreadsheet.
1
vote
Open user database with separate spreadsheets
Is there a way to dynamically combine sheets?
Yes, there is. Use the array handling features of Google Sheets.
or use one sheet that can protect/hide some
Sheet/range protection doesn't hide ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
google-sheets × 9database × 9
google-sheets-arrayformula × 2
formulas × 1
google-sheets-query × 1
conditional-formatting × 1
privacy × 1
keyboard-shortcuts × 1
sorting × 1
mail-merge × 1