How to Move a Table in Excel

Whether it’s a formatted Excel table or a plain block of data, you can move it anywhere on the sheet, to another worksheet, or into a different workbook. Excel keeps the formatting, formulas and any charts or references that depend on it, as long as you move it the right way.

This guide covers the quickest drag-and-drop method, cut and paste, moving between sheets and workbooks, and the errors you might run into along the way.

How to Move a Table in Excel by Dragging

Step 1: Select the whole table

For a formatted Excel table, click any cell inside it and press Ctrl + A twice to select the entire table, including the headers. You can also hover over the table’s top-left corner until a small diagonal arrow appears and click. For a plain range, click the first cell and drag to the last one, or click a cell and press Ctrl + A.

Step 2: Grab the border

Move your mouse to any edge of the selection until the pointer changes to a four-headed arrow.

Step 3: Drag to the new location

Click and drag the table to where you want it, then release the mouse button. Excel shows an outline of where the data will land. If the destination already contains data, Excel asks whether you want to replace it.

Step 4: Check your column widths

Column widths belong to the sheet, not the table, so the table may look cramped in its new spot. Select the columns and double-click a column border to AutoFit them.

Move a Table with Cut and Paste

1. Select the whole table.
2. Press Ctrl + X to cut it. A moving dashed border appears.
3. Click the cell where the top-left corner of the table should go.
4. Press Ctrl + V.

Cut and paste is best when the destination is far away, on another sheet, or in another workbook. Microsoft explains both methods in its guide to moving or copying cells, rows and columns.

Insert a Table Between Existing Data

To move a table without overwriting anything, cut it, right-click the destination cell and choose Insert Cut Cells. Excel shifts the existing cells down or to the right to make room. You can also drag while holding Shift to insert the table between rows or columns.

Move a Table to Another Worksheet

• Cut and paste: cut the table, click the other sheet’s tab, select the destination cell and paste.
• Drag with Alt: start dragging the table’s border, hold Alt, and move over the destination sheet’s tab. Excel switches to that sheet so you can drop the table.
• Move the whole sheet: if the table is the only thing on the sheet, right-click the sheet tab, choose Move or Copy, and pick a new position or workbook.

Move a Table to Another Workbook

Open both workbooks. Cut the table in the first one, switch to the second with Ctrl + Tab or the taskbar, select a cell and paste. Formulas that pointed to other cells in the original workbook will now include a link back to it, so check for external links under Data > Edit Links afterwards. To move a whole sheet with its table, see how to copy a sheet to another workbook in Excel and choose to move instead of copy.

Move a Table in Excel for the Web

Excel for the web supports both methods. Select the table, then drag its border, or use Ctrl + X and Ctrl + V. Moving between workbooks in the browser works best with cut and paste, and your browser may ask for clipboard permission the first time. If a move goes wrong anywhere, press Ctrl + Z straight away to put the table back.

Convert a Table Before Moving It

Occasionally you only want the data, not the table features. To turn an Excel table back into a normal range before moving it, click inside it and choose Table Design > Convert to Range. The formatting stays, but filters and structured references go away. See how to undo a table in Excel for details.

What Happens to Formulas When You Move a Table

• Formulas inside the table keep working, because moving adjusts their references to follow the data.
• Formulas elsewhere that refer to the table also update automatically, including structured references like Table1[Sales].
• Charts and PivotTables built from the table keep their connection.
• Copying is different. If you copy and paste instead of cutting, relative references in the pasted formulas shift, and other formulas keep pointing to the original.

Troubleshooting

• “This won’t work because it would move cells in a table on your worksheet.” You tried to insert or delete cells that cut through a table. Move the whole table, or insert entire rows or columns instead.
• “Cannot change part of a merged cell.” Merged cells at the destination are in the way. Unmerge them with Home > Merge & Center first.
• The drag pointer doesn’t appear. Drag-and-drop may be turned off. Go to File > Options > Advanced and check Enable fill handle and cell drag-and-drop.
• Paste is greyed out or fails. The sheet may be protected. Unprotect it on the Review tab.
• Formatting looks different. Column widths and row heights don’t travel with cut and paste. AutoFit the columns, or use Paste Special > Column widths when copying.

Tips

• Name your table on the Table Design tab before moving it, so formulas stay readable with structured references.
• Leave at least one empty row and column around a table, so Excel doesn’t treat nearby data as part of it.
• Need to rearrange columns inside the table instead? See how to move a column in Excel.
• If you meant a table in Word, see how to move tables in Word.

Frequently Asked Questions

What if my table is very large?

Use cut and paste instead of dragging, so you don’t have to scroll while holding the mouse. Selecting with Ctrl + A inside the table is quicker than dragging across thousands of rows.

Is there a keyboard-only way to move a table?

Yes. Select the table, press Ctrl + X, use the arrow keys or Ctrl + G to go to the destination cell, and press Ctrl + V.

Can I move a table on a Mac?

Yes. Drag the border the same way, or use Command + X and Command + V.

Does moving a table remove its formatting?

No. Table styles, filters and banded rows move with the table. Only sheet-level settings like column widths stay behind.

Wrapping Up

Select the whole table, then either drag its border or cut and paste it. Use Insert Cut Cells to avoid overwriting data, and Alt-drag or Move or Copy to send it to another sheet. Formulas, charts and PivotTables follow the table automatically.

Related: how to move a column in Excel.

Related: how to undo a table in Excel.