Topic: office

Inserting Cells

9 Feb 04

Do you know that you can insert rows or columns in Excel worksheets using only the mouse? To do so, hold down the Shift key while you grab a cell by its handle and drag it. Excel will insert as many cells as you need.

For example, enter data in cells A1..C1. Now, to insert two cells between cells A1 and B1, hold down the Shift key, grab A1's handle, drag it to cell C1, and then release. Excel will insert two blank cells between cells A1 and B1.

See Other tips, Legacy Tips