Excel Printing - All You Need to Know

Q. Why is only a small section of my Excel spreadsheet printing?

Q. How do I print a small section of a large spreadsheet

Q. How do I print my Excel spreadsheet on one page?

Q. Displaying Excel Functions and Formulas for Printing

Q. Excel - How to Print the Ampersand (&) Character

A. Why is only a small section of my Excel spreadsheet printing?

The most likely reason for this is that there has been a print area set previously. To fix this, go to Excel's "File" menu, select "Print Area" then "Clear Print Area". This should fix the problem - your spreadsheet should now print out in its entirety.

A. How do I print a small section of a large spreadsheet

Fortunately, there is a simple solution to this problem. Firstly select the entire area of the spreadsheet that you need to print. Then go to Excel's "File" menu, select "Print Area" then "Set Print Area". If you have done this correctly you should see a dotted line around the area you have chosen to print. When you print the spreadsheet, only the print area you have set will be printed. To remove the print area go to Excel's "File" menu, select "Print Area" then select "Clear Print Area". This should work for all versions of Excel from 97 onwards.

A. How do I print my Excel spreadsheet on one page?

In the "File" menu, select "Page Setup" (this can also be done from print preview - click the "Setup" button). In the page setup there are four tabs - select the "Page" tab. Under "scaling" you'll see the option to fit to one page - click the radio next to the phrase - it defaults to one page tall by one page wide. If you have a spreadsheet that is too wide, but the length is fine, you can make the spreadsheet one page wide and change the "tall" option to however long the document is (eg 6 pages). This will make the width of the spreadsheet fit to one page without affecting the length of the document

A. Displaying Excel Functions and Formulas for Printing

Excel formulas by default don't get printed out. What you usually see is the result of the Excel formula. So what happens when you need to have the formulas print out and not the results?

It is actually possible to do so. There is a way to toggle the formulas in excel. Go to the "Tools" menu and select "Options". Click on the "View" tab and you'll see a "Window Options" section towards the bottom. Check the box next to "Formulas".

When you click "Okay" you will notice two things:

1. You now see the formulas in the cells, rather than the results
2. The columns are now exactly twice as wide as they were before.

Don't worry - when you change back to displaying the formula's results (by unchecking the "Formulas" box), your columns will return to their normal size.

A. Excel - How to Print the Ampersand (&) Character

Excel uses the ampersand character (&) as its escape character. So when Excel sees the & it expects an instruction to follow and so doesn't print the &.

Fortunately, there's a simple solution, if Excel won't print the &, simply use two together:

&&

Excel will then print the second ampersand character.

Spreadsheet 123 Spreadsheet Software Development