Colors on spreadsheed

J

Judy

Is there any way to change the color of the cell
indicator so it is easier to figure out where you are on
a spreadsheet. I have speadsheets that are really long
and I would like to figure out how to change the color so
I can easily find it on the page.
 
H

Harry

Yes you can color cells by high lighting the cells that
you want to color and then right click over them and
choose Format cells.... click the Patterns tab and then
choose the color you want and click OK.

If you hold down the Ctrl key and spin the scroller on top
of your mouse you can zoom in and out. When zoomed out
click in the color area you want to go and then zoom in
while hold down Ctrl and and scroller roller on top of you
mouse.

Hope this helps...

choose >-----Original Message-----
 
H

Harry

Yes you can color cells by high lighting the cells that
you want to color and then right click over them and
choose Format cells.... click the Patterns tab and then
choose the color you want and click OK.

If you hold down the Ctrl key and spin the scroller on top
of your mouse you can zoom in and out. When zoomed out
click in the color area you want to go and then zoom in
while hold down Ctrl and and scroller roller on top of you
mouse.

Hope this helps...
 
D

David McRitchie

Hi Judy,
I can't help but think that you are scrolling all the way up to the
top to see the headers, and scrolling back to where you were, if
that is the case you can designated rows at the top and at the
left to show as you scroll around. Similar to that to show the
column labels (column headers) at the top of each printed page.
http://www.mvps.org/dmcritchie/excel/excel.htm

Rowliner is nice but I would never use it myself because when you
use a macro you lose the use of undo (Ctrl+z). So I will point out
that the highlighting on the row header label and the column header
label change when you select a cell(s), and the cell address (or range)
is shown in the address box to the left of the formula bar. This highlighting
is much better in Excel 2000 than in previous versions.

Likewise you can select an entire row to make that row stand out
simply as a selected range.

You were also told how to color cells and ranges.

Another method of coloring is colorbands (like Green Bar computer paper)
created by Conditional Formattingwhich is on another of Chip's pages,
which may be of some help, along these lines though I don't think it is
what you are looking for.
http://www.cpearson.com/excel/colorband.htm
 
Top