Before you can set the conditional format, remove the subtotaling rows by clicking Subtotal (Data tab) and clicking Remove All. Assuming you want the entire row formatted, select the data set, B3 ...

This is the demonstration file to accompany the article, How to display multiple grand total rows in a Microsoft Excel PivotTable by Susan Harkins.

Choose the date format that matches your audience. If you share files with an international workgroup, you may need to place the month after the date instead of before it.

And, once a table is created, how do we custom filter, format, ... We’ve provided this sample spreadsheet so ... Type the name of the new column in row 3 and notice that Excel adds the filtering ...

To get the exact format you want in Excel, it's often necessary to adjust the row heights to a specific size. By default, Excel rows are 12.75 points high, which is the typographical equivalent ...

JD Sartain. Use View > Split to split or unsplit a screen in Excel.. 2. Freeze Frames. The other great feature for large spreadsheets is Freeze Frames. People generally freeze frames so they can ...