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.
doubleunary's user avatar
  • 14.2k
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 ...
Kevin's user avatar
  • 41
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.
doubleunary's user avatar
  • 14.2k
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 ...
Rubén - Volunteer Moderator -'s user avatar

Only top scored, non community-wiki answers of a minimum length are eligible