Excel Tips
October 3, 2022
My manager loves my reports with automatic subtotals but he wants the entire row in bold, not just the Subtotal By column.
Subtotals by Product Within Region »
September 30, 2022
I want to add subtotals by two fields, such as Product and Region.
Add Other Text to the Subtotal Lines »
September 29, 2022
My data set has account number in column A and a customer name in column B. When I subtotal by account and collapse using the 2 Group & Outline button, I see only the Account numbers. While I have memorized that B4504 is Bell Canada, my manager cannot seem to remember this, so I need to add the customer name to the subtotal lines.
Select 100 Columns in Subtotals »
September 27, 2022
My data set is a hundred columns wide. In the Subtotal dialog, I have to click 6 columns, then scroll, click 6 more columns, then scroll. It is incredibly tedious. Having a “Select All” button would be incredibly helpful.
Sort Largest Customers to the Top »
September 26, 2022
I added subtotals to a data set and collapsed to the #2 view. Now, my manager wants the largest customers at the top of the data set.
Copy Just Totals from Subtotaled Data »
September 23, 2022
I’ve added subtotals and collapsed to the #2 view. My manager wants me to send him just the total rows in a file. When I copy and paste, I get all of the detail rows as well.
September 22, 2022
The grouping feature feels backwards. What if I have report headings above each section and I need to group the data below the heading?
September 21, 2022
Those group and outline symbols shown in the last topic are cool. Is there any other way to get those? Can I apply them without using subtotals?
Use Group & Outline Buttons to Collapse Subtotaled Data »
September 20, 2022
I just used the Subtotal command in “Add Subtotals to a Data Set,” and now I want to print the total rows in order to create a summary report for my manager.