Next, in the Home tab click on the Sort & Filter button and then click Filter. In the example screenshot below, we clicked on “A”, held down Shift, and clicked “C” in order to select columns A through C for all rows. A quick way to do this is by clicking on the first column and then holding Shift and clicking on the last column. Let’s look at one method.įirst, select the columns that you would like sorted. There are a couple of ways to sort a set of data in Excel. This is where the sort function comes in. Nothing is in any kind of particular order, but we would really rather it was alphabetized. Through the sort, filter, and hide functions you can cut out a lot of excess noise. Here we will go through a few functions in Excel that will help you quickly find that data point you have been so desperately searching for. Spreadsheets can be daunting without the right tools.
Open the Google Sheets document and select the worksheet in which you want to hide the column.
#How do i hide columns in excel 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.