![how to unhide a column in excel 2010 how to unhide a column in excel 2010](https://i.ytimg.com/vi/lFdU9lDacSs/maxresdefault.jpg)
![how to unhide a column in excel 2010 how to unhide a column in excel 2010](https://support.content.office.net/en-us/media/8d99789f-5411-4fb8-886a-5f4a894e6bb8.png)
![how to unhide a column in excel 2010 how to unhide a column in excel 2010](https://www.techonthenet.com/excel/columns/images/unhide_colA2007_001.png)
To unhide worksheets, follow the same steps, but select Unhide. I am used to hiding and unhiding columns, but now my excel sheet refuses to show me the first column I have tried 'select all + right click + unhide' and just 'selecting the first visible column + right click + unhide'. You can do as this: Supposing you have a range of data, and they have been filtered as you need, see screenshot: 1. Then press Alt + F11 to open the Microsoft Visual Basic for Application window. With this SUBTOTAL function which ignores rows that have been excluded by a filter, you can easily add up only the visible cells. First, create your drop down list with Yes and No which you need. As above example mentioned, to hide or unhide columns C to I based on the drop down list selection, please do as follows. On the Home tab, click Format > under Visibility > Hide & Unhide > Hide Sheet. Hide or unhide columns based on drop down list selection in Excel. Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. Then hold down Command while you click the tabs of the other sheets that you want to select. When we work with certain list of data there may times we don't want to see part of the data very often. (2) To unhide the column, use the keyboard shortcut Ctrl+Shift+zero. Even though Excel has column F hidden, the Name Box still takes us to F1. Unhide Columns in Excel Different Methods to Unhide Columns in Excel. Then hold down Shift while you click the tab for the last sheet that you want to select.Ĭlick the tab for the first sheet. Alternatively, we can navigate directly to column F and unhide using a shortcut key, as follows: (1) Type F1 into the Name Box and press Enter. Hide UnHide Columns in Excel Worksheet using VBA - ANALYSISTABS - Innovating Awesome Tools for Data Analysis. If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab.Ĭlick the tab for the first sheet. Select the worksheets that you want to hide.