Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 57
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not a novice - can't delete tabs! Sherri Excel Discussion (Misc queries) 1 April 9th 09 02:36 PM
2002: Unable to delete Normal_xyz style inherited from workbook(xy Martti Pekkanen Excel Discussion (Misc queries) 1 November 5th 07 08:15 AM
Excel 2002 : Can I speed fill tabs ? Mr. Low Excel Discussion (Misc queries) 4 September 11th 07 05:56 PM
How can I find and delete tabs and carriage returns ? JeffEE Excel Discussion (Misc queries) 1 November 11th 05 02:47 PM
I cannot delete rows or columns in Excel 2002. How do I fix this? tgs77m Setting up and Configuration of Excel 3 July 12th 05 08:04 PM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"