how to unhide a column in excel document

Or select the first row and hold down the Shift key while selecting the last row.

To select multiple contiguous rows, drag across the row headings using the mouse.

To select one row, click on its heading.

Cannot unhide rows in Excel - solutions to common problemsĪs is the case with nearly all common tasks in Excel, there is more than one way to hide rows: by using the ribbon button, right-click menu, and keyboard shortcut.Īnyway, you begin with selecting the rows you'd like to hide:.

Tips and tricks for hiding and showing rows.

This article will teach you both options. On the other hand, when updating your own sheets or exploring inherited workbooks, you would certainly want to unhide all rows and columns to view all data and understand the dependencies. This technique is often used to conceal sensitive data or formulas, but you may also wish to hide unused or unimportant areas to keep your users focused on relevant information. If you want to prevent users from wandering into parts of a worksheet you don't want them to see, then hide such rows from their view. It also explains how to show hidden rows in Excel and how to copy only visible rows. Then, right-click and pick “Unhide” in the shortcut menu.The tutorial shows three different ways to hide rows in your worksheets. You can do this easily by dragging through them. Select the columns on each side of the hidden column(s). When you’re ready to view those hidden columns, unhiding them is just as simple as hiding them. RELATED: How to Freeze and Unfreeze Rows and Columns in Excel Unhide Columns in Microsoft Excel If you’d like to keep certain columns on screen while you scroll through your spreadsheet, learn how to freeze columns and rows in Excel. This is a good thing to keep in mind if you’re looking for data you don’t see. If you’re using a Mac, this indicator may appear as a bold green line. Right-click one of them and pick “Hide” in the shortcut menu.Īfter you hide columns in Excel, you’ll see a thick white line indicator between the remaining column headers.

Once you choose the columns you want to hide, they’ll be highlighted. To select multiple non-adjacent columns, click the first column header, hold Ctrl, and click the remaining column headers.Or you can click the first column header, hold Shift, and click the last column header in the range. To select multiple adjacent columns, drag through them.To select a single column, click the column header.And, you can select the columns you want to hide in a few different ways.

How to unhide a column in excel document