Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel 2003:
When dealing with large spreadsheets and trying to scan across the sheet to read/edit data it would be helpful if you could format large areas of cells to appear as alternate black/white rows. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
When I want to do this, I use a standard feature of ASAP Utilities, a free
Add-in available at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "jjaammess" wrote: Excel 2003: When dealing with large spreadsheets and trying to scan across the sheet to read/edit data it would be helpful if you could format large areas of cells to appear as alternate black/white rows. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You can do this with Conditional Formatting, which will preserve
the colors when sorting or copy/pasting. See www.cpearson.com/excel/banding.htm I "jjaammess" wrote in message ... Excel 2003: When dealing with large spreadsheets and trying to scan across the sheet to read/edit data it would be helpful if you could format large areas of cells to appear as alternate black/white rows. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is my printer printing white fonts as black? | Excel Worksheet Functions | |||
convert a graph to black and white | Charts and Charting in Excel | |||
How do I change all chart colors to black and white? | Charts and Charting in Excel | |||
Why does the blank cells blink black and white on my excel spread. | Excel Discussion (Misc queries) | |||
Convert diagram bars to black and white | Charts and Charting in Excel |