This short video shows you a quick way to see those hidden rows and columns again, in your Excel worksheet. The “hidden” rows or columns might reappear after that, when you scroll to the top or left of the worksheet. If there is an Unfreeze Pane command in the drop down list, click that, to unfreeze the locked sections.On the Excel Ribbon, click the View tab.To see if freezing is the problem of hidden rows or columns, follow these steps: If that selection trick didn’t work, the rows might be hidden because some of the worksheet has been locked, with the Freeze Panes command. This animated gif shows the steps for selecting the hidden rows, and unhiding them NOTE: For hidden columns, select the first visible column, and drag to the left. Then, right-click the first visible row button, and click Unhide.
The little popup shows the number of rows you’ve selected.
For rows, press on the first visible row button, then drag up, onto the Select All button. Here are the steps to see the hidden rows or columns again: However, if you hide Row 1, or Column A, in an Excel worksheet, you might have trouble unhiding them. Just select the columns (or rows) on either side of the hidden ones, then right-click, and click Unhide. Usually it’s easy to unhide rows or columns that have been temporarily hidden. Occasionally though, you might have trouble unhiding Excel row and columns. Then, right-click and pick “Unhide” in the shortcut menu.It’s easy to hide rows and columns in an Excel worksheet, and you or your boss or co-worker might do that when setting up an Excel file. 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. 
Now, column B should no longer be hidden. Right-click and select 'Unhide' from the popup menu. Or you can click the first column header, hold Shift, and click the last column header in the range. Answer: Select the column to the right and the column to the left of the hidden column. 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.
0 kommentar(er)
