Basic Excel Screen Vocabulary
Any errors or omissions (excluding that it will be obsolete in a few months)?
Daily posts of Excel tips…and other stuff
Any errors or omissions (excluding that it will be obsolete in a few months)?
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
Zach:
You missed the window split handles. I’d also argue that the autosum area is distinct from the status bar based on the VBA definition of the status bar.
14 June 2006, 2:57 pmAndy Pope:
How about the Cancel (cross) and Enter (tick) icons that appear when editing formula.
No idea what it’s called but the top left corner part of the row/column headers, which will select all cells when clicked.
And to add to Zach’s suggestion the horizontal scrollbar also has a sizing handle to it’s left.
These are more indications of state but,
- manual calculations ‘Calculate’ that appears on the status bar
-additions to the title bar, such as [Group] and Book1.xls:2 indicating multiple windows
Maybe Context menus
14 June 2006, 3:52 pmJohn Walkenbach:
The screen is too narrow to show it, but the “type a question for help” thing-a-majig is missing. And, oddly, that menu bar doesn’t show a PUP v6 menu!
14 June 2006, 4:44 pmRob van Gelder:
Hi.
The area you click that joins the column and row headers - clicking it selects all of the cells.
The Select All button? what do you call it?
14 June 2006, 7:01 pmSam:
Zach…”The AutoSum Area” — There are 8 Small boxes that show different things …caps lock on.. nums lock , extent, refresh external data… a complete list is available on Arons website - xllogic.com - section - Wall of fame
John…. the menu bar does not show ASAP utilities either
15 June 2006, 1:03 amBastien:
Hello Dick,
If this is really basic vocabulary, the cell is missing.
Furthermore the stripes that show page breaks are missing.
You have displayed “status bar” twice.
What is the purpose of this vocabulary?
15 June 2006, 2:35 amI’ve create something similar but less extensive for the ASAP Utilities user guide. Basically because the guide is in English and people with for example a Dutch Excel version otherwise wouldn’t recognize any of the terms.
http://www.asap-utilities.com/blog/wp-content/the-excel-screen-in-english.gif
Jon Peltier:
Where’s the Ribbon? Contextual tabs? Big ol’ Office button?
And what’s that Floating Toolbar thingie you drew?
John, Bastien - Your menus are on the Add-Ins tab, can’t you find them?
15 June 2006, 5:21 amBrett:
Dick,
Thanks very much. I’m teaching very basic Excel courses in my office, and this graphic is extreemly useful. I’ll credit you for creating it, of course. Thanks again for a great site!!
Brett
15 June 2006, 5:57 amDick Kusleika:
Thanks for all the suggestions. First to all the add-in authors: This screen shot is from my work version of Excel. I assure you that I have your add-in loaded at home, that I use it every day, and that it’s very wonderful.
I don’t know what the purpose of this is, I just wanted to put names to all the different areas of the screen. Bastien’s is nicely done. Also to Bastien: “cell” is too basic.
and status bar is displayed twice to indicate that it extends the whole length.
I purposefully didn’t try to muck with the state of Excel because it would involve trade-offs I didn’t want to make. If I show grouped sheets, then the title bar isn’t in its “natural” state and I can’t show every state. I obviously didn’t have any trouble manufacturing a circular reference state so I could show a floating toolbar, though. I need to rethink that.
What do we call the right side of the status bar? Autosum area? Status Indicator area? What about the select all cells button? Should we call it the Select All Cells Button?
Finally, what’s a ribbon?
15 June 2006, 7:17 amAndy Pope:
The Task Pane
15 June 2006, 7:22 amThe various triangles that appear in cells; Comment, Error and Smart tag indicators
Gareth:
The little black square at the bottom-right of the current cell. I call it the fill handle.
15 June 2006, 9:38 amGareth:
.. which, now I check, is what Mr Gates call it as well …
15 June 2006, 9:53 amfrank:
Rob, Jon - The area you click that joins the column and row headers:
Following the analogy between the VBA Rows(), Columns() and Cells objects, one could call it the Cell Header.
15 June 2006, 10:23 amfrank:
The column and row header intersection in the top left corner:
17 June 2006, 12:58 amin various Excel introductions it’s called the Select All Button.
Harald Staff:
I vote for “Cell header”.
Is it possible to visualize the drawing layer ? Some drawing object above some cell content perhaps ?
Best wishes Harald
17 June 2006, 4:42 amHui...:
Those little grey dots in the bottom right hand corner of the window are called Resize Handles
The little grey dots on the Left Side of the Tool Bars are the Tool Bar Movement Handles
The Orange Cells in the Column and Row Headers are the Current Cell, Column and Row Indicators
Hui…
20 June 2006, 11:19 pmJason:
This thing is honestly a good study guide for Students taking Computer applications.
24 March 2008, 8:35 am