subscribe to our free newsletter

Return to Part 1 or Continue to Part 3

Last time around we started with getting familiar with the MS Excel Screen. Hopefully you all clicked around the screen and became familiar with the different menus and dialog boxes and learned about some features in this robust piece of software.

(Click the image for a larger view)
Excel Screen

This time around I will go over some of the basics that you may have discovered on your own while clicking around the screen. In MS Excel, you open and save documents using the Open and Save icons on the Standard and Formatting toolbar. Open icon Save icon

You can also accomplish these tasks by using the File icon on the Menu bar. When you click it you can select open, close, save, save as, etc.

File Menu

You can use the Print icon to print your spreadsheets or use the File button to see the Print Preview or to Set or Clear the Print area. Print icon

Print Preview

You can apply formatting using the icons on the Standard and Formatting toolbar.

Standard Formatting Toolbar

You can click on the B for bolding, etc. to format your text. You can also apply borders and shading using the icons on this toolbar, by selecting the cells and using the icon where you want the borders and shading. If you hover your cursor over the icons on this toolbar it will tell you what each is used for.

You can use the Format Painter to copy formatting from one cell to another. Paint Brush Simply select the cell with the formatting you would like to copy and click the Format Painter icon (paint brush) and click on the cell where you would like to copy the formatting.

The Autosum icon allows you to add a series of cells. Autosum You select the cells you want to add and click the icon.

Return to Part 1 or Continue to Part 3

Carol Bratt is the Office Applications Editor at Daves Computer Tips. She has authored several informative Microsoft Office books and writes the monthly Word Bytes Newsletter with more tips and tricks in each issue. Visit Carol's website for more great Microsoft Office tips and tricks! Click here to see her latest books! You can read more about Carol here.