Microsoft Office Tutorials and References
In Depth Information
RIGHT-DRAG BORDER TO ACCESS MORE COPYING OPTIONS
Well, the quotation mark key on your keyboard operates sort of like a ditto
Follow these steps:
Select cells B24:E24.
Hold down the Ctrl key while pressing the apostrophe/quotation mark key.
Excel copies the exact formula from cell B23 in cell B24. Excel leaves the
formula in Enter mode, with the insertion point at the end of the formula.
Press F2 to change the mode from Enter to Edit.
Press Home to move to the beginning of the formula. Press the right arrow
key. Type Average. Press the Delete key three times.
Press Ctrl+Enter to enter similar formulas in B24:E24.
Alternate Strategy: Another solution to this problem is to copy the result of the
formula as a value. If you go to cell B24 and press Ctrl+Shift+”, Excel copies
the result from B23 as a value in cell B24. Unfortunately, you cannot use this
method to ﬁ ll an entire range, such as B24:E24. In that case, you could follow
Select cells B23:E23
Right-click the border of the selection. While holding down the right mouse
button, drag down to row 24.
Release the mouse button and choose Copy Here as Values Only.
Summary: Use the Ctrl+quotation mark to make an exact copy of a formula.
TO ACCESS MORE COPYING OPTIONS
Challenge: You once stumbled upon a handy menu for accessing extra copying
options. But how did you open it, and what can it do for you?
Solution: Excel has an incredibly useful but obscure shortcut menu, as shown
in Figure 71. To open it, you select a cell or a range of cells. Then you right-
click and drag the border of the range to a new location. When you release the
right mouse button, Excel opens this menu, which has the following options,