|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
11-19-2007
| #1 (permalink) |
| | Excel 2007 As a treasurer for a church I use a large spreadsheet to keep my accounts for each year. At the end of the year I start a new spreadsheet. Is there a quick way of removing all the figures from the spreadsheet, and just leaving the formula? Usually I copy the spreadsheet at the end of the year, then I have to slowly go throught the spreadsheet and remove all the credits and debits. Surley there is a quicker way? -- John McGoldrick |
My System Specs |
|
11-19-2007
| #2 (permalink) |
| | Re: Excel 2007 johnmcg wrote: Quote: > As a treasurer for a church I use a large spreadsheet to keep my accounts for > each year. At the end of the year I start a new spreadsheet. Is there a quick > way of removing all the figures from the spreadsheet, and just leaving the > formula? > Usually I copy the spreadsheet at the end of the year, then I have to slowly > go throught the spreadsheet and remove all the credits and debits. > Surley there is a quicker way? Excel, post in its newsgroup, microsoft.public.excel. Malke -- Elephant Boy Computers www.elephantboycomputers.com "Don't Panic!" MS-MVP Windows - Shell/User |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| EXCEL 2007 INSTALLATION | .NET General | |||
| MS Excel 2007 | Vista mail | |||
| Excel 2007 [Vista OS] | Vista General | |||
| Excel 2007 | Vista installation & setup | |||
| Excel 2007 wil not open and Excel 2007 document in Vista? | Vista General | |||
