![]() Follow the same steps and select Unhide Columns to display the hidden columns.Įxcel hides columns by reducing its height to zero.Alternatively, use the commands on the Home →Cells →Format →Hide & Unhide drop-down.Now press Ctrl+0 (Ctrl + the number zero) on.Select any cell on column D, for example, cell D7, D4 or D9. For example, if you want to hide column D, then Select a cell or cells that’s part of the column.This is another way to hide and unhide columns in Excel: Right-click on the columns you highlighted and choose Unhide from the shortcut menu.Highlight multiple columns including the hidden column.After column C, column E follows, skipping columnĭ since it is hidden. Also, when a column is hidden, say column D, the Follow the same steps toĮxcel displays a narrow column heading to indicate that Kutools for Excel augments Excel with this Unhide All Ranges tool to: Quickly unhide all hidden rows and columns of active worksheet with one click. But Excel does not support you to unhide all hidden rows and columns with one click. ![]() To display the shortcut menu, and select Hideįrom the list. Since hiding rows or columns is such a handy feature, you may frequently use this feature in Excel. Then right-click the selected column or columns.Over the multiple column headers you wish to hide. Headers you want to hide, one after the other. Want to hide several columns, press down the Ctrl key whilst clicking the column Step 4: Click the Home tab at the top of. Step 3: Type A1 into this field, then press the Enter key on your keyboard. Step 2: Click inside the Name field at the top-left of the spreadsheet. Step 1: Open your spreadsheet in Excel 2010. To select a column, click the column header at the top of the sheet. If you wish to unhide all of the hidden columns in your spreadsheet, then you can follow the steps here. Select the column or columns you want to hide.This is particularly useful if you don’t want your spreadsheet users to see particular information or if you need to print a report without showing all the details.īelow are some steps you can use to hide columns and rows in In some cases, you may want to hide certain columns in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |