How to unhide column a in excel 2010

Click the Home tab at the top of the window. Whether your data is in a range or a table heres how to unhide columns or rows.

Select a cell in the row you want to hide then press Ctrl9To unhide select an adjacent column and press CtrlShift9.

How to unhide column a in excel 2010. Unhiding the First Column in Excel 2010 Step 1. Open your spreadsheet in Excel 2010. Click inside the Name field at the top-left of the spreadsheet.

Type A1 into this field then press the Enter key on your keyboard. Click the Home tab at the top of the window. How do I unhide column A in a sheet in Microsoft Excel 2010.

Select the Home tab from the toolbar at the top of the screen. In the Editing group click on the Find button and select Go To from the popup menu. When the GoTo window appears enter A1 in the Reference field and click on the OK button.

Select the column to the right and the column to the left of the hidden column. In this example column B is hidden. Right-click and select Unhide from the popup menu.

Now column B should no longer be hidden. 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.

In the Name Box next to the formula bar type A1 and then press ENTER. On the Home tab in the Editing group click Find Select. 1 Select the column or row headings you want to hide.

Press the Ctrl key while selecting multiple rows or columns. If you want to unhide rows or columns select the rows or columns both before and after the hidden rows or columns. 2 Click the Format button in the Cells group on the Home tab.

Open your Excel document. Double-click the Excel document or double-click the Excel icon and then select the. Select the columns on both sides of the hidden column.

Hold down the Shift key while you click the letter above the. Click the Home tab. Its in the upper-left side of.

Dont panic column A isnt gone forever and theres more than one way to unhide it. Click column Bs header cell and drag the mouse pointer to the left. Dont click any borders just drag the selection.

Hover the mouse over column Bs header cell and move left. When the pointer changes from the. How to unhide column A by selecting it Click on the header for column B to select it.

Drag your mouse pointer to the left until you see the border change its color. It means column A is selected though you dont see it. Now with all these columns selected right-click on the column header.

This will open a popup menu select the unhide option and the hidden columns will be visible. Unhide Columns in Excel Using the Shortcut. Actually Microsoft Excel has provided certain shortcut keys for hiding rows and columns in your spreadsheets.

In desired spreadsheet select the rows for multiple non-contagious selection hold Ctrl key you want to hide and navigate to Home tab. From Cells group click Format button. Now from Hide Unhide options click Hide Rows.

Upon click it will automatically hide the selected rows. To unhide the first column select the Home tab from the toolbar at the top of the screen. In the Editing group click on the Find Select button and select Go To from the popup menu.

When the Go To window appears enter A1 in the Reference field and click on the OK button. How to Unhide Columns in Excel Select the columns that you want to unhide. You can do this by either.

To select columns A-D including hidden columns B C click on header A and drag across to header D. Select a cell in the column to hide then press Ctrl0To unhide select an adjacent column and press CtrlShift0. Select a cell in the row you want to hide then press Ctrl9To unhide select an adjacent column and press CtrlShift9.

You can also use the right-click context menu and the format options on the Home tab to hide or unhide individual rows and columns. Thats all J The hide button will be displayed next to the last column above. Selecting the option Format from the Cells group of the Home tab on the Excel ribbon and from within the Format drop-down menu selecting Hide Unhide-Unhide Rows.

Even when the first column is hidden Excel allows you to select it and drag it to make it visible. To do this hover the cursor on the left edge of column B or whatever is the leftmost visible column. The cursor would change into a double arrow pointer as shown below.

Hold the left mouse button and drag the cursor to the right. To hide a row or column you click the header to select the entire row or column right-click the selection and choose Hide from the resulting context menu. To hide multiple noncontiguous rows or.

These double lines mean that some columns and rows are hidden. To see the hidden data unhide those columns or rows. Whether your data is in a range or a table heres how to unhide columns or rows.

Select the columns before and after the hidden columns like columns C and F in our example.