![unhide a column in excel 2003 unhide a column in excel 2003](https://www.techonthenet.com/excel/columns/images/unhide001.png)
Select the Home tab from the toolbar at the top of the screen. If you want to see the hidden information again, simply right click on the space the column should be and click “Unhide.” How do I unhide column A? Or, you can right-click on any visible tab, and select Unhide. On the Home tab, click on Format in the Cells group and then under Visibility, select Hide & Unhide, then Unhide Sheet.
![unhide a column in excel 2003 unhide a column in excel 2003](https://contexturesblog.com/wp-content/uploads/2012/09/freezepanes03.png)
How do I unhide hidden columns in Excel 2007? Tip: If you don’t see Unhide Columns or Unhide Rows, make sure you’re right-clicking inside the column or row label. If you don’t see the first column (column A) or row (row 1) in your worksheet, it might be hidden.To unhide row 1, right-click the row 2 header or label and pick Unhide Rows. Click the Sort & Filter button on the Home tab of the ribbon and then click ‘clear’.On the Home tab, click on the Format icon Choose Hide & Unhide from the dropdown menu then select Unhide Rows. If you select all the rows and click ‘unhide’ and they do not show up, then they are filtered and not hidden. Alternatively, you can select a row or rows, and then press Ctrl-9. If you’re trying to unhide rows at the top of the worksheet, click on the first visible row, and then move your mouse up to the top of the screen. You should now be able to see all of your columns.Now right-click anywhere in the entire selection and choose the Unhide option from the menu.Click on the small green triangle in the top left corner of your spreadsheet.
![unhide a column in excel 2003 unhide a column in excel 2003](https://images.tips.net/S22/Figs/T6255F1.png)
Fortunately, you can use the “Unhide” command to make individual or all hidden columns visible again. It just means that you accidentally used the “Hide” feature on the missing columns. Now you should be able to see column A in your Excel spreadsheet. Select Cells > Format > Hide & Unhide > Unhide Columns. How do I unhide column A and B in Excel 2007? Then, select Unhide and Excel will expose the hidden row or column.Then, choose Row or Column from the Format menu, and select Unhide. Next, click the Format dropdown in the Cells group (on the Home tab) and choose Hide & Unhide. 15 How do I unhide all columns and rows in Excel?Įxcel will select cell A1, but you won’ t see that happen, because the cell’s hidden.14 How do you unhide columns in Excel without right clicking?.12 How do you unfreeze a column in Excel?.11 What is the shortcut key to unhide columns in Excel?.8 How do I unhide hidden columns in Excel 2007?.5 How do I unhide the top row in Excel?.4 How do I unhide all columns in Excel?.3 Why has Column A disappeared in Excel?.2 How do I unhide column A and B in Excel 2007?.