How to group rows and columns in Excel

By July 24, 2017 May 22nd, 2018 Tech Tip
Grouping in Excel

Grouping rows or columns in Excel can be very useful if you want to visually group items under a heading, or if you want to be able to hide or show data for better display. Grouping can be very useful in accounting spreadsheets. This is how you do it!

Grouping rows or columns

  1. In your Excel spreadsheet, select the cells that you want to collapse. Do not select any cells that you want to remain visible – such as headings or labels or totals.
  2. With your cells selected, go to Data on the Ribbon toolbar. On the far right side, in the Outline group, click the Group button.
  3. Choose “Rows” (to collapse vertically) or “Columns” (to collapse horizontally).Grouping rows and columns in Excel
  4. Click OK.
  5. A collapse/expand icon will appear in the left margin for rows and in the top margin for columns. You can use this to “toggle” between the open and closed states.

Grouping rows and columns in Excel

Keep in mind when choosing between rows and columns to collapse that you cannot just collapse cells. If you have additional data in the same row – but farther to the left or right of your selected data – that data will collapse into the group as well. The same goes for choosing “column”, as data above or below your selected cells in the same columns will also collapse.

Ungrouping

If you want to remove your grouping, select the grouped rows or columns again. Go back to Data > Outline on the Ribbon toolbar, and choose Ungroup.

Moving the summary rows/columns

If you want your summary rows and thus your expand/collapse icon to be at the top or the bottom of grouped rows, or the left or right of grouped columns, you can change the placement. Go to Data > Outline on the Ribbon toolbar. Click the expand icon for advanced options in the bottom right corner of the Outline group.

 

If you leave the Direction options unchecked, the summary rows will be at the top of grouped rows and to the left of grouped columns. Switch the direction by selecting the option to move to below or right.


Recent Posts / View All Posts

Create Rules to Automatically Sort Incoming Mail in Outlook

| Tech Tip | No Comments
When you receive a lot of email, your inbox becomes cluttered and difficult to navigate. Thankfully, you can use create Rules in Outlook to sort your incoming email. Here are the steps to set up a rule in Outlook that will automatically put incoming mail from a particular sender into a specific folder: Select an email in your Inbox from the sender you’d like to create a new folder for. Go to Rules > Create Rule on the toolbar. Check the “From…” box at the top of the Create Rule window. Check “Move the item to folder:” at the bottom…
Dictate in Office 365

Dictate Instead of Typing in Office 365 Apps

| Office 365, Tech Tip | No Comments
Did you know that in many Office 365 applications you can dictate text instead of typing it? You may find this useful, especially if you need to respond to an email message and your hands aren’t free, or if you want to brainstorm out loud and capture your thoughts without taking notes by hand. First you should check if you have a working microphone. If you're using Windows 10, you can use the Voice Recorder app to do a test. Open this program and record a small snippet of audio. Play it back in order to see if your microphone…
Voting Options in Outlook Email

How to Add Voting Options to an Outlook Email

| Tech Tip | No Comments
Need to take a quick poll? Maybe you need to find out how many people in the office are coming to lunch – and this quick tip will show you how the voting options work in Outlook! To making voting options available in an email you are composing: Click on the Options tab on the Ribbon. In the middle of the ribbon, click on Use Voting Options, and select which answers you want to make available. After clicking, you should see an information message that says “You added voting buttons to this message”. Send your email! Recipients will receive your message with…