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?
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:
- You now see the formulas in the cells, rather than the results
- 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.
More Excel 97/2000/2002XP/2003/2007 Formulas and Functions
Learning How To Use Spreadsheet IF and IS Functions
Its not easy to know which spreadsheet function you're after sometimes. This quick guide is designed to help you work out what you need to use.
What Is An IF Function?
Ever wondered how to use the IF functions in Excel? This article explains how to use IS and IF functions.
CountIf Function
CountIf is a conditional function that can be used to count cells based on any condition you specify. Find out how you can use it in your spreadsheets.
Excel's IF Function
The IF function can be an incredible tool for your workbooks. Find out how they work.
Nested IF Functions
Nested IF functions are a simple way of doing complex conditional formulas.
IsError Function
The IsError function is one of the most useful
features of Excel. Find out how you can use this function to get rid of Excel's ugly error messages.
Making Excel AutoFill Formulas
If you have Excel 2000. Excel 2002 or Excel 2003, you can make sure that your formulas are copied to new rows or columns if you put in new data.
Find out how you can autofill formulas
Excel 97/2000/2002XP/2003/2007 Full Tutorials
If you are interested in more advanced formulas and functionalities of Excel 97/2000/2002XP/2003/2007 Click on the link above
Suggested Reading
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
