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 ...

Learn how to use Excel's Format Painter to apply formatting to entire rows and columns. Formatting allows viewers to distinguish values by type and even sections.

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

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 ...