Enable display of the clipboard in the Word. Excel clipboard expands copying options

Until now, we were talking about the Windows clipboard, in which only one object (a fragment of text, table, picture, etc.) can be saved. Office 2003 programs have their own shared clipboard. It can store up to 24 objects with a total size of up to 8 megabytes (the twenty-fifth object in order will "push" the object that got into the buffer first). So far, we have described the insertion methods designed to include in the document the object (block of cells) that was last placed on the clipboard. In order to have access to all objects on the clipboard, you must display the Clipboard page of the task pane. To do this, do one of the following: - execute the Office Clipboard ...

(Edit) or - enable the Task Pane (View) command and go to the Clipboard page, or - double-click the combination Ctrl + C (or Ctrl + Insert). The objects in the buffer are represented by icons of the programs from which they were copied or cut, together with a small fragment of the object. If the object was copied from a program that is not part of Office 2003, then it will have a standard icon. To insert an object from the clipboard, select the insertion point (for Excel, this means placing the table cursor at the insertion point) and on the Clipboard page do one of the following: - click on the object in the list; - execute the Insert command of the context menu of an object or the menu that opens after clicking on the arrow that appears when the mouse cursor is hovering over the object.

To insert all objects at the same time, you must select the insertion point and click the Paste All button. The objects will be inserted in the order in which they entered the clipboard. To delete an object from the clipboard, execute the Delete command from the context menu of the object or the menu that appears when you click on the arrow. All objects can be deleted by pressing the Clear All button.

Using the techniques described above, you can copy and move not only the cells themselves, but also fragments of their content through the clipboard. In this case, the same techniques are used as for the cells. The main difference is that before copying, cutting, and pasting fragments, you must enter the cell editing mode and select a fragment of the cell content.

Example 23.

Copying and moving cells.

Clipboard

Step 1

Open the document First Book, go to sheet Sheet2. Run the command Options ... (Service). In the Options dialog box that appears, on the Edit tab, make sure that the Dragging Cells and Warn Before Cells Overwrite radio buttons are turned on. If they are turned off, turn them on and click OK.

Step 2

Select the block of cells from EZ to F4 (if the previous exercises were performed, then this block should contain data). Place the mouse cursor on the border of the block and drag it to cells A1 to B2, which also contain data. In the information window that appears, click the Cancel button. Make sure the move has been canceled.

Repeat dragging the cells from EZ to F4, but in other, free cells E1 to F2. Make sure cells are moved to a new location

Step 3

Select the block of cells from E7 to G7. Place the mouse cursor on the border of the block and, while holding Ctrl, drag it up to cells E4 to G4. Make sure the cells are copied. Select a block of cells from F7 to F9, position the mouse cursor on the border of the block and, holding Shift, drag it up, between cells F3 to F4 (the outline orientation should be horizontal when the mouse is released). Make sure; that the cells have been moved and inserted in a new location.

Step 4

Select the block of cells from E7 to F7, position the mouse cursor on the border of the block and, holding Ctrl + Shift, drag it to the left, between cells B10 to CU (the outline orientation should be vertical when the mouse is released). Make sure the cells are copied and pasted to the new location.

Save document First Book.

Step 5

Open the documents Book One and Book Two. Go to Sheet2 of the First Book document. Select the block from B8 to C9 and click on the Copy B1 tool of the Standard panel (a running path appears around the block).

Use the navigation keys to move the table cursor to cell F7, press Ctrl + V. Verify that the cells were copied and that the occupied cells F7 and G7 were overwritten without warning. Go to the Sheet3 sheet of the First book document, right-click on cell B2, in the context menu that opens, execute the Insert command; go to the SheetDocument Sheet Second Book, click on cell B1, and then on the Insert tool of the Standard panel. Press Esc. Make sure to copy the selected block to three locations.

Step 6

Go to Sheet2 of the First Book document. Select the block from E4 to F7 and click on the Cut tool in the Standard toolbar (a running path appears around the block). Go to Sheet3 of the Second Book document, click cell B10, and then click the Insert tool (in the Standard toolbar). Make sure the selected block is moved to a different workbook

Step 7

On the Sheet3 sheet of the Second Book document, click on cell E6 and execute the Office Clipboard ... (Edit) command.

On the task pane page that appears, click on the second from the top object from the Office 2003 clipboard. Make sure you have pasted (or rather copied) the object from the clipboard that was the penultimate one in the clipboard. Taking into account all the previous actions, this should be the contents of the block from B8 to C9 from sheet Sheet2 of the First book document. In the task pane, click the Clear All button.

Close the task pane. Save and close the document First Book. Close the second book document without saving.

The practical application of the benefits of the Clipboard tool is best illustrated with examples.

With the advanced clipboard features, you can improve your Excel performance when copying and pasting items. These are some of the most commonly used Excel operations. Therefore, it is worth learning how to use them professionally. Moreover, it is not difficult.

Copy multiple items to clipboard

To begin with, we will demonstrate with an example how you can quickly fill in data in a table using the clipboard. To do this, create an initial plate as shown in the figure:

To quickly fill cells using a buffer, you must:

As you can see, you no longer have to copy every time you need to fill cells with duplicate values. It is very convenient and time-saving.

Excel clipboard management

