But if you would rather not use your mouse, you can use the Key Tips to access the same command on the Ribbon. 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: 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: 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: Unhiding a column is a bit different from hiding. Now Column A will not appear on the screen. On the Home tab, in the Editing group, click Find & Select. In the Name Box next to the formula bar, type A1, and then press ENTER. Step 2: In Hide & Unhide select Hide Columns. Unhide the first column or row in a worksheet To select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula. Then, in the home got to format in the cells.In format choose Hide & Unhide in Visibility. I've also included a small chart to show which column each month's data is in: Step 1: Select the first cell of the column, here we are selecting A1. 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 the Editing group, click on the Find & Select button and select 'Go To.' from the popup menu. 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. To unhide the first column, select the Home tab from the toolbar at the top of the screen.

How do you unhide a column in excel