Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
TooMuchWorkInHR
 
Posts: n/a
Default How can I highlight the cell I'm working in?

I am working in a very large worksheet and often cannot locate what cell I
left off at while I scroll to see other data. Is there a way I can change
the display so that the cell I am working in will change to a certain color
or the cell will be temporarily selected with a thicker border?
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson
 
Posts: n/a
Default How can I highlight the cell I'm working in?

maybe....

you may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

TooMuchWorkInHR wrote:

I am working in a very large worksheet and often cannot locate what cell I
left off at while I scroll to see other data. Is there a way I can change
the display so that the cell I am working in will change to a certain color
or the cell will be temporarily selected with a thicker border?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default How can I highlight the cell I'm working in?

Download Chip Pearson's ROWLINER add-in is the easiest method.

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


Gord Dibben MS Excel MVP


On Fri, 13 Jan 2006 09:07:02 -0800, TooMuchWorkInHR
wrote:

I am working in a very large worksheet and often cannot locate what cell I
left off at while I scroll to see other data. Is there a way I can change
the display so that the cell I am working in will change to a certain color
or the cell will be temporarily selected with a thicker border?


  #4   Report Post  
Posted to microsoft.public.excel.setup
David McRitchie
 
Posts: n/a
Default How can I highlight the cell I'm working in?

If all you want to do is to return to the last selected cell, then
look at the Name Box to the left of the Formula Bar,
simply click on the Name Box then hit Enter. If you set the
mouse wheel button to Enter you can do it all from the mouse.

In case you have not noticed the column letter and the row number
are shaded as well as being shown in the Name Box. Varies a bit
with the version of Excel, but in Excel 2002 the borders are very broad
around the selection range..

Actually I'd never thought of doing that before, I guess I never
stray that far.

Rowliner is nice but macros prevent you from using the undo key and
since rowliner is running continuosly that is not a very good trade-off.
This is also a problem if an Event macro is triggered everytime you
select a cell.

My Notes on Mouse Wheel and Button Settings
for Excel and other applications
http://www.mvps.org/dmcritchie/excel/mouse.txt

Another macro of interest might be
Repositioning screen and/or active cell (#TopLeft)
http://www.mvps.org/dmcritchie/excel...oc.htm#TopLeft
which attempts to show at least some cells to the left of the
active cell, which may be of use after a Find. Actually I'm more
likely to incorporate it into another macro. than use it directly.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TooMuchWorkInHR" wrote...
I am working in a very large worksheet and often cannot locate what cell I
left off at while I scroll to see other data. Is there a way I can change
the display so that the cell I am working in will change to a certain color
or the cell will be temporarily selected with a thicker border?



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
How to highlight an Excel row by clicking on a cell Marikay Excel Worksheet Functions 1 September 8th 05 02:47 PM
Highlight Cell when value reaches every interval of 500 Walt Matchim Excel Discussion (Misc queries) 7 September 2nd 05 08:14 PM
highlight range if cell contains desired data The Other Bollinger New Users to Excel 7 March 24th 05 02:30 AM
Highlight a row if a specific cell is specific numbers/words sea0221 Excel Worksheet Functions 2 March 9th 05 01:06 AM
How do I have an active cell highlight automatically lstuckey Excel Discussion (Misc queries) 2 February 14th 05 09:28 PM


All times are GMT +1. The time now is 06:53 PM.

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"