Little Known Excel Shortcut #11
By BankersBall on Apr 2, 2007 in Excel, Excel Shortcuts
 |
SHORTCUT:
Select entire sheet.
Hit Alt + O + D.
In “Formula Is” type =MOD(ROW(A1),2)=0
Select pattern/shade for every other row
PURPOSE:
Use conditional formatting to shade every other line.
FURTHER EXPLANATION:
You can also just do an even number of lines and paste format, but this does the entire sheet. Source: GRBPS.
On Apr 3, 2007, Joshua Hiam RosenBlatt said:
Control + V = paste