Home » Computers » Software

Tips to Facilitate Printing of Excel worksheets

Jan 18, 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.
About the Author
Author is a freelance copywriter. For more information on Excel courses in London, please visit http://www.microsofttraining.net
Rating:
Please Rate:
(Average: Not rated)
Views: 130
Print Email Report Share
Article Categories
    • Artists
    • Gambling
    • Humanities
    • Humor
    • Movies
    • Music
    • Photography
    • Tattoos
    • Television
    • Classic Cars
    • Motorcycles
    • Recreational Vehicles
    • SUVs
    • Trucks
    • Vans
    • Branding
    • Business Opportunities
    • Careers and Jobs
    • Corporate
    • Customer Service
    • Direct Mail
    • Entrepreneurship
    • Ethics
    • Financing
    • Franchising
    • Home-Based Business
    • Human Resources
    • Import and Export
    • Leadership
    • Management
    • Market Research
    • Marketing and Advertising
    • Negotiation
    • Network Marketing
    • Networking
    • Organizational
    • Presentation
    • Project Management
    • Public Relations
    • Small Business
    • Strategic Planning
    • Team Building
    • Telemarketing
    • Training
    • Ask an Expert
    • College and University
    • Home Schooling
    • K-12
    • Languages
    • Online Education
    • Psychology
    • Accounting
    • Credit
    • Currency Trading
    • Debt Consolidation
    • Insurance
    • Investing
    • Leasing
    • Loans
    • Mortgage
    • Mutual Funds
    • Personal Finance
    • Stock Market
    • Structured Settlements
    • Taxes
    • Wealth Building
    • Coffee
    • Cooking
    • Gourmet
    • Recipes
    • Wine and Spirits
    • Acne
    • Aerobics
    • Alternative Medicine
    • Beauty
    • Cancer
    • Cosmetics
    • Depression
    • Diabetes
    • Diseases and Conditions
    • Fitness Equipment
    • Fitness
    • Hair Loss
    • Heart Disease
    • Medicine
    • Men's Health
    • Muscle Building
    • Nutrition
    • Skin Care
    • Supplements and Vitamins
    • Weight Loss
    • Women's Health
    • Yoga
    • Arts and Crafts
    • Babies
    • Collecting
    • Elderly Care
    • Genealogy
    • Hobbies
    • Parenting
    • Pets
    • Pregnancy
    • Woodworking
    • Feng Shui
    • Gardening
    • Home Appliances
    • Home Security
    • Interior Design
    • Landscaping
    • Affiliate Programs
    • Article Marketing
    • Auctions
    • Audio
    • Banner Advertising
    • Blogging
    • Broadband
    • Domain Names
    • E-Books
    • E-Commerce
    • Email Marketing
    • Ezines and Newsletters
    • Forums
    • Internet Marketing
    • Link Popularity
    • Pay-Per-Click
    • Podcasting
    • RSS
    • Search Engine Marketing
    • Search Engine Optimization
    • Security
    • Social Media
    • Spam
    • Video
    • Viral Marketing
    • Web Design
    • Web Development
    • Web Hosting
    • Copyright
    • Cyber Law
    • Intellectual Property
    • National, State, Local
    • Patents
    • Regulatory Compliance
    • Trademarks
    • Buying
    • Selling
    • Baseball
    • Basketball
    • Boating
    • Cycling
    • Extreme Sports
    • Fishing
    • Football
    • Golf
    • Hockey
    • Hunting
    • Martial Arts
    • Running
    • Scuba Diving
    • Soccer
    • Swimming
    • Tennis
    • Dating
    • Divorce
    • Marriage
    • Weddings
    • Astrology
    • Buddhism
    • Christianity
    • Faith
    • Hinduism
    • Islam
    • Judaism
    • Meditation
    • Metaphysical
    • New Age
    • Cable and Satellite TV
    • Cell Phones
    • Communication
    • Gadgets and Gizmos
    • GPS
    • Satellite Radio
    • Video Conferencing
    • VoIP
    • Addictions
    • Coaching
    • Goal Setting
    • Motivational
    • Stress Management
    • Time Management
    • Clothing
    • Electronics
    • Fashion
    • Gifts
    • Jewelry
    • Causes and Organizations
    • Environment
    • History
    • Holidays
    • Men's Issues
    • Nature
    • Philosophy
    • Politics
    • Women's Issues
    • World Affairs
    • Air Travel
    • Camping
    • Cruises
    • Destinations
    • Outdoors
    • Article Writing
    • Book Reviews
    • Copywriting
    • Fiction
    • Non-Fiction
    • Poetry
    • Quotes
    • Screenplay
    • Tools and Resources