Unhide Rows In Excel For Free By Whitelisting

If your question is resolved, mark it SOLVED using the thread tools 3.

Click on the star if you think someone helped you Regards Ford.

If the page is scrolled up a little at the time that the Freeze Panes command is used (on the Ribbon under ViewWindowFreeze Panes) then the rows that are off the top of the screen will be permanently hidden until the Unfreeze Panes command is used.

He has over two years of experience writing and editing technology-related articles.

Double-click the Excel document, or double-click the Excel icon and then select the documents name from the home page.

This will open your document that has hidden columns in Excel.

Hold down the Shift key while you click the letter above the column to the left and then the column to the right of the hidden column.

The columns will be highlighted when you successfully select them.

Doing so will ensure that the Home toolbar is displayed below the green ribbon.

This option is below the Visibility heading in the Format drop-down menu.

Doing so will immediately unhide the column thats between the two selected columns.

To widen the column, position your cursor on the right border of the column, and drag the column to increase its width.

You can then proceed with the remaining steps in this article to unhide those columns.

Open your Excel document.

Select the columns on both sides of the hidden column.

Click Home 4. Click Format 5.

Select Hide Unhide 6.

By continuing to use our site, you agree to our cookie policy.

Unhide Rows In Excel For Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

Unhide Rows In Excel For Mac