Editing Worksheets
Microsoft Excel offers a number of features and techniques that you can use to modify your worksheets.
Use standard editing techniques and the Clear command to change or clear the contents of cells.
Use Insert and Edit menu commands to insert or delete cells, columns, and rows.
Use Edit menu commands, the fill handle, and drag-and-drop editing to copy cells from one location to another, including cells containing formulas.
Use the fill handle and Fill submenu commands to copy cell contents to multiple cells or create a series.
Modify formulas so they are properly updated by Excel when copied.
Use Edit menu commands and drag-and-drop editing to move cells from one location to another.
Undo, redo, and repeat multiple actions.
This ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access