streamsnax.blogg.se - Jow to unhide a column in excel

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.