Inserting and deleting cells, rows and columns
Excel Tip #009 Inserting and deleting cells, rows and columns There are ways inserting and deleting cells, rows and columns. Below are 3 methods (which I can recollect) in inserting (or) deleting rows and columns. Option 1 (Standard Procedure) : Selecting a row (or) column by clicking it, then right click for options. You can see options "Insert" and "Delete" . This will add a new row in the left (or) a new column in the top. Inserting/Deleting row (or) column - Option 1 (Standard Process) Option 2 (Unusual mouse method) : You can quickly insert a range of empty cells or rows by holding down the SHIFT key while dragging the fill handle. To insert a range of cells, select a single cell above where you want the cells inserted and drag the fill handle down the number of cells you want to insert. Inserting/Deleting row (or) column - Option 2 (Unusual mouse method) Inserting columns works basically the same way by dragging the Fill Ha...