Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Home Tab

Clipboard – Font – Alignment – Number – Styles – Cells – Editing

When you open a new Excel spreadsheet, the Home tab is selected by default. This is the first tab in the list and includes the frequently used options such as cut-copy-paste, font formatting, alignment, number, conditional formatting and more. All of these options are used to format your data.


For those of you that have used Microsoft Excel 2007, you may not immediately notice a difference. However, there have been some improvements and additions to Excel 2010 that we are excited to share with you in these tutorials. First, Excel 2007 had an Office button in the top-left hand corner (shown in the image to the left).


In Excel 2010, this button has been replaced with the File tab, positioned to the left of the Home tab (shown in the image to the right). Select the File tab to review the available features.

In these tutorials, we will review each of the groups included within the Home tab. Let’s get started by opening Excel 2010. Select File and Save As, and then select a name for your spreadsheet and click on Save.

In your new spreadsheet, click in cell A1 and type Monthly Budget.


In the Clipboard group, you will find these frequently used commands: Cut, Copy, Paste and Format Painter. Clipboard options allow us to collect text and graphic items and paste them.


To open the Office Clipboard, select the dialog box launcher. This can be found in the bottom-right corner of the Clipboard group on the Home tab ribbon (as shown in the image below).

Highlight Monthly Budget and select Copy. You will notice that Monthly Budget has now been copied into the Office Clipboard. Keep in mind that you can store up to 24 items into the Office Clipboard and they can be pasted into other Microsoft Office applications such as Word or other Excel spreadsheets.

To paste an item from the Office Clipboard into the current worksheet, click the item in the Clipboard task pane to paste it at the position of the cell cursor.

You can paste all of the items stored in your Office Clipboard into the current worksheet by selecting the Paste All button at the top of the Clipboard task pane.


To clear the Office Clipboard of all the current items, click the Clear All button.

To delete only a particular item from the Office Clipboard, position the mouse pointer over the item in the Clipboard task pane until its drop-down button appears. Click this drop-down button and then choose Delete from the pop-up menu (as shown in the image to the right).

For simple Cut, Copy and Paste movements in your spreadsheet, you can utilize the buttons within the Clipboard group or right click your selected cells and choose from the drop-down menu.

If you have formatted your cells with borders, shading, fonts and etc., the Format Painter function in the Clipboard group will be useful. Essentially, you can copy and paste the formatting of your cell while leaving the text alone. Let’s take a look at our example to the right. In A3, we have added a border, yellow fill color and we centered the text.


We want to copy the formatting from cell A3 to C3. Select A3 and then click Format Painter. Now select C3 and the formatting automatically transfers over.

Your first paragraph ...