[mso] Re: Quickly select range in Excel 2000?
- From: Robert Carneal <bookofficeworker@xxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 20 Nov 2003 13:45:36 -0600
that works, goto X28, hold down the Shift key, and press Home-Page Up.
Robert
At 10:49 AM 11/20/2003, you wrote:
>Hi Dian,
>
> > Can I just hit some
> > keys to cause it to select all the way from A1 to X28?
>
>My quickest way is backwards... literally :-)
>
>1) Go to X28 by typing X28 in the drop down on the far left at the top
>of the sheet... that is overtype the A1 with X28 and press return.
>
>2) Press Ctrl+Shift+Home.
>
>Same thing works for a block but don't hold down the Ctrl key.
>
>1) Type C3 in the drop down and press return
>2) Type X28 in the drop down *then* shift and press return.
>
>... will select C3 to X28.
>
>Same thing with the END key.
>
>1) Go to a cell by typing in the drop down and pressing return.
>2) Press End
>3) Hold down the shift key and press an arrow key to go to the END of
>that range.
>
>ere the end of the range is the first empty cell along that row or up
>or down the column.
>
>The key... pun not intended... is to hold the shift key when you move
>around.
>
>Ctrl Hhome goes to the top same as all the other applications
>Home goes to the begining of the row.
>Page up and down are page up and down... suprise!!
>... etc
>
>I think that backwards trick is nice though... and I've used it in
>otther programs as well.
>
>HTH
>
>Regards
>Lisa
>
>
> > -----Original Message-----
> > From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
> > Behalf Of Dian Chapman
> > Sent: 20 November 2003 17:15
> > To: Mso
> > Subject: [mso] Quickly select range in Excel 2000?
> >
> >
> >
> > Hi folks...
> >
> > She's at it again with Excel!<g>
> >
> > There MUST be a keyboard way to more easily select a range
> > of text, versus
> > always having to use the mouse to try to scroll/drag around
> > to select an
> > area...anyone know for sure and how? I'm in Excel 2000.
> >
> > What I mean is...say I open a sheet and default into A1.
> > Can I just hit some
> > keys to cause it to select all the way from A1 to X28?
> >
> > I know F8 is the ExtendSelection key...to turn on
> > "blocking" (Selection) in
> > Word and I see that is the same in Excel. So in Word, I can
> > hit say a
> > question mark or some other keys...and then move to that
> > location to select
> > the area in question...like the period twice to go to the
> > second period,
> > etc.
> >
> > I assume there's some way to turn on EXT and hit some keys to GoTo a
> > specific cell and thereby select all that area so I can
> > then just hit Ctrl/C
> > to copy blah, blah, blah.
> >
> > TIA...
> >
> > --------------------------------------------
> > Dian D. Chapman
> > US Microdyne
> > 2275 Half Day Road
> > Suite 350
> > Bannockburn, IL 60015
> > E-Mail: DChapman@xxxxxxxxxxxxxxx
> > Toll-Free: 800-828-3859
> > Phone: 847-244-4800
> > Fax: 847-244-4801
> > -------------------------------------------
> >
> >
> > *************************************************************
> > 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).
> > //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
> > *************************************************************
>
>*************************************************************
>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).
>//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
>*************************************************************
*************************************************************
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).
//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:
