How to unhide and show hidden columns in Excel
Hide columns. Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Right-click the selected columns, and then select Hide. Mar 16, · Show all hidden columns in Excel via Go To Special Open your workbook and navigate to the Home tab. Click on the Find & Select icon and pick the Go to Special option from the menu list. On the Go To Special dialog box, select the Visible cells only radio button and click OK.
In order to prevent affecting other cells in calculations or other works, sometimes we need displayy hide unwanted columns and rows. See screenshot :. Note : You cannot unhide all the rows and columns at a time but have to display them individually. Excel does not support you with one option to unhide all the hidden columns and rows, but the third party Kutools for Excel does.
Kutools for Excel : with more than handy Excel add-ins, free to try with no limitation in 30 days. Hjdden it Now. See screenshot:. The following examples shows how the function what is an olympic gold medal made out of. We have risplay 3, 4, 5 rows before, and then after clicking Unhide All Rangesthe hidden rows are displayed as normal.
Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account.
Exceel verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account. About Us Our team. Read More Free Download You are guest Login Now. Loading comment The comment will be refreshed after To post as a guest, your comment is unpublished.
Hidden columns and rows at a time open suggestion simple superb, thanks 2 u.
Unhide all columns in Excel automatically with VBA macro
Locate hidden cells. Press F5 > Special. Press Ctrl+G > Special. Or on the Home tab, in the Editing group, click Find & Select>Go To Special.
When you want to reveal cells that may reside in hidden rows or columns, it can be difficult to locate them. The approach is to first select all visible cells in the worksheet, which also will reveal hidden rows and columns. For more information about displaying hidden rows or columns, see Hide or display rows and columns. Select the worksheet containing the hidden rows and columns that you need to locate, then access the Special feature with one of the following ways:. Under Select , click Visible cells only , and then click OK.
All visible cells are selected and the borders of rows and columns that are adjacent to hidden rows and columns will appear with a white border. Note: Click anywhere on the worksheet to cancel the selection of the visible cells. If the hidden cells that you need to reveal are outside the visible worksheet area, use the scroll bars to move through the document until the hidden rows and columns that contain those cells are visible.
You can always ask an expert in the Excel Tech Community or get support in the Answers community. This feature is not available in Excel for the web. A subscription to make the most of your time. Try one month free. Need more help? Expand your Office skills. Get instant Excel help. Was this information helpful? Yes No. Any other feedback?
The more you tell us, the more we can help. How can we improve? Send No thanks. Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents. Contact Support.