Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default Excel 2002: Can I have a moving colored band for active row ?

Hi,

I am working on a large spreadsheet with many rows and columns of data
without any spacing in between.

I find it difficult to read correctly the cell at 7 to 8 column a the right
or left of the the active cell.

May I know if there is a way for me to have a light color band A6:IV6 which
move along with the row where the cursor is. This is to serve as a ruler to
guide my eye while reading across the screen from left to right or the other
way round.

Thanks

Low

--
A36B58K641
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Excel 2002: Can I have a moving colored band for active row ?

You might like to try Chip Pearson's RowLiner add-in, which you can
download from he

http://www.cpearson.com/excel/RowLiner.htm

Hope this helps.

Pete

On Aug 5, 2:30*pm, Mr. Low wrote:
Hi,

I am working on a large spreadsheet with many rows and columns of data
without any spacing in between.

I find it difficult to read correctly the cell at 7 to 8 column a the right
or left of the the active cell.

May I know if there is a way for me to have a light color band A6:IV6 which
move along with the row where the cursor is. This is to serve as a ruler to
guide my eye while reading across the screen from left to right or the other
way round.

Thanks

Low

--
A36B58K641


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002: How to conditional format band of colors ? Mr. Low Excel Discussion (Misc queries) 2 November 4th 08 01:45 PM
excel 2002 missing active title bar denisdasmenace Excel Discussion (Misc queries) 1 August 5th 08 04:32 PM
Excel 2002 : Is there any active row bar to aid data entry ? Mr. Low Excel Discussion (Misc queries) 3 February 8th 07 08:32 PM
Excel 2002 : How to move to the last line of the active worksheet Mr. Low Excel Discussion (Misc queries) 9 December 15th 06 11:37 PM
Add colored horizontal band to scott Charts and Charting in Excel 1 September 25th 06 09:38 AM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"