ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2002: Can I have a moving colored band for active row ? (https://www.excelbanter.com/excel-discussion-misc-queries/238974-excel-2002-can-i-have-moving-colored-band-active-row.html)

Mr. Low

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

Pete_UK

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




All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com