Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Office XP - Excel
I have constructed a worksheet (20,000 cells) and wish to copy the formulae
(but not the entries) into a new worksheet in the same workbook. How can I do this? Secondly, I then wish to change some of the formulae referring to the month of March (MAR_05) to April (APR_05) so that the totals from the previous months' workshhet can be brough forward to the new (April) worksheet. Rather that do this on a cell by cell basis (about 90 cells) is there a way to do this in one move? |
#2
|
|||
|
|||
Eric
1) Go to EditGo to...Special... Constants and then click OK. Then press delete key and all 'constants' will be gone. (If you have headers copy these off somewhere and then paste them back. If they are the only text, you can exclude text from the list below 'Formulas') 2) EditReplace...'Look in' Formulas and type your Replace What:= xxxxx With:= xxxxx -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Eric M" <Eric wrote in message ... I have constructed a worksheet (20,000 cells) and wish to copy the formulae (but not the entries) into a new worksheet in the same workbook. How can I do this? Secondly, I then wish to change some of the formulae referring to the month of March (MAR_05) to April (APR_05) so that the totals from the previous months' workshhet can be brough forward to the new (April) worksheet. Rather that do this on a cell by cell basis (about 90 cells) is there a way to do this in one move? |
#3
|
|||
|
|||
Hi Eric
Mark the whole page by clicking on the small grey square above the row number and to the left of column A. Copy Paste Special=Formulae Then, carry out a Find and Replace for "MAR_05" replace with "APR_05" -- Regards Roger Govier "Eric M" <Eric wrote in message ... I have constructed a worksheet (20,000 cells) and wish to copy the formulae (but not the entries) into a new worksheet in the same workbook. How can I do this? Secondly, I then wish to change some of the formulae referring to the month of March (MAR_05) to April (APR_05) so that the totals from the previous months' workshhet can be brough forward to the new (April) worksheet. Rather that do this on a cell by cell basis (about 90 cells) is there a way to do this in one move? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ms office professional 2003 - Excel | Excel Discussion (Misc queries) | |||
Need Office with Excel for windows 98 | Excel Discussion (Misc queries) | |||
Reinstall Excel 2002 after removing it during upgrade to Office 20 | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |