Bottom Bar on excel screen....

[Flamikey]

What is it called? This is the bar where you can right click on NUM an
change the selected cells function from SUM to AVG,MIN,MAX. I do kno
that if go into ADD or EXT mode this is displayed in one of the
boxes. I can't find any info that explains this bar and what each o
the boxes are . I looked on several boards + excel help. I can't eve
find documantation on what ADD mode is in excel help. Th

 

[Peo Sjoblom]

It's called Status Bar, you can check and uncheck it under the View menu

 

[Gord Dibben]

Flamikey

EXT means you are in Extended mode. As you move the mouse, all cells will be
selected. F8 toggles in and out of Extended mode.

ADD allows you to select non-contiguous cells without holding the CRTL key.
SHIFT + F8 toggles this.

Gord Dibben Excel MVP

 

[Flamikey]

Thanks Peo. I searched for "status bar" and found a page that desribe
what all the boxes are for.

http://www.mvps.org/dmcritchie/excel/formula.htm#StatusBar

I find it amazing that there is no info on the status bar in exce
help. You would think they would explain the layout of their product.
How Microsoft has not created a hyperlinked graphical display of
spreadsheet to their help file is beyond me. The index in their hel
file is so elementary I am beginning to think thay have it that way o
purpose. How can you not perform a boolean search, after all isnt thi
supposed to be worlds leading software manufaturer? Oh well, I guess
got my daily MS rant off the to do list early today

 

[Flamikey]

Thanks Gord. I did not know about EXT and ADD. Those are very hand
and I have already begun to use this functionality. One neat thin
about Excel is there is always a new shortcut to learn

 

[Peo Sjoblom]

Thanks Peo. I searched for "status bar" and found a page that desribes
what all the boxes are for.

http://www.mvps.org/dmcritchie/excel/formula.htm#StatusBar

I find it amazing that there is no info on the status bar in excel
help. You would think they would explain the layout of their product.
How Microsoft has not created a hyperlinked graphical display of a
spreadsheet to their help file is beyond me. The index in their help
file is so elementary I am beginning to think thay have it that way on
purpose. How can you not perform a boolean search, after all isnt this
supposed to be worlds leading software manufaturer? Oh well, I guess I
got my daily MS rant off the to do list early today.

How could they charge you for support if the built in help was great? <g>
The world's biggest software manufacturer you mean? <g>


Regards,

Peo Sjoblom

 

[Andy]

For more names, got to http://www.BygSoftware.com , then click on "Naming of
Parts" in the menu.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[Flamikey]

Peo,
Touche'

Andy,
This is exactly what I was talking about. Every product you buy has
layout like this (I am sure this type of diagram has a specific name)
except MS products