| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 78256 | 2007-04-09 09:13:00 | Excel | Happy Harry (321) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 539309 | 2007-04-09 09:13:00 | Happy Easter one and all. I have an Excel workbook consisting of 13 sheets. 12 for the months of the year and a summary page. Can anyone tell me how to delete the contents of the complete workbook(13 sheets) without touching the formulas, formattting or layout. It has taken the best part of the year to evolve this spreadsheet to how it is now and I don't have a blank copy to use for the upcoming years. Thanks in advance. Cheers HH |
Happy Harry (321) | ||
| 539310 | 2007-04-09 10:06:00 | One way would be to use Excel's F5 command. Select all the cells, in the range that you wish to delete, on a particular spreadsheet then hit the F5 key Select the Special button and select the Constants option (2nd on the left for Office XP) - hit the OK button and you should be returned to the excel sheet with only the data cells selected. Now you should be able to hit the delete key and the data entries should be deleted with the formulas left intact. |
TeejayR (4271) | ||
| 539311 | 2007-04-09 20:59:00 | If all the sheets are identical in layout, use the Group Edit feature, where you select all the sheets using Shift - click on the first and last tab. Then edit the displayed sheet and all the same cells in the group selected ones are edited in the same manner. Do not forget to unselect before resuming entering data. |
godfather (25) | ||
| 539312 | 2007-04-10 05:09:00 | Thanks guys Gleaned some information out of both replies and acheived the objective. Thanks for the advice. HH |
Happy Harry (321) | ||
| 1 | |||||