Excel 2007 Home Tab Tutorials

CLIPBOARD PANEL

Cut & Paste
[Moving cells contents in another cell.]
Select the cell/cells which you want to move and click Cut (Ctrl+X) from Clipboard panel.
Put the cell pointer where you want to move your text and click Paste (Ctrl+V) from
Clipboard panel. Cut & Paste commands are showing below with red rectangle border:

Note: When you use cut or copy command Excel displays an animated moving border around cells. Press ESC for cancel a moving border.

Copy & Paste
[Copying cells contents in another cell.]
Select the cell/cells which you want to copy. Click Copy (Ctrl+C) from Clipboard panel.
Put the cell pointer where you want to copy your text and click Paste (Ctrl+V) from Clipboard panel.

Undo
[Retrieve the last action or actions that you made.]
Select some text and press Delete key from keyboard. Now Press Ctrl+Z from keyboard. Follow that your text is retrieve which you deleted.


FONT PANEL

Change Font
[For changing Font]
If you want to change the font for selected cells or ranges in worksheet, do the following below command.
Select the cell or range text which you want to change font. Click on font box drop down icon and select font which you need.

Change Font Color
[For changing Font Color]
If you want to change the font color for selected cells or ranges in worksheet, do the following below command.
Select the cell or range text which you want to change font color. Click on font color box drop down icon and select color which you need.

Bold Text
[To make text Bold]
If you want to change the font in Bold format for selected cells or ranges in worksheet, do the following below command.
Select the cell or range text which you want to change font in Bold format. Click on Bold  icon or Press Ctrl+B from keyboard.

Italic Text
[To make text italic format]
If you want to change the font in Italic format for selected cells or ranges in worksheet, do the following below command.
Select the cell or range text which you want to change font in Italic format. Click on Italic icon or Press Ctrl+I from keyboard.

Underline Text
[To Underline Text]
If you want to Underline text for selected cells or ranges in worksheet and do the following instruction is given below.
Select the cell or range text which you want to change font in Underline format. Click on Underline drop down icon and select your necessary style or Press Ctrl+U from keyboard.

Fill Color
[To choose a color for the cell or shape]
Select Cell or a range which you want to fill color and do the following instruction is given below.
Click on Fill Color drop down icon and click on your selected color.

Post a Comment

Previous Post Next Post