![]() ![]() ![]() In my example here I am using the MOD function and telling Excel to shade every second row of my P&L so that it is easier to read. If you use conditional formatting and the = MOD() function it is a quick way to create a general ledger type of effect with rows displayed in alternate colors.īelow are the steps you can use to apply a rule to data. If you have inserted new rows in an already formatted worksheet, this is a really quick way to fix any formatting problems.Īn alternative method, as mentioned above, is to use conditional formatting. Using the Shift key and the Format Painter icon together allows you to format an entire worksheet quickly. If you are formatting alternate rows or columns quickly and do want not mess around with Conditional formatting rules this is a great shortcut.ĭiana wanted to format every other row of her 1,000+ row worksheet with a variety of formats to enhance readability.Īnd voila! The formatting was automatically copied to every line in the spreadsheet. ![]() Thanks to Diana Lawless for sending in this Excel tip. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |