Search
  • Videos
  • Windows 10
  • 5G
  • CES
  • Best VPNs
  • Cloud
  • Security
  • more
    • AI
    • TR Premium
    • Working from Home
    • Innovation
    • Best Web Hosting
    • ZDNet Recommends
    • Tonya Hall Show
    • Executive Guides
    • ZDNet Academy
    • See All Topics
    • White Papers
    • Downloads
    • Reviews
    • Galleries
    • Videos
    • TechRepublic Forums
  • Newsletters
  • All Writers
    • Preferences
    • Community
    • Newsletters
    • Log Out
  • Menu
    • Videos
    • Windows 10
    • 5G
    • CES
    • Best VPNs
    • Cloud
    • Security
    • AI
    • TR Premium
    • Working from Home
    • Innovation
    • Best Web Hosting
    • ZDNet Recommends
    • Tonya Hall Show
    • Executive Guides
    • ZDNet Academy
    • See All Topics
    • White Papers
    • Downloads
    • Reviews
    • Galleries
    • Videos
    • TechRepublic Forums
      • Preferences
      • Community
      • Newsletters
      • Log Out
  • us
    • Asia
    • Australia
    • Europe
    • India
    • United Kingdom
    • United States
    • ZDNet around the globe:
    • ZDNet France
    • ZDNet Germany
    • ZDNet Korea
    • ZDNet Japan

How do I... Perform basic formatting in Excel 2007

1 of 10 NEXT PREV
  • 66055.png

    To get your point across when communicating information in the form of a spreadsheet of numbers, it is often necessary to add some formatting beyond the basic numbers in a set of cells. Column headings, row names, fonts, colors, and other basic formatting techniques can help you emphasize the data points you want your audience to focus on. The last thing you want to do is bog your communication down with an overwhelming sea of numbers.

    This gallery is also available as a TechRepublic download and as a TechRepublic article.
    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

  • 66047.png

    Basic Microsoft Excel 2003 formatting was relatively straightforward and made liberal use of menus and dialog boxes. With the introduction of the Office ribbon interface, basic formatting in Microsoft Office 2007 applications is a little different and may take some getting used to for power users familiar with previous versions. The Excel 2007 basic formatting functions are located under the Home tab, which is the default starting tab for any workbook or worksheet.

    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

  • 66048.png

    The icon buttons in the Font section of the Home tab ribbon should be familiar to everyone who regularly uses an office suite. There are buttons for adding bold, italic, underline, and to change font color -- all the usual suspects. Those buttons should be self-explanatory. There is one button that may require additional investigation – the Borders button. Clicking on that button reveals an extensive menu of potential border positions and styles.

    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

  • 66049.png

    As you can see, using borders can help you separate data into readable groups and help you communicate the important information to your audience.

    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

  • 66050.png

    The next section on the Home ribbon is Alignment. The various icons in this section should be relatively familiar to most users, especially if they are already familiar with Excel 2003 and earlier. The icons in the Alignment section will right and left justify text, center text, indent, and align the text within a cell. The Alignment section is also where you can orient your text at an angle. This screenshot shows you some of the ways you can align text from this section of the ribbon.

    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

  • 66051.png

    Beyond manipulating text position within a cell, the Alignment section of the Home ribbon is also where you can perform the merge cell feature. This is a basic formatting technique but it comes in handy when you have a title you want to center over a table of data. This screenshot gives you an example -- the title is actually located in cell A1, but is extended over the entire table by the merge cell function.

    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

  • 66052.png

    The next section of the Home ribbon in Excel 2007 is called Number, but it is really more involved than its name implies. Besides designating how many digits numerical data should show, this section also allows you to specify whether the data should be expressed as currency, dates, time, percentage, or scientific notation.

    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

  • 66053.png

    The Cells section on the Home ribbon contains only three icons, but they invoke some of the more useful features you will likely use when working on an Excel worksheet. The Insert and Delete icons do exactly what they say they do -- they insert and delete rows, columns, and individual cells. In addition, the Format icon brings up a menu with options for setting row height, column width and visibility. This is also where you can set options for protecting and locking cells.

    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

  • 66054.png

    For those of you resistant to change, you can still reach the familiar dialog box with all of the various formatting tabs and choices by clicking on the Expansion icon in the lower right corner of the Font, Alignment or Number sections of the Home ribbon.

    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

  • 66046.png

    Of course, this is just the basics of formatting in Excel 2007. However, even with basic formatting you can highlight the specific aspects of a report or worksheet for your audience. This screenshot shows you a simple example of basic formatting. More advanced formatting techniques will be covered in a future article.

    Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

    Caption by: Mark Kaelin

