Home Blog Archive MS Office MS Office Excel: table duplicate

MS Office Excel: table duplicate

  • Oct 13, 2019
  • 40
  • 0

You want to duplicate an Excel spreadsheet, you can copy the content and insert it again. With a little Trick but it's even easier:

Excel table including all settings copying

If you copy in Excel the content of a table and in a different insert, be lost all of the settings you have made to the table. Better is to duplicate the table:
  1. Click with the right mouse button down on the worksheet you want to copy.
  2. In the context menu select "Move or copy...".
  3. Then select a folder and the location you want to copy the data.
  4. You can also activate the Option "create a copy" and click "OK".
MS Excel: table duplicate
Thus the data at any time, copy and edit, you must first find the Excel unprotect sheet. We will show you how to do that.

YOU MAY ALSO LIKE

0 COMMENTS

LEAVE A COMMENT