Printing in Excel

This Monday I joined MyVideoTalk. I bought their software Video Webmail and Video Webmeeting and they also offered me an independent distributorship. Somehow I liked the idea and grabbed the business opportunity. While I was waiting for my ID to be generated I was surprised to see how the manager struggled to get a neat print out of the customers. Sometimes the heading would be missing and sometimes 3/4 th of the headers was being printed. I explained to the manager but she wasn't convinced till I showed her the following Excel video. You should have seen her face!

Printing in Excel - Part 1 - Preparing to print

Viewing your worksheet for printing

Microsoft Excel provides the following ways to view your worksheet and adjust how it will look printed.

Normal view: The default view is best for on-screen viewing and working.

Print preview: Shows you the printed page so you can adjust columns and margins. The way pages appear in the preview window depends on the available fonts, the resolution of the printer, and the available colors.

Page break preview: Shows you what data will go on each page so you can adjust the print area and page breaks.
Page break: Divider that breaks a worksheet into separate pages for printing.
Excel inserts automatic page breaks based on the paper size, margin settings, scaling options, and the positions of any manual page breaks that you insert.

As you make settings that affect how your worksheet will print, you can switch between the different views to see the effects before you send the data to the printer.

Preparing to print

Excel provides many optional settings so you can adjust the appearance of the printed page. To make sure you've checked everything likely to affect your printout, do the following:

Change the format and layout of the worksheet on-screen
You can set the orientation of the printed worksheet to portrait or landscape.

When to use landscape: Switch to landscape when you need to print many more columns of data than will fit on a portrait page. If you don't want to use landscape, you can change the layout of the printed worksheet to fit the data to the available space, or adjust the margins.

Making the data fit the page: You can make the printed image fit the page or paper size by shrinking or expanding the image. Other changes you can make to the layout of the printed worksheet include setting the paper size, centering the data on the printed page, and controlling how the pages are numbered. These changes affect only the worksheet's printed appearance, not how it looks on the screen.

Print partial data: To print only selected parts of the data on a worksheet, you can specify which areas to print.

More printing ideas in Excel

Print in Excel

Print the selection, the active worksheet(s), or a workbook

If the worksheet has a defined print area, Microsoft Excel will print only the print area unless a specific selection is made. For example, if you select a range of cells to print and then click Selection, Excel prints the selection and ignores any print area defined for the worksheet.

On the File menu, click Print.

Under Print what, select an option to print the selection, the active sheet(s), or the entire workbook.

Print several worksheets at once

Select the worksheets you want to print.

When you enter or change data, the changes affect all selected sheets. These changes may replace data on the active sheet and other selected sheets.

To select Do the following:

A single sheet Click the sheet tab. If you don't see the tab you want, click the tab scrolling buttons to display the tab, and then click the tab.

Two or more adjacent sheets: Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet.

Two or more nonadjacent sheets: Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets.

All sheets in a workbook: Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

Note: If sheet tabs have been color-coded, the sheet tab name will be underlined in a user-specified color when selected. If the sheet tab is displayed with a background color, the sheet has not been selected.

Created using MyVideoTalk