Show hidden columns in Excel again
Hidden columns make Excel spreadsheets compact, but the show function is well hidden. This is how you make hidden columns visible again.
Video tutorial: Show hidden columns in Excel again
Excel: Show individual columns again
- To show individual columns again, select the two columns to the right and left of them.
- Right-click on the "Show" option. The hidden column is now displayed again.
Show all hidden columns in Excel again
- To show all hidden table columns again, use the key combination Ctrl + A to mark the entire page.
- Then right-click on the "Show" option as described above.
Show and hide columns in Excel
- To hide one or more columns in Excel using the menu, click "Format" under "Cells" in the "Start" tab.
- Under "Visibility" you can show and hide columns, cells and entire Excel sheets.
In the next practical tip, we will show you how you can adjust the print area in an Excel table.