Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to highlight an Excel row by clicking on a cell | Excel Worksheet Functions | |||
Highlight Cell when value reaches every interval of 500 | Excel Discussion (Misc queries) | |||
highlight range if cell contains desired data | New Users to Excel | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
How do I have an active cell highlight automatically | Excel Discussion (Misc queries) |