The Home Tab of Microsoft Excel 2007

Updated on September 11, 2019
Patkay profile image

Patrick, a computer technician, is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.

The Home Tab of Microsoft Excel 2007

Excel 2007 Home Tab Ribbon

The Home Tab Ribbon of Microsoft Excel 2007 is made up of 7 groups or sections that comprise of very important commands. Most of the commands are commonly used in manipulating data in Excel. Let us have a look at them.

The Home Tab Ribbon

The Home Tab Ribbon
The Home Tab Ribbon | Source

The Clipboard Group

Cut, Copy, and Paste

Cut (Ctrl+X) – (with scissor-like icon) is for cutting the selected section from the document and placing it on the clipboard.

Copy (Ctrl+C) – copies the selected section and places it on the clipboard.

Paste - (Ctrl+V) – use this command to paste the contents of the clipboard to the desired location. There are various options in the paste command. These are, paste formulas, values, no border, transpose, paste link, paste special, paste as a hyperlink, and paste as a picture. For paste as picture option, we have some more options like copy as a picture (you can copy a picture as it appears or according to format), paste as a picture, and paste picture link.

Use Format Painter to Copy Format Style

Format Painter and the Clipboard

Format Painter – use this tool to copy formatting from one place and apply the copied format to another place. For instance, you have formatted a cell to be bold and italic and you want to apply this format to other cells, just click on the cell with the format you want to copy and click on format painter, then click on the cell you want to apply the format. If you are applying to many cells, double click on the format painter before clicking on the other cells you want to apply the format you have copied.

Clipboard – click on the dialog launcher button to open the clipboard. The clipboard collects the items you cut and copy, it holds up to 24 items that you can reuse at any time. You just click on an item in the clipboard to paste it where you want.

Font Formatting Group

Working With Fonts

Font – use this tool to change the font face. Clicking on the drop-down button you will be able to get more fonts. Advanced users can also download missing fonts from the Internet.

Font Size – this command is for changing the font size. Highlight the cell(s) you want to change the size of and then select the size you want.

Bold (B) – Use this command to make the selected text bold.

Italic (I) – make the selected text to be italicized.

Underline (U) – underline the selected text. Using the drop-down button you can get the double underline.

Increase Font Size – this is another way of increasing the font size.

Decrease Font Size – use this shortcut for decreasing the font size.

Borders – use this command for setting the borders for the cells

Fill Colour – this command is for colouring the background of the selected cell. Highlight the cells you want to change the background of and click on this command. Remember to click on the drop-down button to see more colours.

Font Colour – use this tool to change the text colour. Clicking on the drop-down button next to the command, you get more colours.

Font Dialog Launcher – use this to show the font tab of the format cells dialog box. It comprises of the following tabs; number, alignment, font, border, fill and protection tabs.

Format Cells Dialog Box

Format Cells Dialog Box
Format Cells Dialog Box | Source

The Alignment Group

Aligning Text

Top Align – this command aligns text to the top of the cell.

Middle Align – this tool will align text such that it will be centered towards the top and bottom of the cell.

Bottom Align – use this command to align text to the bottom of the cell.

Align Text Left – this tool lets you align text to the left of the cell.

Center – this command is for centering text in the cell.

Align Text Right – this one is for aligning text to the right of the cell.

Decrease Indent – this command decreases the margin between the cell border and the text in the cell.

Increase Indent – this tool increases the margin between the cell border and the text in the cell.

Orientation – use this command to rotate selected text to a diagonal or vertical angle orientation. Clicking on the drop-down button of the command, you get more options like; angle counterclockwise, angle clockwise, vertical text, rotate text up, rotate text down, and format cell alignment.

Wrap Text – this command makes all content visible within a cell by displaying it on multiple lines.

Merge and Center – this command joins the selected cells into one larger cell and centers the contents in the new cell.

Alignment Dialog Box – by clicking on the alignment dialog box, you open the format cells dialog box that has the following tabs, number, alignment, font, border, fill, and protection tab.

