|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 7th, 2006, 09:57 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Shaded Rows
I have a spreadsheet I am working on and its pretty long and pretty wide. Almost 200 lines. I was wondering if it is possible, in excel, to set it up such that every alternate row is shaded. I feel that this will help me when I am referencing the printout. thanlks -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=499071 
|
|
#2
January 7th, 2006, 10:12 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Shaded Rows
To highlight every other row, check out Row Striping at this website: http://www.xldynamic.com/source/xld.CF.html#rows Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=499071
|
|
#3
January 7th, 2006, 10:27 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Shaded Rows
yup that does help.... thanks a lot buddy. Appreciate it  -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=499071
|
|
#4
January 9th, 2006, 11:09 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Shaded Rows
bombayterror wrote:
I have a spreadsheet I am working on and its pretty long and pretty wide. Almost 200 lines. I was wondering if it is possible, in excel, to set it up such that every alternate row is shaded. I feel that this will help me when I am referencing the printout. thanlks Looks like you already have a solution but here's a link to a freeware program I find very useful. http://www.asap-utilities.com/ It has many functions that can be done with just a couple of clicks. Shading every other line is as easy as clicking and selecting color and interval (every nth row). Standard disclaimer: not associated in any way, no renumeration yada yada gls858
|
|
#5
January 9th, 2006, 11:42 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Shaded Rows
installed it. You are right there is a lot of stuff in there you can use. Seems like a pretty decent add-in thanks for the info -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=499071
|
|
#6
January 12th, 2006, 03:43 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Shaded Rows
bombayterror wrote:
installed it. You are right there is a lot of stuff in there you can use. Seems like a pretty decent add-in thanks for the info No problem. Glad to help. Thanks for posting back. gls858
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Report with set number of rows per page | Ken from Chicago | General Discussion | 7 | January 4th, 2006 02:42 PM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Repeat Records - Please Help? | Repeat records | Running & Setting Up Queries | 9 | September 29th, 2004 05:29 PM |
| Conditional Hiding of Rows or Columns | sanjay_suda | General Discussion | 6 | June 18th, 2004 04:03 PM |
| Excel- Inserting a varying number of rows | Ken Wright | Worksheet Functions | 1 | March 20th, 2004 10:20 PM |
Linear Mode
