Copy your Excel Sheet or Copy your Excel Sheet.

Posted on March 13, 2008 
Filed Under Excel Tips & Tricks

There is in fact a difference between copying your sheet and copying your sheet. There are two ways. The first is to copy the entire sheet and the second is to copy and paste all the cells in your sheet.

 

Both options seem the same but when you move a sheet your formula will adjust to the moving. When you copy your cells the exact formula will be copyed along with the cells.

 

There are more ways for copying your entire sheet but the two easiest are:

 

The first way is:

  • Right click on your sheet tab.
  • Click on Move or Copy.
  • Select your location
  • And Click OK.

 

The second way is:

  • Go to the sheet tab with your mouse.
  • Press Ctrl
  • And hold the mouse and drag the sheet tab to a second sheet tab.

 

 

You can also Copy and Paste all the Cells.

  • Place your cursor in your sheet.
  • Press CTRL+A
  • Press CTRL+C
  • Select a different tab
  • And Press CTRL+V

 

I hope you all liked this Excel Tip and Trick and ill talk to you all tomorrow, See you!!

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

Leave a Reply