Add subtotals as described previously.The manager may be smart enough to want to stop at each subtotal by pressing the End key, and this will not work with the double-height rows.Īlternate Strategy: This method is far more complex than the one just described but creates the desired result. This method will not work if you have to send the data set to the manager via e-mail. There is not a blank row between rows 8 and 9.Choose the 3 Group & Outline button to display the detail rows again.Īlthough you can see that there is no blank row after the subtotals in rows 8 and 13, when you print the report for your manager, it will appear to have a blank row.In the Home tab of the ribbon, click the Align Top icon.
Mentally multiply by 2 and type 25.5 as the new height.
Depending on your font, the row height will probably be between 12 and 14. Select Home, Format dropdown, Row Height.(You can use Alt+ as the shortcut for Visible Cells Only.) Select Home, Find & Select, Go To Special, and from the Go To Special dialog, select Visible Cells Only and click OK.To do this easily, add subtotals, collapse to level 2, and select all subtotal rows from the first subtotal to the last subtotal.It will give the appearance that a blank row has been inserted. This method may work if you are printing the report to give to the manager. The first method is to try to fool the manager by making the total rows double height, with the totals vertically aligned to the top. The second method is convoluted but about 50% easier than the method I described in the previous edition of this book. One method is simpler but is really cheating you only make it look like you added a blank row. There are two methods that will work here. But there is no built-in way to do this with Excel. Quite simply, data looks better when it is formatted this way. Strategy: This is a fairly standard request. Problem: My manager wants me to add a blank line between sections of a subtotal report.
0 kommentar(er)
