The Fill Command
The Fill command works a lot like the fill handle in that it copies information to adjacent cells. But rather than dragging to copy, you select the source and destination cells at the same time and then use the Fill command to complete the copy. The Fill submenu offers several options for copying to adjacent selected cells:
Down copies the contents of the top cell(s) in the selection to the selected cells beneath it.
Right copies the contents of the left cell(s) in the selection to the selected cells to the right of it.
Up copies the contents of the bottom cell(s) in the selection to the selected cells above it.
Left copies the contents of the right cell(s) in the selection to the selected cells to the left of it.
To copy with the ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
