Selecting active area of sheet

[Guest]

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!

 

[papou]

Hello
ctrl+shift+End

HTH
Cordially
Pascal

 

[Guest]

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.

 

[Guest]

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?

 

[Guest]

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?