#I HIDE COLUMNS IN EXCEL FOR MAC ANDROID#
If you use Google Sheets app on Android on iOS, you can easily hide columns there as well.īelow are the steps that will hide the columns in a Google Sheets app in an Android device (same for iOS as well): You can also use the same methodology to hide unused rows as well. In Step 3, you can also use the keyboard shortcut CONTROL + ALT + 0 to hide all the selected columns. 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.Hold the CONTROL and SHIFT keys and press the right-arrow key.You need to select the entire column by clicking on the column header at the top. Select the first column next to the last used column.If you don’t want unused rows and columns to be visible in the Google Sheets worksheet, you can easily hide these.īelow are the steps to hide unused columns in Google Sheets:
Once selected, right-click on any of the columns and click on ‘Hide Columns’ Hide Unused columns in Google Sheets The above steps also work for a range of columns and even non-contiguous columns.įor example, if you want to hide column D and G, hold the shift key on the keyboard and select both these columns using the mouse. The above steps would hide the selected column. To do this, click on the column header at the top of the working area Select the entire column (or columns) you want to hide.Hide Columns with Right-ClickĪnother quick method to hide columns in Google Sheets is by using a simple right-click method.īelow are the steps to hide a column in Google Sheets: For example, if you have selected cell A5 and you use this shortcut, it will hide the entire column A. Even if a cell in a column is selected, this shortcut will hide that column. Note: You don’t even need to select the entire column to use this shortcut to hide it.
0 kommentar(er)
