ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Moveable Placemarker (https://www.excelbanter.com/excel-discussion-misc-queries/209110-moveable-placemarker.html)

Tim Magee

Moveable Placemarker
 
When working on large spreadsheets with many rows on one screen, it is easy
to lose track of exactly where you have been working.

One can highlight a row by clicking on the extreme left column - but that
highlighting dissappears if you click anywhere else.

Is there a way to create a highlight for a row that one can move up and down
with the arrow keys or some other combination of keys -- as your work
position changes.

This would be a handy feature if your are comparing two spread sheets
side-by-side -- or if the telephone rings and you can't remember where you
were on the spread sheet after the call.

Thanks much.

Tim Magee

Dave Peterson

Moveable Placemarker
 
You may want to try Chip Pearson's addin:
http://www.cpearson.com/excel/RowLiner.htm


Tim Magee wrote:

When working on large spreadsheets with many rows on one screen, it is easy
to lose track of exactly where you have been working.

One can highlight a row by clicking on the extreme left column - but that
highlighting dissappears if you click anywhere else.

Is there a way to create a highlight for a row that one can move up and down
with the arrow keys or some other combination of keys -- as your work
position changes.

This would be a handy feature if your are comparing two spread sheets
side-by-side -- or if the telephone rings and you can't remember where you
were on the spread sheet after the call.

Thanks much.

Tim Magee


--

Dave Peterson


All times are GMT +1. The time now is 01:08 PM.

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