#UNHIDE A COLUMN IN EXCEL HOW TO#

Note that this same method will also work to unhide the first row of your spreadsheet, except you will need to select the Unhide Rows option in Step 6 instead.

2 To do this, you need to press ( CTRL + SHIFT + 0 ) keys and it will unhide columns of the current selection in Excel.

#UNHIDE A COLUMN IN EXCEL HOW TO#

Both of these settings can often make it appear that a row or column is hidden when it is simply off screen. How to use keyboard shortcut to unhide columns in Excel Shortcut Description: 1 This shortcut key will unhide columns that intersect the current selection. You may want to consider unfreezing the panes in your worksheet, or removing a split screen. If you are still unable to see the first column of the worksheet, then it may not actually be hidden. Step 6: Click the Hide & Unhide option, then click Unhide Columns.Д¬olumn вЂњAвЂќ should now be visible in your spreadsheet. Step 5: Click the Format button in the Cells section of the Office ribbon. Right-click the selected row (s) or column (s) and select Unhide from the contextual menu. Click the Format button under the Home tab. Step 4: Click the Home tab at the top of the window. Select the rows or columns that surround the hidden row (s) or column (s). Step 3: Type вЂњA1вЂќ into this field, then press the Enter key on your keyboard. So for example, I can hide ever other column in this table. When youre hiding and unhiding rows and columns, you can make multiple selections before you use shortcuts. Step 2: Click inside the Name field at the top-left of the spreadsheet. To unhide rows again, make a selection that spans hidden rows, and use Control Shift 9. Step 1: Open your spreadsheet in Excel 2010. If you wish to unhide all of the hidden columns in your spreadsheet, then you can follow the steps here. If there are other hidden columns, they will remain hidden. The procedure below will only unhide column вЂњAвЂќ.

The steps in this article will assume that you have hidden the first column in your Excel spreadsheet. Now you should be able to see column A in your Excel spreadsheet. Select Cells > Format > Hide & Unhide > Unhide Columns. An alternative would be to simply unhide all of the columns that are hidden in the spreadsheet, but this can be problematic if there are other columns that you wish to remain hidden.ДЇortunately it is possible to unhide only the first column in your spreadsheet by following the procedure outlined below. Select the Home tab from the toolbar at the top of the screen. ItвЂ™s that easy, thereвЂ™s a feature to unhide columns built right into the first layer of. Use your mouse to right-click within the worksheet. The typical method for unhiding a column will not apply when the column that is hidden is the leftmost one in the worksheet. ItвЂ™s a three-step process to unhide every column in Excel at once: Select every cell in your worksheet by clicking on the small triangle located to the top left of the sheet. Unhiding the first column, or column вЂњAвЂќ in an Excel spreadsheet presents a unique challenge.

Unhide a column in excel