Excel: rows or columns disappeared - what to do?

Entire rows or columns have disappeared in your Excel sheet and you don't know what to do. In this practical tip, we will explain how to retrieve the entries that appear to be lost.

Show missing rows or columns again

You have probably accidentally hidden the missing cells or columns.

1. To show hidden lines again, select the line above and below the lines to be displayed.
2. If the columns are hidden, select the columns to the left and right of the columns to be displayed.
3. In the Excel menu, click on "Home" and there in the "Cells" area on "Format".
4. In the open menu, select "Hide & Show" and then "Show Rows" or "Show Columns".

Retrieve deleted columns and cells

If you accidentally deleted columns and cells in Excel, you can try calling up the old version of the file.

1. To do this, go to "File" and then to "Information".
2. If you had activated the "AutoRecovery" option, you will find old versions of your file under "Manage versions".

In the next practical tip, read how to swap rows with columns.