TimeWiseVA – Hints and Tips – Spreadsheet move and/or copy

In a Excel Workbook you may occasionally want to move or copy a spreadsheet….

Select the tab of the spreadsheet you want to copy – Select ‘Cells Block’ on the Home tab – Format – Move or Copy Sheet.

Scroll up or down to choose where you want it to go; please note the criteria is ‘Before Sheet:’ then make sure you click ‘Create a Copy’.

If you want to move a spreadsheet you can do it in one of two ways. As above but don’t tick ‘Create a Copy’ or click on the tab of the worksheet you want to move and drag it to where you want it. NOTE: there is a little black arrow which helps to move it to where you want it to go.

Maybe you have a really good spreadsheet and you want to copy that spreadsheet in the same workbook. So for example you use the same spreadsheet month after month to record (something like flexi time). Name the first tab e.g. January 2012. Copy this spreadsheet as shown above – then click on the tab and rename e.g. February 2012. Do as many time as necessary.

The next thing to do is to enter the dates in the January 2012 tab.  Click on Cell A1 and type in 01/01/2012 – Enter – in Cell A2 type =A1+1 – Enter.  Click on Cell A2 again and drag down until you get to 31/01/2012.

You now have a row of dates from 1 to 31.  NOTE you need to add the +1 to the end of the formula other wise the dates wont increase by one.

Any problems email me on elaine@virtualva.co.uk and attach your spreadsheet

Share this post

Leave a Comment

Your email address will not be published. Required fields are marked *