Question

You want to copy data from one cell or range to an adjacent cell or range in your spreadsheet, without using a shortcut key. Which of the following can you drag on your spreadsheet to do this?

Answer 1

How can you insert a new row into your data without disturbing an adjacent set of data on the same sheet? Highlight only the data where you'd like to insert a row. Right-click > Insert > Shift cells down.