The Number Group

Number Formats

General – this command helps to choose how the values in a cell are displayed. This could be general, number, currency, the percentage among others.

Accounting Number Format – use this command to set the alternate currency format you want for the selected cell. Open the drop-down button for more currencies.

Percentage Style – use this command to apply the percentage format to the selected cell(s).

Comma Style – this displays the contents of the cell with a thousand separator.

Increase Decimal – show more precise values by showing more decimal places.

Decrease Decimal - show less precise values by showing fewer decimal places.

Using the number dialog launcher, you will be able to launch the format cells dialog box, similar to the one you will get from the alignment dialog launcher.

The Styles Group

Conditional Formatting

Conditional Formatting – use this command to highlight interesting cells, emphasize unusual values, and visualize data using data bars, colour scales, and icon sets based on criteria.

Format as Table – this tool formats a range of cells and converts them to a table by choosing a pre-defined table style.

Cell Styles – use this to apply a cell formatting by choosing from pre-defined styles.

The Cell Group

Working on Cells

Insert – this command will help you to insert cells, rows, columns, or sheet into the worksheet.

Delete – this is for deleting cells, rows, columns, and sheet.

Format – use this command to change the row height or column width, organize sheets, or protect or hide cells.

Editing Group

Edit Group

Sum – use this to display the sum of the selected cells directly after the selected cells.

Fill – distribute a pattern into one or more adjacent cells. This can be done in any direction and in any range of adjacent cells.

Clear – this command clears everything from the cell, or selectively removes the formatting, the contents, or the comments.

Sort and Filter – use this to arrange data so that it is easier to analyze. The selected data can be sorted in ascending or descending order, or you can also filter out specific values.

Find and Select – use this command for finding and selecting specific text, formatting or type of information you want from within the workbook. You can also make use of the replace option to replace the information with new text or formatting.

Are you familiar with the format painter?

See results

This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.

© 2013 Patrick Kamau


    0 of 8192 characters used
    Post Comment
    • profile image


      6 weeks ago

      You have given very good information. we fully understand, thank you.

      if you read this type article in hindi visit

    • profile image


      8 months ago


    • profile image


      9 months ago


    • profile image

      priyambada nayak 

      9 months ago

      thank you show mach

    • profile image


      12 months ago

      Not much helpful... I didn't found what I needed but that's OK....


    • profile image

      Pradeepkumar sau 

      16 months ago

      Thank you sir

    • profile image

      Bashir muhammed 

      21 months ago


    • Patkay profile imageAUTHOR

      Patrick Kamau 

      23 months ago from Nairobi, Kenya

      Thanks a lot, Arman for the visit and comment. I am glad you got what you wanted in this article.

    • profile image


      23 months ago

      It is too helpful for me


    • profile image


      2 years ago

      i am grateful to you because i learn about home tab this is really useful for me i congratulate to you thanks

    • profile image


      2 years ago


    • profile image


      2 years ago

      Can u make the picture of the home tab ribbon look big

    • profile image


      2 years ago


    • Patkay profile imageAUTHOR

      Patrick Kamau 

      2 years ago from Nairobi, Kenya

      Thanks Aqeel for the visit and comment, keep on checking more of my work.

    • profile image


      2 years ago

      Very good work

    • profile image


      2 years ago

      Very good

    • profile image


      3 years ago

      Not so much help

    • profile image

      Ankit Raj 

      3 years ago

      It's great Patrick ..

      This is very useful

      Thank you

    • profile image

      Jona Mae 

      3 years ago

      Thanks to the author :) It helped a lot! And I think it will really help me to my future work :)

    • profile image

      chaiyanya sethiya 

      3 years ago

      nice work guys

    • Patkay profile imageAUTHOR

      Patrick Kamau 

      7 years ago from Nairobi, Kenya

      Thanks lucy patrick. I am glad you liked this article.

    • profile image

      lucy patrick 

      7 years ago

      good work patkay


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)