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? |
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 |