Excel 2019 Bible

Chapter 4: Working with Excel Ranges and Tables

4

Copying a range to other sheets

You can use the copy procedures described previously to copy a cell or range to another

worksheet, even if the worksheet is in a different workbook. You must, of course, activate

the other worksheet before you select the location to which you want to copy.

Excel offers a quicker way to copy a cell or range and paste it to other worksheets in the

same workbook:

1. Select the range to copy.


2. Press Ctrl and click the sheet tabs for the worksheets to which you want to
   copy the information. Excel displays Group in the workbook’s title bar.


3. Choose Home ➪ Editing ➪ Fill ➪ Across Worksheets. A dialog box appears to ask
   you what you want to copy (All, Contents, or Formats).


4. Make your choice and then click OK. Excel copies the selected range to the
   selected worksheets; the new copy occupies the same cells in the selected work-
   sheets as the original occupies in the initial worksheet.

Be careful with the Home ➪ Editing ➪ Fill ➪ Across Worksheets command because Excel doesn’t warn you when the

destination cells contain information. You can quickly overwrite lots of cells with this command and not even realize

it. So make sure that you check your work, and use Undo if the result isn’t what you expected.

Using the Office Clipboard to paste

Whenever you cut or copy information in an Office program such as Excel, you can place

the data on both the Windows Clipboard and the Office Clipboard. When you copy informa-

tion to the Office Clipboard, you append the information to the Office Clipboard instead of

replacing what is already there. With multiple items stored on the Office Clipboard, you can

then paste the items either individually or as a group.

To use the Office Clipboard, you first need to open it. Use the dialog box launcher on the

bottom right of the Home ➪ Clipboard group to toggle the Clipboard task pane on and off.

To make the Clipboard task pane open automatically, click the Options button near the bottom of the task pane and

choose the Show Office Clipboard Automatically option.

After you open the Clipboard task pane, select the first cell or range that you want to copy

to the Office Clipboard and copy it by using any of the preceding techniques. Repeat this

process, selecting the next cell or range that you want to copy. As soon as you copy the

information, the Office Clipboard task pane shows you the number of items that you’ve