converting website visitors
Microsoft Office Tip & Tricks Menu
Tip & Tricks Menu

Need to create a new Excel Worksheet that’s similar to one you already have?

Tuesday January 4, 2011 at 9:36am
Don’t just insert a blank sheet and copy and paste the information you need… copy the whole Worksheet by dragging the sheet tab to where you want the new sheet to be and holding the CTRL key while you release the mouse button. Then you can adjust the new sheet as you wish.

This way, everything about the existing Worksheet is copied, including column widths, filter settings, page setup, headers and footers and so on.

Oh, and by the way, you can even drag the Worksheet to a different Workbook!
» Categories: Microsoft Excel

Comments

There aren't any comments for this post yet. Why not be the first to comment?

Leave a Comment

Your Name
  
Email Address (kept hidden)
  
Website
 
Comment
  

So that we can check that you are a real person (and not a crafty computer),
answer this simple sum:

What is 13 - 3?
  
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411 email:tracey.chaplin@getoncourse.net
Website Design by ZARR Ltd