I agree with statement

Maybe:
Select A1 and hit ctrl-a twice
it may be overkill, but it always(?) works.

The rest of it is a mystery and I'm glad it was you and not myself doing all
that experimenting.

Gord

On Fri, 30 Sep 2005 15:57:32 -0500, Dave Peterson
wrote:

I think it's more of what makes up that current region. If the current region
is less than 2 cells, then all the cells are selected.

I put something in A1:L40, but cleared c11:I25 (just at random).

I selected D17 (empty with empty cells surrounding it)--ctrl-A selected the
whole sheet.

I put something in D17 and with just d17 selected, I hit ctrl-A. I got the
whole sheet.

D17:D18 had data, I got that current region with D17 selected and then ctrl-A.

=====
Now the fun part!

I put something in D17 (still surrounded by empty cells). I selected D17:D18
(d17 the active cell) and hit ctrl-A. I got all the cells.

I selected D16:D17 (d16 active and empty and d17 non-empty). I hit ctrl-a and
the selection never changed.

=====
So this screws up my warning!

I don't like describing the "button" at the top of the row headers and to the
left of the column headers--it's just too many words.

Maybe:
Select A1 and hit ctrl-a twice
it may be overkill, but it always(?) works.

(Ish!)

Gord Dibben wrote:

Dave

Something I'd like to note. Maybe old news but.........

If the active cell is outside the used range, CTRL + a(once) selects all cells
in sheet.

If inside the used range CTRL + a selects the used range only and CTRL +
a(twice) selects all cells on sheet.

Gord

On Fri, 30 Sep 2005 07:34:51 -0500, Dave Peterson
wrote:

Select all the cells (ctrl-a (twice in xl2003))
format|Cells|Protection tab|uncheck locked