Why did my columns disappear in Excel?

Do not worry — Excel did not spontaneously erase data from your spreadsheet. It just means that you accidentally used the “Hide” feature on the missing columns. Fortunately, you can use the “Unhide” command to make individual or all hidden columns visible again.

How do I get columns back in Excel?

How to unhide columns in Excel

  1. Open Microsoft Excel on your PC or Mac computer.
  2. Highlight the column on either side of the column you wish to unhide in your document.
  3. Right-click anywhere within a selected column.
  4. Click “Unhide” from the menu.
  5. You can also manually click or drag to expand a hidden column.

How do I unhide columns in Excel SharePoint?

Unhide columns

  1. Select the adjacent columns for the hidden columns.
  2. Right-click the selected columns, and then select Unhide.

Why won’t my columns unhide 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 the columns in your Excel table will get the Unhide option disabled.

Can’t see columns and rows in Excel?

On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.

How do I unhide columns to the left in Excel?


  1. Select the columns to the left and right of the column you want to unhide.
  2. Go to the Home tab and find the Cells group. Next, click on the Format tab and find Hide and Unhide in the drop-down menu.
  3. Select the Unhide Columns option and you should now see your hidden data.

What is the shortcut for hiding columns in Excel?

To hide rows or columns you just need to select cells in the rows or columns you want to hide, then press the Ctrl+9 or Ctrl+Shift+( shortcut. To unhide rows or columns you first need to select the cells that surround the rows or columns you want to unhide.

How do I unhide all rows and columns in Excel?

To unhide all rows and columns, select the whole sheet as explained above, and then press Ctrl + Shift + 9 to show hidden rows and Ctrl + Shift + 0 to show hidden columns.

How do I unhide column A and B in Excel 2010?

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Columns. Now you should be able to see column A in your Excel spreadsheet.

How do I unhide all columns and rows in Excel?

How do I unhide A1 in Excel?

When the Go To window appears, enter A1 in the Reference field and click on the OK button. Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Columns. Now column A should be unhidden in your Excel spreadsheet.

Are there any missing columns from the SharePoint list?

The “Calendar SP ID” column showed up before with no issue. The other two columns I just added yesterday and now all three of those columns won’t show up. So, yes, I made changes to the list after the flow was established.

Why are my columns not showing up in SharePoint?

I have added columns to my SharePoint list and they are not showing up in my Flow. I’ve backed out of the Flow and refreshed my screen several times. I’ve shared my Flow with someone else and they can’t see the fields. I’ve tried creating a new Flow from scratch and the fields still don’t show up.

Is the web access part missing in SharePoint Online?

Excel Web Access Web Part Missing in SharePoint Online? Fix: Excel Web Access is available only in SharePoint Enterprise edition (and in Office 365, Its only available on the Enterprise Plans E3 and E4). If you are using Enterprise edition, Make sure you have “Enterprise Site Collection Features” enabled.

Why are columns missing but not hidden in Excel?

RE: Excel – Columns Missing but Don’t Appear to be Hidden. if the column is not Hidden then maybe column width is a very small number giving the appearance of being hidden. May 04 2019 03:51 AM