Exploring The Home Tab | Excel for Absolute Beginners

In This walkthrough We:

⦁ Access The Home Tab
⦁ Learn Basic Functions like Cut, Copy and Paste
⦁ Alter the Appearance of the font
⦁ Change the Alignment and Merging Cells
⦁ Change the format of the Cells

Aimed At:

  • People who know nothing about Excel and want to know the Basics

Prerequisites:

  • Please Read: Our Previous Post : 5 Things That You Should know About Excel | Excel For Absolute Beginners

Cool Stuff :

  • You can just copy the formatting of the Cell to a different cell through the Format Painter Option.
  • Set the Border of the Cells so that they can be printed.
  • Combine Multiple cells into one

1) Access The Home Tab

You can find the HOME tab In Excel from the Ribbon ( The upper White Area) . Click the HOME tab to Access all its functions, As highlighted in the image:

The HOME tab contains Basic functions which are used to

  • Change the Appearance of the Text and Cells
  • Changing the font size and font Family
  • combining the cells and alot more

Let’s Learn the most important ones.

2)The Clipboard functions

Excel allows you to access the Basic Functions like Cut, Copy and Paste right from the HOME tab through Easily Accessible Buttons. You can find these buttons in the Clipboard group, in the upper left corner of the HOME tab, as shown below:

The Clipboard group serves as a very important group Because It enables users to Copy or Move Data / Cells throughout the Worksheet. Lets Explore its Features.

To Copy Data / Cells :

1) Select The Cell / Data you wish to Copy from in the worksheet by Clicking it.
2) Click The Copy Button from the Clipboard group OR use the Shortcut Key Ctrl + C ( or Cmd + C on Mac)
3) Select The desired location to paste the Data to through out the worksheet
4) Click the Paste button from the Clipboard group OR use the Shortcut Key Ctrl + V ( or Cmd + V on Mac)

5) As the Text is already copied to the clipboard, you can paste it as many times as you want by repeating Step 3 to 5

To Move Data / Cells :

1) Select The Cell / Data you wish to Copy from in the worksheet by Clicking it.2) Click The Copy Button from the Clipboard group OR use the Shortcut Key Ctrl + X ( or Cmd + X on Mac)3) Select The desired location to paste the Data to through out the worksheet4) Click the Paste button from the Clipboard group OR use the Shortcut Key Ctrl + V ( or Cmd + V on Mac)

To Copy just the Formatting of a Cell :

Lets say You have changed the Appearance of a cell by Changing its font size and Underlining it. Now you want to copy these properties to the other Cells. You can just Copy the FORMAT of the cell By :

1) Select the Cell you want to Copy the format from

2) Click the Format painter Button from the Clipboard group in the HOME tab

3) The Icon will change to a Brush icon. You can now Click the Cell you want to apply this format to and Excel will Change the format of the Clicked cell without Altering the Data.

3) The Font group

Excel groups the Font Properties and functions to a separate group known as the Font group. As highlighted below:

Lets Explore a number of Features it offers:

To Change the Font Family

Click on the Fonts tool to open a drop down menu and Select from a number of fonts provided with the Microsoft office. The default font is ” Calibri” As shown in the above image

To make Text Bold, Italic or Underlined

Use the Bold, Italic and Underlined Buttons below the Fonts Button.

To Change the Font Size

Use the Font Size options right next to the Fonts option. the default font size is 11 as shown in the image above. you can also use the Increase size and Decrease size buttons on the right  of the font size button.

To Change the Color of the Text

Use the Font Color Option from the Font group below the Increase and Decrease size buttons.

To Change the Background of the Cell

use the Fill Color option on the left of the Font Color option.

Note: to change above Properties for just a number of cells, you need to select them first by Clicking the first cell and dragging to the last one.

Setting the Borders of the Cell.

Select the Cells you want to Apply border to by dragging ( as mentioned above) and Click on the Border option drop down menu in the Font group, on the right of the Underlined Button. a Drop down list will open which will enable you to apply the different types of borders Excel offers, as shown below.

1.) Select the Cells you want to Apply border to by dragging ( as mentioned above)

2) Click on the Border option drop down menu in the Font group, on the right of the Underlined Button. a Drop down list will open which will enable you to apply the different types of borders Excel offers, as shown below.

3) The Alignment group

The Alignment group offers a number of features, all relating to Alignment and position of the text in the cell.

Set the Alignment of the text in the cell

It can be done through the Alignment options which are top align, middle align, bottom align and Left Align, Center and Right Align on the top of the alignment group.

Combine Multiple Cells into One through Merge and Center Option

Excel offers you to Combine Multiple Cells into One through Merge and Center Option. This option allows users to fit bigger and longer text into a single cell. To use this feature: 1) Select the Cells you want to combine by dragging (as mentioned above).

2) Clicking on the Merge & Center Button combines selected cells into one.      3) You can then apply properties to this cell from the Alignment tab e.g Middle Align

Leave a Comment