Home » Computers

Tips For End Users of Excel 2003 and 2007

Aug 31, 2008
Here are some tips for end users of Excel, both the 2003 and 2007 versions. In this article, you will learn how to print a portion of a spreadsheet, print column headings on each page, and change the default font - in both versions of the application.

Excel 2007 - Printing a Portion of a Spreadsheet.

First, select the cell range you would like to print. Then, under "Page Layout," go to the print area icon; select "Set Print Area." Next, print out the worksheet. Finally, select "Clear Print Area" and the entire worksheet will print next time (instead of just the selected area). There is also a section at the end of the article which describes the format painter.

Printing Column Headings on Each Page.

First, go to "Page Layout Menu" and click the "Print Titles" icon; then click the "Sheet" tab. Then, to print column headers on every page, enter the rows containing column labels under "Print titles" under "Rows to repeat." When ready, click "Print."

Changing the Default Font.

In Excel 2007, the default font and size is Calibri 11.

First, click "Microsoft Office" and then click "Excel Options." When creating new workbooks in the "Popular" category, click the font you want to use in the "Use this font" box, then enter the font size you'd like to use in the "Font Size" box.

NOTE: you must restart Excel to use the new default selection, affecting only newly created workbooks.

Excel 2003 - Printing Part of a Spreadsheet.

To begin, select the cell range you'd like to print. For the next step, in the file menu, go to "Print Area." Then click "Set Print Area." After, print the worksheet. When saving, your print area is also saved.

Printing Column Headings on Each Page.

If you have spreadsheet data spanning several pages and want column headings on each, this will help:

First click "Page Setup" on file menu, then click the "Sheet" tab. Next, to print column labels on each page, enter the rows that contain column labels under "Print titles" in the "Rows to repeat at top box." Finally, click "Print."

Changing the Default Font

First, click "Options" on the "Tools" menu. Then click a font in the "Standard font" box on the "General" tab. Finally, click a font size in the "Size" box.

NOTE: You must restart Excel to begin using this new default font and font size. This new default will be effective for new workbooks you create - existing workbooks are not affected.

What is the Format Painter?

Those who prefer to do simple Word documents might not be the heaviest Style users. If you'd like to reuse styles you're already created in a document, the Format Painter is an excellent tool. In order to apply a paragraph style from one paragraph to another one: first put the cursor somewhere in the styled paragraph, then click the Format Painter (Ctrl + Shift + C).

Click the paragraph where you'd like to apply the style. If you'd like to apply the style to multiple paragraphs, just double-click the Formet Painter. Then click in every subsequent paragraph in order to apply this same style.
About the Author
Nick Pegley is VP Marketing for All Covered: Technology Services Partner for Small Business, providing disaster recovery solutions and technology services in 20 major U.S. metro areas.
Rating:
Please Rate:
(Average: Not rated)
Views: 209
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