A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Setting up and Configuration of Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How can I highlight the cell I'm working in?



 
 
Thread Tools Display Modes
  #1  
Old January 13th 06, 05:07 PM posted to microsoft.public.excel.setup
external usenet poster
 
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?
Ads
  #2  
Old January 13th 06, 05:36 PM posted to microsoft.public.excel.setup
external usenet poster
 
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  
Old January 13th 06, 05:57 PM posted to microsoft.public.excel.setup
external usenet poster
 
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  
Old January 14th 06, 02:45 AM posted to microsoft.public.excel.setup
external usenet poster
 
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?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 01:30 AM
Highlight a row if a specific cell is specific numbers/words sea0221 Excel Worksheet Functions 2 March 9th 05 12:06 AM
How do I have an active cell highlight automatically lstuckey Excel Discussion (Misc queries) 2 February 14th 05 08:28 PM


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


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