[ Pobierz całość w formacie PDF ]
.Tip Always collectYou can change the normal collect and copy behavior so that Excel collects items everytime you copy or cut, regardless of whether the Clipboard task pane is present.To do so,click the Options button at the bottom of the Clipboard task pane and choose Collect With-out Showing Office Clipboard.148Chapter 7 Part 3: Formatting and Editing WorksheetsWorksheet Editing TechniquesThere are several ways to display the Clipboard task pane:Ï% Choose Edit, Office Clipboard.Ï% Press Ctrl+C twice, quickly, without changing the selection.Ï% If the task pane is already visible, click the small downward-pointing arrow in the taskpane title bar and choose Clipboard from the menu.Each time you copy or cut an item, a short representation of the item appears in the Clip-board task pane.Figure 7-1 shows three different items in the Clipboard task pane.You canpaste any or all of the items wherever you choose.To paste an item from the Clipboard taskpane, select the location where you want the item to go, and then click the item in the taskpane.To empty the Clipboard task pane for a new collection, click the Clear All button.Tip Assemble quick listsAlthough Collect And Copy is useful for editing tasks, it can also be a great tool for gather-ing information.Copy items such as names or addresses from various locations in theorder you want them to appear.Then click the Paste All button on the Clipboard task paneto paste all the items you have collected, in the order collected, into a single column.Pasting MultiplesAfter you copy, press Ctrl+V to paste whatever you copied.It s a no-brainer.However, didyou know that if you select a range of cells before pasting, Excel fills every cell in that rangewhen you paste? Figure 7-2 illustrates this.f07ie02Figure 7-2.Before you paste, select more cells than you copied to create multiple copies ofyour information.In Figure 7-2, we did the following:Ï% Copied cell A1, and then selected the range C1:C12 and pasted, resulting in Excelrepeating the copied cell in each cell in the selected range.Ï% Copied Cells A1:A4, and then selected the range E1:E12 and pasted, resulting in Excelrepeating the copied range within the range.149Chapter 7 Part 3: Formatting and Editing WorksheetsMicrosoft Office Excel 2003 Inside OutÏ% Copied cells A1:A4, and then selected cell G1 and pasted, resulting in an exact duplicateof the copied range.Note If the selected paste range contains more cells than the copied range, Excelrepeats the copied cells until it fills the destination.However, if the paste range is smallerthan the copied range, Excel pastes the entire copied range anyway.Using the Paste Options Smart TagNotice in Figure 7-2 that we clicked the Paste Options smart tag action menu that appearsnear the lower left corner of the pasted range.This smart tag appears whenever and whereveryou paste, offering action options applicable after pasting a sort of Smart Paste Special. The best part is that you can try each action in turn.Keep selecting Paste options until youlike what you see, and then press Enter.The following describes each item on the PasteOptions smart tag action menu:For more information about using smart tags, see Smart Tags on page 919.Ï% Keep Source Formatting.Retains formatting.This is the default action.If the otheroptions don t work for you, you can always come back to this one before you press Enter.Ï% Match Destination Formatting.Copies formatted data into a differently formattedtable without having to redo the formatting.Ï% Values And Number Formatting.Pastes values without losing number formats.Ï% Keep Source Column Widths.Retains column widths.This option is like choosingKeep Source Formatting with the added action of pasting the column width.Ï% Formatting Only.Leaves the contents of the cells alone and transfers the formatting.This works in the same way as the Format Painter button on the Standard toolbar.Ï% Link Cells.Instead of pasting the contents of the cut or copied cells, pastes a refer-ence to the source cells, ignoring the source formatting.Cutting and PastingWhen you cut rather than copy cells, subsequent pasting places one copy in the selected des-tination, removes the copied cells from the Clipboard, and removes the marquee.Select therange you want to move, and press Ctrl+X, which places the marquee around the cut cells.When you press Ctrl+V to paste, Excel moves the cut cells to their new location and removesthem from their original location.When you cut and paste, the following rules apply:Ï% Excel clears both the contents and the formats of the cut range and transfers them tothe cells in the paste range.Ï% Excel adjusts any formulas outside the cut area that refer to that cell.150Chapter 7 Part 3: Formatting and Editing WorksheetsWorksheet Editing TechniquesÏ% The area you select for cutting must be a single rectangular block of cells.If you try toselect more than one range, you ll get an error message.Ï% Regardless of the size of the range you select before pasting, Excel pastes only the exactsize and shape of the cut area.The upper left corner of the selected paste area becomesthe upper left corner of the moved cells
[ Pobierz całość w formacie PDF ]