It also explains how to unhide a column from the context menu, how to unhide all columns in a worksheet, and how to change the width of a column to unhide it.
To unhide row 1, right-click the row 2 header or label and pick Unhide Rows. Release Update Written in Excel for Microsoft 365 version 2201 There are shortcut keys and access keys to unhide columns. But if you would rather not use your mouse, you can use the Key Tips to access the same command on the Ribbon. To unhide column A, right-click the column B header or label and pick Unhide Columns. You can use that same concept for any row or column. Now, I'll go to the Home tab, then to the Cells group, click the down arrow under Format, and follow it down to Hide & Unhide, then choose Unhide Columns: You can also just go up into the Nam Box and type F1 in and when you hit Enter, your cursor will now be in cell F1. When I hit OK, you'll see by the Name Box that my cursor is now in cell F1: To unhide select the columns/rows both sides of the hidden ones, right-click and choose unhide.
The Office Document Inspector will warn you about Hidden columns and rows. Don’t use Hidden to keep confidential info away from prying eyes. Please do as follows: 1.Click Home > Format > Hide & Unhide > Unhide Sheet. To select non-adjacent columns, hold CTRL while clicking the column headers.
Select multiple columns by clicking and dragging over the column headers. To hide multiple columns, execute the following steps. So, I'll hit my F5 key which brings up the Go To dialog box and enter cell F1 to choose a cell in that column: Keep in mind that Hidden Excel elements like rows, columns, cells etc are NOT private or secure. We can apply the Unhide Sheet feature to unhide a hidden worksheet at a time in Excel. Note: to unhide a row, select the rows on either side of the hidden row, right click, and then click Unhide. By the chart I have, I can see that's in column F. Having it back to collapsed, I want to be able to display the Actual values only for May. Here the data is expanded to show the full worksheet: I've also included a small chart to show which column each month's data is in: I'm using the Grouping option to hide the details of the months. Here I have two sets of values for years 2000 to 2015, Budget and Actual. If you get a preview, look for the download arrow in the upper right hand corner. You can download the file here and follow along. In this tutorial we'll discuss how to easily unhide a row or column in a worksheet when you have multiple ones hidden, and you don't want to have to unhide the entire group to see a single row or column.