If you like that option, you should also read this previous tip on automatically inserting subtotals and grand totals. Similarly, to unhide the hidden row or column, you need to press the Unhide menu item after right-clicking on the adjacent row or column I will show you how with screenshots in the section below. Email: Phone: 97 Selective Unhiding A very useful feature in Excel is the ability to Hide and Unhide rows and. When you choose this option, Excel will examine your worksheet and automatically insert groups anywhere that it sees a total. Hiding the rows or columns in Excel is just the matter of right clicking on the column letter or row number and pressing the Hide option in the menu. Hiding and Unhiding Columns and Rows in Excel Submitted by: Debby Reigle Software Training We offer cost-effective Practical Excel training for you and your employees as well as spreadsheet development. 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. You can have groups within groups so you can show/hide multiple levels of detail.

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. I also see people hiding rows temporarily when they don’t want to see all of the detail. Hiding columns Select the column or columns you want to hide. For multiple sections hit control and select your preferred columns, right click your mouse and select hide. This is very useful if you have information in your spreadsheet that you don’t want to display but is needed for other calculations. Answer (1 of 4): So select the first column you would like to hide and right click your mouse and select hide.

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