If you like that option, you should also read this previous tip on automatically inserting subtotals and grand totals. When you choose this option, Excel will examine your worksheet and automatically insert groups anywhere that it sees a total. To undo your grouping, select the rows again and click the Ungroup button.Īt the bottom of the Group button, is a down arrow that gives you the Auto Outline option. From the Format menu, in the Visibility section, select Hide & Unhide » Hide Columns. On the Home command tab, in the Cells group, click Format. Select a cell within the column(s) to be hidden. You can have groups within groups so you can show/hide multiple levels of detail. You can hide columns of your worksheet containing information that you do not need to view or do not want to print. If you have inserted several groups you can use the 1 and 2 buttons at the top to expand or collapse all of them at the same time. Click the + button to expand the section again or unhide the rows. Click the – button and rows will be rolled up, or hidden, and the – button changes to +. Click it and a line will appear next to the selected rows in the margin and a “-” button will appear in the next row down (presumable where those rows are totaled or summarized).

On the right end of the ribbon, in the Outline section, is the Group button. Start by selecting the rows you want to be able to hide, then click on the Data tab. But if you routinely want to choose between hiding or showing certain rows you can use the Group command. That works fine if you only want to view the spreadsheet like that occasionally. In the Format Cells dialog box, click Protection tab, and then check the Locked option. For multiple sections hit control and select your preferred columns, right click your mouse and select hide. I also see people hiding rows temporarily when they don’t want to see all of the detail. Answer (1 of 4): So select the first column you would like to hide and right click your mouse and select hide. Having a reasonable number of columns, you can simply select those that have 'Blank' in the first row (to select multiple columns, hold the Ctrl key as you click the column letters). This is very useful if you have information in your spreadsheet that you don’t want to display but is needed for other calculations. You can unhide them by selecting a range of rows that includes the hidden rows, right click, and choose Unhide. You probably know that you can hide columns or rows in an Excel spreadsheet simply by selecting one or more rows or columns (for simplicity, I’ll only talk about rows, but everything here applies to columns also), then right-clicking and choosing Hide.

Hide columns in excel