To unhide columns in Excel, the common methods are:
- Select the adjacent columns around the hidden columns, right-click, and choose "Unhide."
- Alternatively, double-click the double line between the column headers where columns are hidden.
- A keyboard shortcut to unhide is: press ALT, then H, then O, then U, then L in sequence.
- To unhide all columns at once, select the entire sheet (Ctrl + A), then use the ALT → H → O → U → L shortcut.
- To unhide specific multiple columns, select the range that includes the hidden columns plus one column on each side, and then right-click and "Unhide" or use the shortcut.
If columns A or B are hidden and difficult to unhide, you can try using the Go To dialog (press F5), enter the range A1:B1, then manually set column width via Home > Format > Column Width to a visible size like 10. These methods apply across recent Excel versions including Microsoft 365 and Excel 2024.
