The Home Tab – Clipboard Group

The Home Tab01
The Home tab is probably where you will spend most of your time as this contains the most common commands like formatting & style commands, commands to insert and delete rows or columns, plus an assortment of worksheet editing commands.


THE CLIPBOARD GROUP

The Home Tab Clipboard1
Starting from the left the first group is the Clipboard group. This group contains the standard copy, cut, paste and paste special options as well as the very useful Format Painter.


COPY & PASTE

The Copy and Paste commands allow you to copy the contents of a cell(s) including all formatting to another cell(s).
Below is an example of this command.
The Home Tab - Clipboard1

  • Type MasterExcel.net into cell A1.
  • Click Copy in the Ribbon. Ctrl+C (you should now see the dancing ants around cell A1)
  • Click on cell B1.
  • Click Paste in the Ribbon. Ctrl+V

MasterExcel.net now appears in both cells A1 & B1

You can also paste the contents into multiple cells.
Using the above steps select cells A4:B6 and click Paste.

TIP
When you enter data into a cell and press enter Excel drops down to the next cell by default.
If you press Ctrl+Enter you will stay in the same cell.


PASTE SPECIAL

Excel normally copies all the information in a cell or in a range of cells you select when you paste the data. You can use the Paste Special command to specify other options, such as pasting only the cell contents (without the formatting) or only the formatting (without the cell contents).

To paste particular parts of a cell selection

Select the cell(s) and click Copy.
The Home Tab Clipboard6

Select the cell(s) where you are going to Paste the copied cell(s) into.
Click the arrow at the bottom of the Paste command in the ribbon.
The Home Tab Clipboard7

Select Paste Special to open the Paste Special dialog box
The Home Tab Clipboard8


CUT

The Cut command is similar to the Copy command only when you select Cut the contents of the cell is deleted once you click Paste in another cell.
Below is an example of this command.
The Home Tab Clipboard3

  • Type MasterExcel into cell A1
  • Click Cut in the Ribbon (you should now see the dancing ants around cell A1)
  • Click on cell B1
  • Click Paste in the Ribbon
  • MasterExcel should now appear in cell B1 and be removed from A1

TIP
Keyboard Shortcut to Cut Ctrl+X


COPY AS PICTURE

The Home Tab Clipboard4
The Copy As Picture command allows you to copy part of your Worksheet as an image. This can be very useful when you want to include a snapshot of your Worksheet in an email, document or within a presentation.

The Home Tab Clipboard5

  • Select the cell(s) you want to copy.
  • Click the Copy Dropdown Arrow.
  • Select Copy as Picture.
  • Select a place in the worksheet and click Paste.

You can also paste the image in other applications like Work, Outlook, Powerpoint etc.


FORMAT PAINTER

The Format Painter can be used to quickly copy an existing format to other data. For example if you have formatted a range with a special font size, border, alignment and background colour you can easily transfer that format to data elsewhere in your spreadsheet using the Format Painter button without changing the text contained in the cell.

The Home Tab Clipboard9

  • Type in MasterExcel.net into cell A1
  • Type in MasterExcel.net2 into cell B1
  • Format the cell A1 by adding Bold, font colour, background colour
  • Click Format Painter in the Ribbon (notice that the cursor icon has changed to a paint brush)
  • Click in cell B1
You will notice the format you added in cell A1 has been added to cell B1 but the text has stayed the same as this command only copies the formatting of the cell and not the actual cell contents.If you double click on Format Painter you can click multiple cells to paste the formatting in, click Format Painter once to end.




Be the first to comment

Leave a Reply