How to copy a table in Excel

Excel has several options for formatting text and numbers. It also has the provision to define a set of data as a Table. This is a useful feature especially when you need to create totals and calculated columns. It also becomes easy to add data and reference data when it is defined as a table. You can use the formatting options to change the way text and numbers are displayed in the table to improve its appearance. When you create a table, you may want to copy it to use it as a template for another template or to move it to another location.