How can I select only the active area of a spreadsheet without using the
mouse. Using ctrl+alt+spacebar gives me the entire sheet, which is way too
much, as I only want that portion containing data. Any help accomplishing
this would be GREATLY appreciated!

Hello
ctrl+shift+End

HTH
Cordially
Pascal

"cfspahn24" a écrit dans le message de
news: ...
How can I select only the active area of a spreadsheet without using the
mouse. Using ctrl+alt+spacebar gives me the entire sheet, which is way
too
much, as I only want that portion containing data. Any help accomplishing
this would be GREATLY appreciated!

use ctrl+*
This will select the currently used range.

if you want to select the completely used range go to the first cell in the
range (say A1) and then hit ctrl+shift+end

See if this serves your purpose.



"cfspahn24" wrote:

How can I select only the active area of a spreadsheet without using the
mouse. Using ctrl+alt+spacebar gives me the entire sheet, which is way too
much, as I only want that portion containing data. Any help accomplishing
this would be GREATLY appreciated!

Mano:

I thought cntrh+* was my answer but what happens is it selects all 345 rors
of records but only selects acolumns a thru m, ignoring n thru r, which also
contain data. Your second suggestion select a much too large range. Any
suggestions?

"Manoj" wrote:

use ctrl+*
This will select the currently used range.

if you want to select the completely used range go to the first cell in the
range (say A1) and then hit ctrl+shift+end

See if this serves your purpose.



"cfspahn24" wrote:

How can I select only the active area of a spreadsheet without using the
mouse. Using ctrl+alt+spacebar gives me the entire sheet, which is way too
much, as I only want that portion containing data. Any help accomplishing
this would be GREATLY appreciated!

Another suggestion: If you could identify the last cell in the range (say
R345), select that cell and then hit ctrl+shift+home.

This will select all the cells from A1 to R345.

Does this serve your purpose?

"cfspahn24" wrote:

Mano:

I thought cntrh+* was my answer but what happens is it selects all 345 rors
of records but only selects acolumns a thru m, ignoring n thru r, which also
contain data. Your second suggestion select a much too large range. Any
suggestions?

"Manoj" wrote:

use ctrl+*
This will select the currently used range.

if you want to select the completely used range go to the first cell in the
range (say A1) and then hit ctrl+shift+end

See if this serves your purpose.



"cfspahn24" wrote:

How can I select only the active area of a spreadsheet without using the
mouse. Using ctrl+alt+spacebar gives me the entire sheet, which is way too
much, as I only want that portion containing data. Any help accomplishing
this would be GREATLY appreciated!