42. Excel Tips - Deleting Sheets
Easy tip today... it's about how to delete sheets.
To delete a worksheet:
If you have selected the worksheet, press in sequence: ALT the e then l
- If there is data on the sheet, you will be asked to confirm that you want to delete the sheet.
- If no data, the sheet is deleted immediately.
- To delete multiple sheets, select them one by one whilst holding down the CTRL key.
- Note - you must leave at least one sheet undeleted, so if you want to delete all the sheets, insert a dummy sheet, then proceed as before.
Video Training on Deleting Sheets:
»
- Nick's blog
- Login or register to post comments
- 6382 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago