Why are columns missing in Excel?

Why are columns missing in Excel?

Open your Excel spreadsheet. You can also click "Ctrl-A" to select the entire spreadsheet. Click "Format" in the Cells group of the Home tab. Select "Visibility," and then select "Hide & Unhide" and "Unhide Columns" to make all missing columns visible.

How do I unhide all columns?

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. Note that you need to select the identifier—you can't just click anywhere and select Unhide using this particular method.

What is the shortcut in Excel to unhide column A?

This Excel Shortcut unhides a column or columns from a worksheet. Remember This Shortcut: Same as the hide column shortcut (Ctrl + 0), except add shift to unhide (Ctrl + Shift + 0) instead.

How do I unhide column A in Excel 365?

You can select a worksheet from any open workbook. Click the “Show row and column headers” check box so there is NO check mark in the box. Click “OK” to accept the change and close the “Excel Options” dialog box. The row and column headers are hidden from view on the selected worksheet.