Copy the format of the entire column in Excel 2007

You can copy the format of entire column(s) including column width, number format in the cells, text format in the cells, borders, fill and apply it to other columns.

In the image to the right, column C is 200 pixels wide. Cell C2 has Thick Box Border. Cells C3 to C9 has the information about the format as provided in the image. Cells C9 and C10 are merged. Cell C11 has wrapped text, and cell C12 has the Currency format.

When you copy the format, all details excluding the data in the cells are copied. Perform the following steps to copy the format of the entire column:
1. Click column heading C. The entire column will be selected.
2. On the Home tab, in Clipboard group, click Format Painter
3. Click any column header (Example: E).

Column E will have the formats exactly that of column C.

Show or hide the Office Clipboard tooltip that appears near the taskbar in Excel 2007

In Office Clipboard, you have an option called Show Status Near Taskbar When Copying. When this option is checked, you will see a tooltip near the taskbar whenever you copy data. When you turn off this option then the tooltip will not appear.

Perform the following steps to show or hide the Office Clipboard tooltip that appears near the taskbar:
1. On the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

2. Click Options and do one of the following:
To show the Office Clipboard tooltip, click to place a checkmark besides Show Status Near Taskbar When Copying.
To hide the Office Clipboard tooltip, click to remove the checkmark besides Show Status Near Taskbar When Copying.

Show or hide Office Clipboard icon on Taskbar in Excel 2007

If you see the Office Clipboard icon on the taskbar then the Show Office Clipboard Icon on Taskbar option in the Office Clipboard pane has a checkmark besides it. If you remove the checkmark then the Office Clipboard icon will not appear on the taskbar.

Perform the following to show or hide the Office Clipboard icon on taskbar:

1. On the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

2. Click Options and do one of the following:
To show the Office Clipboard icon on taskbar, click to place a checkmark besides Show Office Clipboard Icon on Taskbar.
To hide the Office Clipboard icon on taskbar, click to remove the checkmark besides Show Office Clipboard Icon on Taskbar.

Office Clipboard does not show after pressing Ctrl + C keys twice in Excel 2007

By default, the Office Clipboard pane shows up when you press the CTRL + C keys twice. If it does not show up then the Show Office Clipboard When Ctrl + C Pressed Twice option in the Office Clipboard Task Pane is not checked.

Above the Show Office Clipboard When Ctrl + C Pressed Twice option is the Show Office Clipboard Automatically option. If the Show Office Clipboard Automatically option is checked then the Show Office Clipboard When Ctrl + C Pressed Twice option gets checked automatically. They both work in tandom but if you place a checkmark besides the Show Office Clipboard When Ctrl + C Pressed Twice option then the Show Office Clipboard Automatically option does not place a checkmark besides it automatically.

Perform the following to show the Office Clipboard when you press the CTRL + C keys twice:

1. On the Home tab, in the Clipboard group click the Clipboard Dialog Box Launcher.
2. In the Office Clipboard Task Pane, click Options and click Show Office Clipboard Automatically (Refer to the image above). This will automatically place a checkmark besides Show Office Clipboard When Ctrl + C Pressed Twice or click only the Show Office Clipboard When Ctrl + C Pressed Twice option.

Paste items from the Office Clipboard in Excel 2007

Click the place where you want to paste and click on an item. That's it, the item is pasted. You can also paste all the items at once by clicking the Paste All button .

Note:
If the items in the Clipboard are all text-based, i.e., text copied from Notepad, WordPad, Word, Excel, Access, PowerPoint or other program then the Paste All button remains enabled. Also, if all the items are images then the button remains enabled.
On the other hand if the items are a collection of text-based and images then the button gets disabled.

Resize Office Clipboard in Excel 2007

To resize the Office Clipboard, click the Task Pane Options button which is represented by a DOWN arrow and click Size. The mouse cursor changes to Horizontal Resize . Move the mouse towards left or right. Once you had resized, click the mouse to set it.

Copy items to the Office Clipboard

The Office Clipboard can hold 24 items. To place an item in the Office Clipboard task pane, select the text that you need to copy. On the Home tab, in the Clipboard group click Copy or press CTRL + C. To turn on the Office Clipboard, on the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

This will place the item in the Office Clipboard pane. It will also show the program from where you copied (E.g., the Word icon will appear if you had copied from Microsoft Word, the Excel icon will appear if you had copied from Microsoft Excel and so on.)
You can also copy images and these items will also appear in the Office Clipboard task pane.
Once you had finished copying 24 items and if you perform a copy operation then it will be present on the top of the list and the last item in the list will be removed to give room to the newly copied item.

Reposition the Office Clipboard to the original position in Excel 2007

By default, the Office Clipboard task pane is docked to the left, just below the Name Box. You can move the Office Clipboard to the right or you can make it float. It is positioned to the right or is floating then perform the following to reposition the Office Clipboard to its original position:

1. Click the Task Pane Options button which is represented by a DOWN arrow and click Move or press F6 function key, press CTRL + SPACEBAR to activate the menu. The Move option is highlighted, press ENTER key. The mouse cursor changes to the Move pointer .
2. Move the mouse to the left part of the screen. You will see the Office Clipboard Task Pane move. When you move to the left most part of the screen below the Name Box, it will dock to the left. Click the mouse button to rest in the original position.

Move the Office Clipboard in Excel 2007

When you turn on the Office Clipboard, it docks to the left just below the Name Box. This is the default position. You can move the Office Clipboard and dock it to the right or you can make it to float. Perform the following to move the Office Clipboard.

1. Click the Task Pane Options button which is represented by a DOWN arrow and click Move or press F6 function key, press CTRL + SPACEBAR to activate the menu. The Move option is highlighted, press ENTER key. The mouse cursor changes to the Move pointer .
2. Do one of the following:

• Dock the Office Clipboard to the right: Move the mouse to the right of the screen. You will see the Office Clipboard Task Pane move. When you move to the right most part of the screen below the Formula Bar, it will dock to the right. Click the mouse button to let it rest in the new position.
• Float the Office Clipboard: Move the mouse to any position in the worksheet area. Click the mouse to let it float.

Turn off Office Clipboard in Excel 2007

There are several ways to turn off the Office Clipboard. Do any one of the following to turn off the Office Clipboard:

Click the Clipboard Dialog Box Launcher: On the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

Click the Close button: In the Office Clipboard Task pane, click the Close button.

Close from the menu: Click the down arrow that is besides the Close button. From the menu that appears, click Close.

Using Keyboard: Press F6 function key. Press CTRL + SPACEBAR to activate the menu. Click the DOWN arrow key twice to highlight Close. Press ENTER key.

Turn on the Office Clipboard in Excel 2007

To turn on the Office Clipboard, on the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

You can also turn on the Office Clipboard using the keyboard by pressing ALT + H + FO.

Delete items from the Clipboard in Excel 2007

The Microsoft Office Clipboard holds upto 24 items. Once you copy text or image, you will see that item in the Office Clipboard Task Pane. At times, you need to delete items. Perform the following steps to delete the items from the Clipboard:

1. View the Office Clipboard Task Pane: On the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher to see the Office Clipboard Task Pane.

2. On the Office Clipboard Task Pane, do one of the following:

• Delete all items: Click the Clear All button
• Delete an item: Click the arrow next to the item that you need to delete. Click Delete.