How do you drag and insert in Excel?

Move or copy rows or columns Hold down OPTION and drag the rows or columns to another location. Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes space for the new row or column.

What is the shortcut key to insert data in Excel?

6. Want to insert a table, row, column, comment, or chart? Press Ctrl + l to insert a table, Ctrl + Shift + + to insert a cell, row, or column, Ctrl + F2 to insert a comment, and Alt + F1 to insert a chart with data.

What is the shortcut key to drag in Excel?

In Windows, use Control + Shift, and on a Mac, use Option + Shift. You can also drag a selection to another worksheet using Alt in Windows, and Command on a Mac. Drag and drop also works on objects, which is mostly useful when you want to duplicate objects that float above the grid.

How do you enter a formula and drag it in Excel?

You just do the following:

  1. Enter a formula in the top cell.
  2. Select the cell with the formula, and hover the mouse cursor over a small square at the lower right-hand corner of the cell, which is called the Fill handle.
  3. Hold and drag the fill handle down the column over the cells where you want to copy the formula.

How do I drag columns in Excel?

To quickly move columns in Excel without overwriting existing data, press and hold the shift key on your keyboard.

  1. First, select a column.
  2. Hover over the border of the selection.
  3. Press and hold the Shift key on your keyboard.
  4. Click and hold the left mouse button.
  5. Move the column to the new position.

How do I shift cells down in Excel?

To shift a single cell downward:

  1. Left-click the cell that you want to be moved in order to highlight it.
  2. Next, right-click that cell to pull up a menu.
  3. From the menu, select Insert… This will prompt an “Insert” window to pop-up.
  4. From this window, select Shift cells down, and then click OK.

What does Alt n do?

Alt+N is a keyboard shortcut most often used to open the Insert option in a file menu or the Ribbon. Related keyboard shortcuts and keys.

How do you drag formula?

Copy a formula by dragging the fill handle

  1. Select the cell that has the formula you want to fill into adjacent cells.
  2. Rest your cursor in the lower-right corner so that it turns into a plus sign (+), like this:
  3. Drag the fill handle down, up, or across the cells that you want to fill.

How do you drag a formula down but reference across?

If you want to be able to drag across, so the next cell to the right would contain =A2-C1 , it is the column A reference you want to lock. The formula in your first cell would =$A2-B1 . If you want to drag both horizontally and vertically to populate the whole table in this fashion, the first cell would be =$A2-B$1 .