Why Cannot Unhide Columns in Excel?
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...
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?
Can't unhide rows A!:A3
- To select all cells on a worksheet, do one of the following: Click the Select All button. Press CTRL+A. ...
- On the Home tab, in the Cells group, click Format.
- Do one of the following: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns.