Make sure the checkboxes Select locked cells and Select unlocked cells are ticked. Then enter and reenter the password. From now on, anyone who tries to unhide the columns in your Excel table will get the Unhide option disabled.

Why wont Excel let me unhide columns?

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. Tip: If you don't see Unhide Columns or Unhide Rows, make sure you're right-clicking inside the column or row label.

Can't unhide Excel Cells?

1. To select all cells on a worksheet, do one of the following: Click the Select All button. Press CTRL+A. ...
2. On the Home tab, in the Cells group, click Format.
3. Do one of the following: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns.

Why is unhide sheet not working in Excel?

If the workbook contains only very hidden sheets, you won't even be able to open the Unhide dialog box because the Unhide command will be disabled. If the workbook contains both hidden and very hidden sheets, the Unhide dialog will be available, but very hidden sheets won't be listed there.

Why is unhide greyed out in Excel?

If the Unhide command is grayed out both on the ribbon and in right-click menu, that means there is not a single hidden sheet in your workbook :) This is how you unhide sheets in Excel.

Trouble Unhiding Rows or Columns in Excel

How do you unfreeze a column in Excel?

To unfreeze panes:

To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu.

How do I unhide all columns in Excel?

1. Click on the small green triangle in the top left corner of your spreadsheet. This will select the entire spreadsheet.
2. Now right-click anywhere in the entire selection and choose the Unhide option from the menu.
3. You should now be able to see all of your columns.

How do I force Excel to unhide rows?

Press Ctrl + Shift + 9 to unhide all rows or Ctrl + Shift + 0 (zero) to unhide all columns. If this doesn't work, then right-click on a row or column identifier and select Unhide.

How do you unlock hidden rows in Excel?

1. To unhide all hidden rows in Excel, navigate to the "Home" tab.
2. Click "Format," which is located towards the right hand side of the toolbar.
3. Navigate to the "Visibility" section. ...
4. Hover over "Hide & Unhide."
5. Select "Unhide Rows" from the list.

How do I unhide all columns?

1. Click on the small triangle at the top left of the worksheet area. This will select all the cells in the worksheet.
2. Right-click anywhere in the worksheet area.
3. Click on Unhide.

How do I unhide all in Excel?

1. Press Ctrl + Shift + 9 (the fastest way).
2. Select Unhide from the right-click menu (the easiest way that does not require remembering anything).
3. On the Home tab, click Format > Unhide Rows (the traditional way).

How do I unhide all sheets in Excel?

1. Right-click the Sheet tab at the bottom, and select Unhide.
2. In the Unhide dialog box, - Press the Ctrl key (CMD on Mac) and click the sheets you want to show, or. - Press the Shift + Up/Down Arrow keys to select multiple (or all) worksheets, and then press OK.

How do you Uncollapse rows in Excel?

Click at the plus sign to change it to minus sign to display the collapse columns or rows. Select the whole sheet, click Data > Ungroup > Clear Outline to display all collapse columns and rows which are grounded by the Group function.

Can't see top row excel?

1. Press F5. Excel displays the Go To dialog box. ...
2. In the Reference field at the bottom of the dialog box, enter the number of the row range that you want to unhide. ...
3. Click on OK. ...
4. Choose Row from the Format menu, then choose Unhide.

How do I remove filters from Excel?

1. Go to the Data tab > Sort & Filter group, and click Clear.
2. Go to the Home tab > Editing group, and click Sort & Filter > Clear.

How do I expand all columns in Excel?

Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.

How do you unfreeze a column?

To unfreeze panes, open your Excel spreadsheet. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Windows group. Then click on the Unfreeze Panes option in the popup menu. Now when you move around in your spreadsheet, columns and rows should display as normal.

Why can't I Unfreeze Panes in Excel?

To enable the Freeze Panes command again, you must choose either the Normal or Page Break Preview commands. You'll have to manually restore any frozen panes that you lost when you chose Page Layout view. Figure 1: Excel's Page Layout command disables the Freeze Panes command and unfreezes rows/columns, as well.

How do I unfreeze Excel not responding?

1. Install the Latest Microsoft Office. ...
2. Open and Save Excel in Safe Mode. ...
3. Make Sure Excel Is Not in Use by Another Process. ...
4. Disable Add-ins. ...
5. Investigate Excel File Details and Contents. ...
6. Check for the Program Conflict by Performing Clean Boot. ...
7. Update or Close Anti-virus Software.

What is the shortcut to unhide columns in Excel?

1. Ctrl+9 to Hide Rows.
2. Ctrl+0 (zero) to Hide Columns.
3. Ctrl+Shift+( to Unhide Rows.
4. Ctrl+Shift+) to Unhide Columns – If this doesn't work for you try Alt,O,C,U (old Excel 2003 shortcut that still works).

How do I unhide columns in Excel 2016?

1. Position the mouse pointer on column letter A in the frame and drag the pointer right to select both columns A and C. ...
2. Click the drop-down button attached to the Format button in the Cells group on the Home tab.
3. Click Hide & Unhide→Unhide Columns on the drop-down menu.

How do I hide columns in Excel without right clicking?

Hide Columns in Excel Using a Keyboard Shortcut

Press and hold down the Ctrl key on the keyboard. Press and release the 0 key without releasing the Ctrl key. The column containing the active cell should be hidden from view.

How do you make Excel sheets visible?

First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box.

How do I unhide all columns in Excel Mac?

1. Open Microsoft Excel on your PC or Mac computer.
2. To unhide all hidden columns in Excel, navigate to the "Home" tab.
3. Click "Format," which is located towards the right-hand side of the toolbar.
4. Navigate to the "Visibility" section. ...
5. Hover over "Hide & Unhide."

Can't hide Excel columns?

Hide and Unhide Columns and Rows

Click the Format button located on the Home tab / Cells group then choose Hide Columns or Rows (another option is to Right click on a highlighted column or row heading and select hide). Your Columns and Rows are now hidden.