1 of 10 NEXT PREV
Mark Kaelin

By Mark Kaelin | May 15, 2007 -- 06:30 GMT (23:30 PDT) | Topic: Enterprise Software

  • 66055.png
  • 66047.png
  • 66048.png
  • 66049.png
  • 66050.png
  • 66051.png
  • 66052.png
  • 66053.png
  • 66054.png
  • 66046.png

Information presented in a spreadsheet can be more than a little bland. With some basic formatting techniques, however, the information you are trying to convey can be communicated much more efficiently. This TechRepublic How do I... tutorial shows you some of fundamentals of formatting in Microsoft Excel 2007, part of the Office 2007 Suite.

Read More Read Less

To get your point across when communicating information in the form of a spreadsheet of numbers, it is often necessary to add some formatting beyond the basic numbers in a set of cells. Column headings, row names, fonts, colors, and other basic formatting techniques can help you emphasize the data points you want your audience to focus on. The last thing you want to do is bog your communication down with an overwhelming sea of numbers.

This gallery is also available as a TechRepublic download and as a TechRepublic article.
Published: May 15, 2007 -- 06:30 GMT (23:30 PDT)

Caption by: Mark Kaelin

1 of 10 NEXT PREV

Related Topics:

Enterprise Software Collaboration Cloud Big Data Analytics Innovation Tech and Work
Mark Kaelin

By Mark Kaelin | May 15, 2007 -- 06:30 GMT (23:30 PDT) | Topic: Enterprise Software

Show Comments
LOG IN TO COMMENT
  • My Profile
  • Log Out
| Community Guidelines

Join Discussion

Add Your Comment
Add Your Comment

Related Galleries

  • 1 of 3
  • Linux turns 29: The biggest events in its history so far

    A year by year summary of the most significant events in Linux's history to date.

  • Parallels Toolbox 4 for Windows and Mac

    New features include Break Time, Unit Convertor, and Enhanced Search.

  • How to perform a clean install of Windows 10: Here's a step-by-step checklist

    A clean install is the perfect way to get a fresh start with a Windows PC. Use this checklist to make sure you take care of the small details that make a big difference in productivity ...

  • Linux survival guide: These 21 applications let you move easily between Linux and Windows

    If you need to navigate regularly between Linux and the Windows world, there are many applications that can make your job easier. We spotlight 21 quality applications that will pave ...

  • 2019's tech, security, and authentication trends

    We take a look at the top tech, cybersecurity, and authentication trends as revealed today by the Duo Security's 2019 Trusted Access Report, which includes data from 24 million devices, ...

  • Awesome Google Chrome extensions (May 2019 edition)

    Get more done in Google Chrome, with this selection of hand-picked extensions from the Chrome Web Store. These free extensions allow you to do a variety of things, from taking screenshots ...

  • Give Google Chrome a speed boost

    Here are a handful of tricks to help you speed up your browser and make it use up fewer precious system resources. (Updated April 2019)

ZDNet
Connect with us

© 2021 ZDNET, A RED VENTURES COMPANY. ALL RIGHTS RESERVED. Privacy Policy | Cookie Settings | Advertise | Terms of Use

  • Topics
  • Galleries
  • Videos
  • Sponsored Narratives
  • Do Not Sell My Information
  • About ZDNet
  • Meet The Team
  • All Authors
  • RSS Feeds
  • Site Map
  • Reprint Policy
  • Manage | Log Out
  • Join | Log In
  • Membership
  • Newsletters
  • Site Assistance
  • ZDNet Academy
  • TechRepublic Forums