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 Ribbon of Microsoft Excel 2007 is made up of seven 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.
Cut, Copy, and Paste
- Cut (Ctrl+X) – This is for cutting the selected section from the document and placing it on the clipboard.
- Copy (Ctrl+C) – This 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.
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.
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) – Makes the selected text 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.
- 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.
- 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.
- 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.
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.
- 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.
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
Ghanshyam on November 15, 2019:
Kds on October 10, 2019:
priyambada nayak on October 08, 2019:
thank you show mach
Azhar on July 09, 2019:
Not much helpful... I didn't found what I needed but that's OK....
Pradeepkumar sau on March 14, 2019:
Thank you sir
Bashir muhammed on October 15, 2018:
Patrick Kamau (author) from Nairobi, Kenya on August 11, 2018:
Thanks a lot, Arman for the visit and comment. I am glad you got what you wanted in this article.
Arman on August 10, 2018:
It is too helpful for me
purusotam on April 23, 2018:
i am grateful to you because i learn about home tab this is really useful for me i congratulate to you thanks
Rasmita on April 10, 2018:
Rich on February 27, 2018:
Can u make the picture of the home tab ribbon look big
MonLonTon on November 29, 2017:
Patrick Kamau (author) from Nairobi, Kenya on October 09, 2017:
Thanks Aqeel for the visit and comment, keep on checking more of my work.
Aqeel on October 08, 2017:
Very good work
Niraj on July 16, 2017:
Hitesh on May 15, 2017:
Not so much help
Ankit Raj on May 07, 2017:
It's great Patrick ..
This is very useful
Jona Mae on January 21, 2017:
Thanks to the author :) It helped a lot! And I think it will really help me to my future work :)
chaiyanya sethiya on January 08, 2017:
nice work guys
Patrick Kamau (author) from Nairobi, Kenya on March 13, 2013:
Thanks lucy patrick. I am glad you liked this article.
lucy patrick on March 12, 2013:
good work patkay