 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2004In excel, how do I shade every other line in the rows?
In excel, how do I shade every other line in the rows? Hi see: http://www.cpearson.com/excel/banding.htm  Signature-- Regards Frank Kabel Frankfurt, Germany > In excel, how do I shade every other line in the rows? Look at Chip Pearson's site; in particular: http://www.cpearson.com/excel/banding.htm Regards Trevor > In excel, how do I shade every other line in the rows? IN an empty spreadhseet, hightlight Row 2 and change it to the colour of your choice. Now highlight row 1 and row 2, press on the formatting button (the paintbrush) and drag from row 3 down as far as you like. This will colour every second row in the colour you selected. Hope this helps.. > Look at Chip Pearson's site; in particular: > [quoted text clipped - 5 lines] > > > In excel, how do I shade every other line in the rows? Unfortunately, this method will not survive sorting, inserting and deleting rows. The CF method at Chip's site will. Gord Dibben Excel MVP >IN an empty spreadhseet, hightlight Row 2 and change it to the colour of your >choice. Now highlight row 1 and row 2, press on the formatting button (the [quoted text clipped - 12 lines] >> >> > In excel, how do I shade every other line in the rows? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.