Excel Basics

Toolbar Buttons


Toolbars are designed to help users.  They are generally located at the top of the program window, under the menu bar, although they are movable. 

We access toolbar buttons using the mouse, by pointing to one of the available choices and clicking the left mouse button.  It is usually a good idea to know what each button means.  When you point to a button and let the arrow rest on it for a second or two a short pop up description will appear.

It should be noted, that you can turn toolbars on and off.  New users often turn them off without realizing it.  If your toolbar has disappeared, point to the area located just below the menu bar, tap your right mouse button and choose the desired toolbar from the list provided.

 

Although you can customize all toolbars, the following are the buttons available on the Standard Toolbar.

Button
Shortcut
Menu location
Description
CTRL N
Starts a new document using the default settings
File, New
Opens the "New" dialog box
New document. Open a blank piece of paper using the default settings or choose a predefined template.

CTRL O File, Open Open an existing document(s). All three options will open the "Open" dialog box. 
CTRL S File, Save Save the current file. When the document is new, the "Save as" dialog box will open, requesting a filename be assigned.
CTRL P
The full document will print
File, Print Print function. Each access method will cause the program to react differently. 
  File, Print Preview Print Preview - Gives the user a visual representation of what the file will look like in a printed form. 

CTRL X Edit, Cut Cut - Removes the contents of a selection (text, object) and places them in the clipboard. 
CTRL C Edit, Copy Copy - Copies the contents of a selection (text, object) and places them in the clipboard.
CTRL V Edit, Paste Paste - Places the contents of the clipboard where ever the cursor is placed.
CTRL+SHIFT+C Copy formats 
CTRL+SHIFT+V Paste formats 
Format Painter, copies the format of a word, selected text, an entire paragraph, graphics boxes, tables, and cells within tables.
CTRL Z Edit, Undo Undo - Reverses the last action(s) 
 CTRL Y Edit, Redo Redo - Reverse the last undo
  Insert, Hyper link Hyperlink - inserts a hyperlink, such as a URL into the current document.
    Activates the Web Toolbar
    The AutoSum function will insert the Sum formula and try to choose the range for you. 
  Table, Insert Table Creates a table using a drag action.
  View, Zoom Increase/decrease the magnification of your document. 
  Help When you choose this button, the office assistant will open and ask you for the question you need help with.

back

top

 

 

 

Have a problem and can't find the answer on our site?   Click Here To Contact Us.  
Due to the awful amount of spam we are receiving -
make sure you remove the EraseMeFirst after the com in the email message

Want to know what people say about us?  Visit our Comments page.

Let us know what you think about our site or want to offer any suggestions. 
Click here to send us feedback
Due to the awful amount of spam we are receiving -
make sure you remove the EraseMeFirst after the com in the email message


Thanks for visiting
 ER  Computer  Services

Home

ER Home Page

Drop us a line

Computer Help

Fun Stuff

Search our site

What we do

Site Map

These links will lead you into our framed website.  It is best viewed at a screen resolution of 1024 x 768 dpi, however, 800 x 600 dpi will also work.  
If your screen cannot handle this, please navigate using our Site Map page and your browser.