Monday, May 31, 2021

Tips: how to hide unused column or row in google sheet

In order to create the Anki flashcard, only three columns are needed in the google sheet. For hiding other unused columns, please follow the steps below.

Hide Unused columns in Google Sheets
If you don’t want unused rows and columns to be visible in the Google Sheets worksheet, you can easily hide these.
Below are the steps to hide unused columns in Google Sheets:
  1. Select the first column next to the last used column. You need to select the entire column by clicking on the column header at the top.
  2. Hold the CONTROL and SHIFT keys and press the right-arrow key. This will select all the unused columns.
  3. Right-click on any of the selected columns and click on the Hide Columns E-Z option (in your case, it may show different column alphabets based on what columns you have selected.
In Step 3, you can also use the keyboard shortcut CONTROL + ALT + 0 to hide all the selected columns.

You can also use the same methodology to hide unused rows as well.

No comments:

Post a Comment