How to Copy & Paste Entire Worksheet. Keep Formulas And Settings.

Name: How to Copy & Paste Entire Worksheet. Keep Formulas And Settings. | Open Video
Uploaded: 2025-06-22T15:33:55+00:00
Duration: 1 min 44 s

0:00
hi everyone my name is Barbara welcome
0:01
back to my YouTube channel today I'm
0:03
going to show you how to copy or
0:05
duplicate a worksheet within your
0:07
current workbook without losing any
0:09
formatting or formula in a previous
0:12
video I showed you how to make a copy of
0:14
your worksheet into a completely new
0:16
workbook by selecting new book create a
0:20
copy and hitting okay and you can see
0:22
this is a completely new workbook that's
0:25
been created with that with that
0:29
worksheet
0:30
I'll put a link in the description box
0:32
below to that video if you want to watch
0:34
it but today what we're going to do is
0:36
we're just going to make is copy this
0:37
worksheet within the same workbook this
0:39
can be really useful if you've got a
0:41
template on uh your first worksheet or
0:44
one of your worksheets and you want to
0:46
create a new one every month you don't
0:48
want to create a new book what we want
0:49
to do is we want to copy the worksheet
0:52
within the book so we want to create a
0:54
copy if you want to move it to the end
0:57
of your workbook if you've got a lot of
0:59
tabs select select move to end or select
1:02
the sheet that you want to place it
1:04
before I've only got one worksheet in
1:06
this workbook but we'll put it before
1:08
sheet one I've selected that and hit
1:10
okay I'll just go back and demonstrate
1:13
how to move it to the end so I want to
1:15
create a copy and move it to the end and
1:17
this is going to move it to this
1:18
position here after sheet
1:21
one so that's it that's how to make a
1:23
duplicate or a copy of a worksheet
1:26
within the same workbook great for
1:28
templates and you don't lose any
1:30
formatting or formulas I hope you
1:34
enjoyed the tip if you did give it a
1:36
thumbs up subscribe hit the notification
1:38
Bell and you'll be notified when I
1:40
upload my next video it really does help
1:42
the channel thanks for watching

How to Copy & Paste Entire Worksheet. Keep Formulas And Settings.

howtoexcelatexcel.com

Speed Up Excel: Set Your Preferred Chart Type

How To Import Excel Data Into Google Maps. Create Your Own Map!

Move An Excel Pivot Table - Excel Tip

Modeling and Drafting in FreeCAD 04 | FreeCAD Tutorial | Mechnexus |

How to Create a Juice Can Mockup in Canva

How to Add a Link in a Resume Using Canva (Simple Tutorial For Beginners)

FreeCAD Part Modeling Tutorial 80 | FreeCAD Tutorial | Mechnexus |

FreeCAD Part Modeling Tutorial 81 | FreeCAD Tutorial | Mechnexus |

Delete All Excel Shapes Instantly With Just One Click!

Excel Tip :Sum Multiple Worksheets. #exceltricks #spreadsheetmagic #exceltips

Master These Excel Column Resizing Tricks Most Users Don't Know #excel #shorts

Excel Data Tables: A Beginner's Guide

Up next in 10

How to Copy & Paste Entire Worksheet. Keep Formulas And Settings.

howtoexcelatexcel.com