The clipboard can contain up to 24 items. In Excel, it doesn't matter what to copy: a table, a column, a row, the contents of one cell, or just text - all these are separate elements, regardless of their amount of information. When copying the 25th element, the first one is deleted automatically.

You can control the contents of the buffer. If it contains unnecessary elements, delete them. To do this, right-click on the extra element and select the "Delete" option. To completely clear the Excel clipboard, click on the "Clear All" button in the side window.

Information about the number of elements is displayed in the window title. There is also a button for closing the side window of the "X" tool.

If the side window of the tool bothers you, but you want to continue filling it with elements, then do this:

It is very convenient to work this way, especially when you need to copy data to other Excel sheets or to other programs of the MS Office package (for example, Word). Each program included in the MS Office package has a Clipboard tool. This means that in each of these programs you can call the buffer window to selectively insert elements. This tool allows you to effectively organize the simultaneous work with several documents.

Note. Moving data is carried out in the same way as copying. Only instead of the CTRL + C key combination, you should press CTRL + X, and instead of the "copy" options, you should select the "cut" option.

Clipboard is one of the Microsoft Office tools with which you can quickly exchange information between various documents created in one or more applications. In other words, this is a part of the computer's memory allocated for the temporary storage of information (text, pictures, etc.).

24 objects can be stored in the clipboard at the same time. If you continue copying, the previously copied objects will be automatically deleted.

Like any other Office tool, the clipboard has its own settings. To see them, you need to start Word and open the clipboard in the upper left part of the window.

In this case, the "Parameters" menu will appear at the bottom, where you can select the appropriate settings using the checkboxes.

The clipboard allows you to do three things:

Copy, while the selected object will remain both in the original document and in the clipboard;

Cut, in this case the selected object will be removed from the original text and will remain only in the clipboard;

Insert.

In Word 2010, there are several options for pasting. This is definitely a big plus, as in previous versions of Microsoft Office, the insertion process did not always bring the desired results. Sometimes the copied text could not be formatted according to the sample, and it was easier and faster to retype it.

The creators of Microsoft Office 2010 tried to provide for different cases. In this case, the set of options depends on which application you are going to copy the object from. If from Word 2010 - then it looks like this:

From Excel - differently:

In addition, Microsoft Office has a preview to see which insertion option is needed.

In this case, the menu bar becomes transparent, and the insert object is clearly visible.

In other words, we hover the mouse over the insert button, but do not click and see what happens if we click.

Let's see how the same text will look when you select different paste options.

It was originally like this:

Word 2010 offered 3 options for pasting:

2.combine formatting:

Please note: next to the name of the insert parameter in Word 2010, hotkeys are displayed that allow you to work without using the mouse.

Thus, the improved and expanded paste function allows you to select the desired type of inserted object and significantly saves formatting time. This is especially convenient when it comes to writing abstracts, where the already existing text is usually taken as a basis, but the text contains a lot of links and formatting. Plain text insertion saves us the hassle of deleting unnecessary things.

The Office Clipboard saves text and pictures, copied or cut from anywhere, and lets you paste the stored into any other Office file. Here's how it's done in Word 2013 or Word 2016.

Cutting and pasting items from the clipboard

Things you can do with the clipboard

Removing items from the clipboard

Perform one of the following actions.

Closing the clipboard

press the button X in the upper right corner of the clipboard panel;

Configuring clipboard options

The options control various functions of the clipboard, such as when to open the clipboard.

At the bottom of the clipboard pane, click Parameters.

Below is a description of all parameters.

Excel for Office 365 Word for Office 365 PowerPoint for Office 365 Publisher for Office 365 Access for Office 365 Excel 2019 Word 2019 PowerPoint 2019 Publisher 2019 Access 2019 Excel 2016 Word 2016 PowerPoint 2016 Publisher 2016 Access 2016 Excel 2013 Word 2013 PowerPoint 2013 Publisher 2013 Access 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Access 2010 Publisher 2010 Excel 2007 Word 2007 Outlook 2007 PowerPoint 2007 Publisher 2007 Access 2007 SharePoint Designer 2007 Less

Office Clipboard lets you copy up to 24 items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an email message, data from a book or spreadsheet, and a picture from a presentation, and then paste them all into your document. You can use the Office Clipboard to arrange copied items in your document in the order you want.

When using the task pane Clipboard you can paste not only the last copied or cut object. Task area Clipboard contains the last few images or text snippets you copied or cut.

Note: You can still cut, copy, and paste in the standard way - using the buttons on the ribbon or the keyboard shortcuts CTRL + X (Cut), CTRL + C (Copy), and CTRL + V (Paste).

Opening the Clipboard Task Pane in Office Applications

To open the task pane Clipboard, open the tab home and then click the Dialog Box Launcher Clipboard... Double-click the image or piece of text you want to insert.

Note: To open the task pane Clipboard in Outlook, in an open message, open the tab Message and then in a group Clipboard click the dialog box launcher Clipboard.

Copy and paste multiple items using the Office Clipboard

Remove items from the Office clipboard

You can delete items from the Office Clipboard one at a time or all at once.

In the field of tasks Clipboard do one of the following.

Customize the display of the clipboard in Office

To customize how the Office Clipboard displays, click Parameters at the bottom of the task pane.