ComputersConsumer ElectronicsCell PhonesHome Theater & AudioGraphic Design & Video EditingInternetIndustrial Technology

The Home Tab of Microsoft Excel 2007

Updated on March 6, 2017
Patkay profile image

Patrick is a dedicated technology 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 picture (you can copy picture as it appears or according to format), paste as 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.

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) – 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 drop down button for more currencies.

Percentage Style – use this command to apply the percentage format to 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 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

© 2013 Patrick Kamau

Comments

    0 of 8192 characters used
    Post Comment

    • Patkay profile image
      Author

      Patrick Kamau 9 days ago from Nairobi, Kenya

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

    • profile image

      Aqeel 10 days ago

      Very good work

    • profile image

      Niraj 3 months ago

      Very good

    • profile image

      Hitesh 5 months ago

      Not so much help

    • profile image

      Ankit Raj 5 months ago

      It's great Patrick ..

      This is very useful

      Thank you

    • profile image

      Jona Mae 9 months 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 9 months ago

      nice work guys

    • Patkay profile image
      Author

      Patrick Kamau 4 years ago from Nairobi, Kenya

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

    • profile image

      lucy patrick 4 years ago

      good work patkay