Paste formulas/functions throughout workbook Excel

  mammak 17:13 15 Mar 06
Locked

I have created a Spreadsheet in Excel 2000, which is eventually going to be used as a template but obviously need to keep the functions/formulas in place I know this will
be so easy but I can't for the life of me remember how to do it the workbook has 12 worksheets January through to December would I need to link the worksheets first?
I would imagine I would have to use paste special for the formulas/functions but the problem is I have forgotten the procedure lol any help would be appreciated.
mammak

  VoG II 17:30 15 Mar 06

You only need to link the worksheets if you want them all to update together.

If you just want to copy from January to the other 11 months, then:

Select the January sheet tab.

Select the entire worksheet by clicking the grey square between A and 1 (column and row headings).

Click the Copy toolbar button.

Click the February sheet tab. Hold down Shift and click the December sheet tab.

Click the Paste toolbar button.

Voila!

  mammak 17:37 15 Mar 06

Cheers VoG™ heres my thinking it wouldnt be as simple as a normal copy and paste,
do I feel like a fool or what lol thanks mammak.

  mammak 17:39 15 Mar 06

Sorted

This thread is now locked and can not be replied to.

What is ransomware and how do I protect my PC from WannaCry?

Disney layout supervisor Rob Dressel on the challenges of visualising Moana

Siri vs Google Assistant