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
Australian High Commission Ethan Haime Introduction to Management
A very personal and calm approach, which energises the group rather than in some sessions draining the energy. Also, the wit and light touch also helped in the implementation of the topics. Also, the approach was very inclusive and everyone was able to participate.
It did not follow the usual pattern of training sessions and was much more attention getting than the usual courses. The combination between informality and structure was really well done.
National Physical Laboratory Laboratory Manager Stanislav Strekopytov Excel Advanced - For Power Users
Examples of using VBA for operations on the whole folders eg combining worksheets into workbooks as well as splitting multisheet Excel into CSV files would be useful.
AVEVA Solutions Ltd Tony Brown Project Introduction
Thoroughly enjoyed the 2 days, opened my eyes as to the possibilities of the software
More testimonials |
Clients
· Main client list
Article list
What's this?
Server loaded in 0.12 secs.
PUBLICATION GUIDELINES