Easily Move An Excel Data Table


It is really easy to move a whole Excel data table to a new location on the same worksheet or even a new location on a different worksheet in the same workbook or an entirely different workbook. I find I need to do this sometimes if I am building a spreadsheet solution which more than most times needs to be tweaked, until I am finally happy with it.

 

To move an excel table to a new location within the same worksheet just move the mouse pointer to any of the tables borders, when the mouse pointer turns into a cross with four arrows just click and drag the table to its new location.

 

If you want to move the table a different sheet within the same workbook or a completely different workbook then

  • Select any cells in the table and press CTRL+A twice to select the entire table.
  • Press CTRL+X to cut the selected cells
  • Activate the destination worksheet and select the position you want the upper left cell for your table
  • Hit CTRL+V to paste the table

 

Easy as that!

 

More Excel Tips

Default Your Pivot Tables To SUM not COUNT

Excel Tutorial -Creating An Excel Table

Delete obsolete items from your Pivot Tables blog post or watch the YOUTUBE video..

images-15

vlookup-book-cover

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts