The Home Tab of Microsoft Excel 2007
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 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
The Alignment Group
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
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 – 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.
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?
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