Tip #077 – Excel

Excel: Alternative-row shading

You’ve got a big long spreadsheet to print. You’d like to make it easier to read by shading every other row. Do NOT (not, not, not) do it by hand (using the [CTRL] key to select every other row…because it’s incredibly wrong).


One method (you know there is always more than one way to do anything in Excel…ie, FORMAT AS TABLE (but it comes with baggage)) is to use CONDITIONAL FORMATTING. It will take of this quickly and easily for you – and allow you to insert and/or delete rows within the formatted range…without mussing up your paint job.


Full tip: Excel tip