[mso] Re: Quickly select range in Excel 2000?
- From: "Dian Chapman" <dchapman@xxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 20 Nov 2003 10:49:28 -0600
Thanks...but that's a lot to type! It would be faster for me to just click
and drag to that point. I was hoping there might be something faster like
hitting some key to jump into a GoTo box or something (range?) and then
enter the ending value after hitting EXT that will just know I've set on the
block and allow me to only type in the ending value of $x28 or something???
Word can do this! :-P
--------------------------------------------
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
-------------------------------------------
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Greg Chapman
Sent: November 20, 2003 10:43
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Quickly select range in Excel 2000?
This may be close to what you want:
1. Click Edit->GoTo
2. In the Reference textbox, enter $A$1:$x$28
3. Click Okay
There are a variety of ways to select ranges in Excel based, for instance,
on blank cells, cells with constants, etc., by choosing the Special button
on the GoTo dialog.
Greg Chapman
http://www.mousetrax.com
"Counting in binary is as easy as 01, 10, 11!
With thinking this clear, is coding really a good idea?"
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Dian Chapman
> Sent: Thursday, November 20, 2003 10:15 AM
> 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...
>
>
*************************************************************
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:
