Quick Insertion and Deletion

This tutorial looks at insertion-and-deletion editing that goes beyond the mere cell level - where you're limited to just replacing or deleting a cell's particular contents. Here you get a look at larger insertions and deletions that involve structural changes to the worksheet or workbook.

These larger edits include inserting new cells into - or deleting them from - existing ranges. It also shows how to insert new rows and columns into a worksheet and how to (safely) delete existing ones. Finally, it looks at inserting new sheets into a workbook and deleting the ones you no longer need.