[mso] Re: Excel REPEAT key?

<< 2) When adding new sheets. What if I want to add say, 4 new
worksheets...rather than clicking Insert > Worksheet...is there an easier
way?>>

The easiest way is to click on one sheet tab, then shift click on another
tab 4 tabs over, so you have four selected BEFORE you go to
Insert>Worksheet....then when you Insert, it will insert four of them at
once...whatever number of sheets you have selected, that's how many will be
inserted

It works the same way will columns and rows...if you want to insert four of
them instead on one at a time, just select four columns or rows before you
insert them...it will insert the same number as you have selected.


Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV.  If you got a bug that looks like
it came from me, it did NOT!

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Dian Chapman
Sent: Thursday, February 26, 2004 10:50 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel REPEAT key?

Does Excel have a repeat key like Word? 

There are a few times when I do something that I'd like to do again without
having to manually do it over and over. 

1) In a pivot table, sometimes I select an item and move it up/down in the
table. The only way I know to move it up several positions is to continually
right click and click move up. Is there an easier way?

2) When adding new sheets. What if I want to add say, 4 new
worksheets...rather than clicking Insert > Worksheet...is there an easier
way?

TIA...

Dian D. Chapman


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: