StudyFinance

StudyFinance

Getting Started With Excel

 Self-Paced Overview

Printing the Worksheet

Page Setup

Microsoft Excel

To prepare a worksheet for printing, Excel offers several options to control how it will appear on the printed page. It's always a good idea to review the layout before printing—checking for things like orientation and margins—to verify that the worksheet will print as intended.

To do this, select the Page Layout tab on the Ribbon at the top of the Excel screen. From there, notice the Page Setup group which includes options to control page orientation, margins, and paper size, among other things. Click on each option and select the parameters you desire.

Note the Print Area button in the Page Setup group. If you have a worksheet that has multiple components to it and you wish to print those components separately, you can define specific areas or cell ranges of the worksheet to be printed, ignoring the other areas.

Microsoft Excel
Microsoft Excel

Print Preview

It is a good idea to always preview before you print so that you can make any adjustments before printing and save yourself repeated attempts and wasted paper. To preview what you're about to print, click the Microsoft Office Button at the top left of the screen, click the arrow next to Print, and then click Print Preview. From in the Print Preview page, notice the Page Setup button in the Print group on the Ribbon. By selecting this option, you have control over all of the Excel page setup options.

Printing

Once the worksheet has been prepared for printing, it can be printed by selecting the Print button in the Print group on the Ribbon within Print Preview, or by clicking Print from the Microsoft Office button.

Saving the Worksheet

Microsoft Excel

You should save your work frequently. If you have a power outage or some other problem, you can start working again from your last saved version.

When you create a new worksheet and save it for the first time, you are always asked for a name to assign to the worksheet. Click the Microsoft Office Button at the top left of the screen and then click Save. If the worksheet is new, a dialog box will appear asking for a name and location to save the worksheet. If the worksheet you are working on as been previously saved, clicking Save will save a new copy of the previously named worksheet overwriting the previous version.

If you would like to save an existing worksheet to another name, thus keeping the original version in its original condition, click Save As. A dialog box will appear asking for a name and location to save the new worksheet.

What Next?

The purpose of this overview is to give a general understanding of some basic features of Microsoft Excel. By no means is it comprehensive. There are several places to go to learn more about Excel.

Excel Help

You might start by taking advantage of the tutorial features available within Excel itself. From Excel Help, search for "tutorials." In addition, online help is quite extensive and is best used for finding information quickly. Use your favorite Internet search engine to find answers.

Also, if you would like specialized information, there are many comprehensive books available.

StudyFinance.com is maintained by Dr. Sharon Garrison
Terms of Use • Privacy • Copyright © 1999–2018 StudyFinance.com