Previous article Next article
Excel articles
Tips to Facilitate Printing of Excel worksheets
Fri 11th January 2008
Having mastered the principles of Excel to create an impressive worksheet, I would often fall at the final hurdle. I have always found printing Excel worksheets to be challenging. This final stage can often be the most frustrating because you know that the end is in sight and yet you cannot quite seem to make it there. An invaluable ally at this point in your journey is the Print Preview feature. It can save you a great deal of time and paper by accurately show you how your worksheet will be presented on paper. Let us consider some of the other features offered by Excel to improve your efficiency at this final stage.
Worksheet not fitting on one page?
Frustratingly, it is often the case when printing Excel worksheets that the final column spills onto another page. Excel, however, allows you to specify how many pages your printout will occupy. This is done by going to Page Setup. Select Page tab and then choose the Fit To option. Then specify how many pages you wish the final printout to occupy. Continue with printing as usual and hopefully you will achieve the desired result.
Data only in one column?
If you have a worksheet that only has data in the first column (A1:A75 for example), this can prove both inconvenient to print and wasteful of paper. Rather than having many pages with information only on one side, it is possible to move the data around so that it fits onto one page. This can be done by using the camera tool. The idea is to move some of the data into extra columns so all the information can fit onto one page. Snap the camera and then place the resulting image onto the page to be printed.
Unable to clear the Print Area?
Many of you may be familiar with setting the print area so as to define the range you wish to be printed. However, problems can be encountered when it comes to clearing the print area. One solution is to select File and then Print Area. From the submenu choose Clear Print Area. If you are using Excel 2007, select Page Setup as your fist step and then proceed as before.
The tips discussed above are simple ways to improve your final result and apply to all versions of Excel. However, there are more advanced tips that can be mastered. It should also be noted that different versions of Excel have different methods of achieving the same results. By attending Excel courses in London, for example, these skills can be mastered and ensure that you are able to display your work in the best possible way.
Author is a freelance copywriter. For more information on Excel courses in London, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-277-tips-facilitate-printing-excel-worksheets.html
Back to article list
Distribution notes
London's widest choice in
dates, venues, and prices
Public Schedule:
Buy now / Live dates
On-site / Closed company:
Get quote
Testimonials
Britannic Technologies Business Analyst Arun Purushothaman Presentation Skills
Some good presentation tools can be suggested
Warner Bros.Television Production UK Limited Accounts Assistant Madalina Androne Excel Advanced
The course is well structured and provides opportunities to apply the elements presented which is very useful.
I think the logical functions could be included in the intermediary level course rather than the advance course, so that more time can de dedicated to macros and power queries.
Monex Europe Ltd Assistant Financial Analyst Jose Carvalho Excel Forecasting and Data Analysis
Trainer had great enthusiasm and tried to make the content as enjoyable as possible
More testimonials |
Clients
· Main client list
Article list
What's this?
Server loaded in 0.1 secs.
PUBLICATION GUIDELINES