Copy Your Sheet as a Backup – Better Safe Than Sorry!

Many times I’m working with a large worksheet and want to try different things – changes in format, column widths, altering formulas and the like, but I don’t want to mess with my data…just in case.  What I do is make a copy of that sheet to play with.

One way to accomplish this is to do a “Save As” and change the file name. Now I would have two different files that I would need to toggle between.

An alternative is to copy it within the same workbook. The easy way to do that is to hold down the Ctrl key and click and drag the sheet tab to the right or left.

71916-1

This makes a copy of the worksheet and inserts a (2) after the sheet name. Now you have a play area in the same workbook with your original data intact!

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply