Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I delete tabs at one go ?
Hi,
I have 25 tabs in a file ile, 1,2,3,4,5,6€¦.25. Let say if I need only 5 tabs i.e. ta1 to 5 and would like to delete the rest (tab 6 to 25), May I kinow if there is any key board short cut for me to select tab 6 to 25 and delete at one go ? At present I delete one by one by right click delete. Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I delete tabs at one go ?
Sure, just select the first tab, hold down your shift key and select the last
tab, then right-click and delete...all the tabs delete at once. -- Please remember to indicate when the post is answered so others can benefit from it later. "Mr. Low" wrote: Hi, I have 25 tabs in a file ile, 1,2,3,4,5,6€¦.25. Let say if I need only 5 tabs i.e. ta1 to 5 and would like to delete the rest (tab 6 to 25), May I kinow if there is any key board short cut for me to select tab 6 to 25 and delete at one go ? At present I delete one by one by right click delete. Thanks Low -- A36B58K641 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I delete tabs at one go ?
Hi KC,
Thanks for your help. Low -- A36B58K641 "KC" wrote: Sure, just select the first tab, hold down your shift key and select the last tab, then right-click and delete...all the tabs delete at once. -- Please remember to indicate when the post is answered so others can benefit from it later. "Mr. Low" wrote: Hi, I have 25 tabs in a file ile, 1,2,3,4,5,6€¦.25. Let say if I need only 5 tabs i.e. ta1 to 5 and would like to delete the rest (tab 6 to 25), May I kinow if there is any key board short cut for me to select tab 6 to 25 and delete at one go ? At present I delete one by one by right click delete. Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not a novice - can't delete tabs! | Excel Discussion (Misc queries) | |||
2002: Unable to delete Normal_xyz style inherited from workbook(xy | Excel Discussion (Misc queries) | |||
Excel 2002 : Can I speed fill tabs ? | Excel Discussion (Misc queries) | |||
How can I find and delete tabs and carriage returns ? | Excel Discussion (Misc queries) | |||
I cannot delete rows or columns in Excel 2002. How do I fix this? | Setting up and Configuration of Excel |