How to Move a Table in Excel & Google Sheets
This article will demonstrate how to move a table in Excel and Google Sheets.
Drag Table to New Location
- Highlight the table you wish to move.
- Position your mouse at the bottom of the table so that the mouse pointer changes to a small black cross.
3. Drag the table to it’s new location and then adjust the column widths as required.
Cut and Paste a Table in a new Location
- Highlight the table you wish to move.
- In the Ribbon, select Home > Clipboard > Cut or press CTRL + X on the keyboard.
- Click in the cell where you want the table to be move to ( the top left hand cell of the table will be placed in the selected cell), and then, in the Ribbon, select Home > Clipboard > Paste or press CTRL + V on they keyboard.
- The table will be moved to your selected location. You can then adjust the columns widths as required.
How to Move a Table in Google Sheets
Tables as they exist in Excel do not exist in Google Sheets. However, you can move a range of cells that is formatted as a table by either dragging the cells to their new location, or using Cut and Paste.
- Highlight the range of cells in Google sheets and move your mouse to the edge of your table. This can either be at the bottom, top, left or right of the table. You will notice that your mouse pointer changes to show a small hand.
- Click and hold down your mouse so that the hand closes to show a fist.
- Now drag your mouse to the destination range where you wish to place your table.
- Release the mouse to move your table.
You can also use the Edit menu to cut (or CTRL + X) and Paste (or CTRL + V) to move your table as you can do so with Excel.