Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 13th 06, 06:29 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3
Default Select All missing, Ctrl-A not working (Excel 2003 SP2)

The Edit menu does not contain a Select All item.
Using Ctrl-A does not Select All, if there is an area to select. For
Example consider range (A1:A8) with data in each cell except for A3 and A6.

A1
A2

A4
A5

A7
A8

Placing the cursor on A5 and typing Ctrl-A only selects cells A4 and A5.


This is on each computer running Excel 2003 SP2 that I have tested. Is
Microsoft getting rid of Ctrl-A and Select All? Help still references
Ctrl-A.



  #2   Report Post  
Old September 13th 06, 07:44 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Select All missing, Ctrl-A not working (Excel 2003 SP2)

Keep on hitting ctrl-a as many times as you need (you won't need more than 3,
IIRC).

ctrl-a's behavior changed depending on what was selected and what was in
surrounding cells.



JimO wrote:

The Edit menu does not contain a Select All item.
Using Ctrl-A does not Select All, if there is an area to select. For
Example consider range (A1:A8) with data in each cell except for A3 and A6.

A1
A2

A4
A5

A7
A8

Placing the cursor on A5 and typing Ctrl-A only selects cells A4 and A5.

This is on each computer running Excel 2003 SP2 that I have tested. Is
Microsoft getting rid of Ctrl-A and Select All? Help still references
Ctrl-A.


--

Dave Peterson
  #3   Report Post  
Old September 13th 06, 08:29 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3
Default Select All missing, Ctrl-A not working (Excel 2003 SP2)

I selected A5 then typed Ctrl-A. It selected A4 and A5.

Ctrl-A was then typed an additional ten times with the outcome that A4 and
A5 are still selected.

So, any ideas why Microsoft changed the behavior? Even help says it selects
the entire worksheet.


"Dave Peterson" wrote in message
...
Keep on hitting ctrl-a as many times as you need (you won't need more than
3,
IIRC).

ctrl-a's behavior changed depending on what was selected and what was in
surrounding cells.



JimO wrote:

The Edit menu does not contain a Select All item.
Using Ctrl-A does not Select All, if there is an area to select. For
Example consider range (A1:A8) with data in each cell except for A3 and
A6.

A1
A2

A4
A5

A7
A8

Placing the cursor on A5 and typing Ctrl-A only selects cells A4 and A5.

This is on each computer running Excel 2003 SP2 that I have tested. Is
Microsoft getting rid of Ctrl-A and Select All? Help still references
Ctrl-A.


--

Dave Peterson



  #4   Report Post  
Old September 13th 06, 09:53 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Select All missing, Ctrl-A not working (Excel 2003 SP2)

I put something in A4:A6 (and the rest of the worksheet was empty)
I selected A5 and hit ctrl-a, and A4:A6 was selected.
I hit ctrl-a again and all the cells were selected.

I'm not sure what the layout of your data would be to never select the all the
cells.

Well, if your worksheet is protected and the developer (you???) specified that
either unlocked cells (or locked cells) couldn't be selected, then you wouldn't
be able to select all the cells. Any chance of that?

And I have no idea why MS does anything. I'm sure they did usability studies
that found that those in the study needed this new behavior (whether they wanted
it or not!).



JimO wrote:

I selected A5 then typed Ctrl-A. It selected A4 and A5.

Ctrl-A was then typed an additional ten times with the outcome that A4 and
A5 are still selected.

So, any ideas why Microsoft changed the behavior? Even help says it selects
the entire worksheet.

"Dave Peterson" wrote in message
...
Keep on hitting ctrl-a as many times as you need (you won't need more than
3,
IIRC).

ctrl-a's behavior changed depending on what was selected and what was in
surrounding cells.



JimO wrote:

The Edit menu does not contain a Select All item.
Using Ctrl-A does not Select All, if there is an area to select. For
Example consider range (A1:A8) with data in each cell except for A3 and
A6.

A1
A2

A4
A5

A7
A8

Placing the cursor on A5 and typing Ctrl-A only selects cells A4 and A5.

This is on each computer running Excel 2003 SP2 that I have tested. Is
Microsoft getting rid of Ctrl-A and Select All? Help still references
Ctrl-A.


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Old September 20th 06, 06:51 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3
Default Select All missing, Ctrl-A not working (Excel 2003 SP2)

LOL! you sound like me with your jokes.

Strange, data was entered as you entered it and the second Ctrl-A worked.
So, I entered the data the way it was originally entered and, uh, the second
Ctrl-A worked.

Strange. Something has been reset and since the system is always
"adjusting" our system for our benefit it must have fixed what was
apparently broke.

Thanks.




"Dave Peterson" wrote in message
...
I put something in A4:A6 (and the rest of the worksheet was empty)
I selected A5 and hit ctrl-a, and A4:A6 was selected.
I hit ctrl-a again and all the cells were selected.

I'm not sure what the layout of your data would be to never select the all
the
cells.

Well, if your worksheet is protected and the developer (you???) specified
that
either unlocked cells (or locked cells) couldn't be selected, then you
wouldn't
be able to select all the cells. Any chance of that?

And I have no idea why MS does anything. I'm sure they did usability
studies
that found that those in the study needed this new behavior (whether they
wanted
it or not!).



JimO wrote:

I selected A5 then typed Ctrl-A. It selected A4 and A5.

Ctrl-A was then typed an additional ten times with the outcome that A4
and
A5 are still selected.

So, any ideas why Microsoft changed the behavior? Even help says it
selects
the entire worksheet.

"Dave Peterson" wrote in message
...
Keep on hitting ctrl-a as many times as you need (you won't need more
than
3,
IIRC).

ctrl-a's behavior changed depending on what was selected and what was
in
surrounding cells.



JimO wrote:

The Edit menu does not contain a Select All item.
Using Ctrl-A does not Select All, if there is an area to select. For
Example consider range (A1:A8) with data in each cell except for A3
and
A6.

A1
A2

A4
A5

A7
A8

Placing the cursor on A5 and typing Ctrl-A only selects cells A4 and
A5.

This is on each computer running Excel 2003 SP2 that I have tested.
Is
Microsoft getting rid of Ctrl-A and Select All? Help still references
Ctrl-A.

--

Dave Peterson


--

Dave Peterson





  #6   Report Post  
Old September 20th 06, 07:44 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Select All missing, Ctrl-A not working (Excel 2003 SP2)

Do what you have to do now--while the pc is working!

JimO wrote:

LOL! you sound like me with your jokes.

Strange, data was entered as you entered it and the second Ctrl-A worked.
So, I entered the data the way it was originally entered and, uh, the second
Ctrl-A worked.

Strange. Something has been reset and since the system is always
"adjusting" our system for our benefit it must have fixed what was
apparently broke.

Thanks.

"Dave Peterson" wrote in message
...
I put something in A4:A6 (and the rest of the worksheet was empty)
I selected A5 and hit ctrl-a, and A4:A6 was selected.
I hit ctrl-a again and all the cells were selected.

I'm not sure what the layout of your data would be to never select the all
the
cells.

Well, if your worksheet is protected and the developer (you???) specified
that
either unlocked cells (or locked cells) couldn't be selected, then you
wouldn't
be able to select all the cells. Any chance of that?

And I have no idea why MS does anything. I'm sure they did usability
studies
that found that those in the study needed this new behavior (whether they
wanted
it or not!).



JimO wrote:

I selected A5 then typed Ctrl-A. It selected A4 and A5.

Ctrl-A was then typed an additional ten times with the outcome that A4
and
A5 are still selected.

So, any ideas why Microsoft changed the behavior? Even help says it
selects
the entire worksheet.

"Dave Peterson" wrote in message
...
Keep on hitting ctrl-a as many times as you need (you won't need more
than
3,
IIRC).

ctrl-a's behavior changed depending on what was selected and what was
in
surrounding cells.



JimO wrote:

The Edit menu does not contain a Select All item.
Using Ctrl-A does not Select All, if there is an area to select. For
Example consider range (A1:A8) with data in each cell except for A3
and
A6.

A1
A2

A4
A5

A7
A8

Placing the cursor on A5 and typing Ctrl-A only selects cells A4 and
A5.

This is on each computer running Excel 2003 SP2 that I have tested.
Is
Microsoft getting rid of Ctrl-A and Select All? Help still references
Ctrl-A.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #7   Report Post  
Old September 25th 06, 01:54 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 903
Default Select All missing, Ctrl-A not working (Excel 2003 SP2)

You can find a macro to make Ctrl+A work properly, but it just
puts off the inevitable destruction of your entire workbook when
you use Ctrl+A and have macros turned off or don't have the
macro available in the workbook. see
http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar

And as Dave Peterson indicated there are situations where
you will have to hit Ctrl+A more than twice to get it to do what it
should be doing with a single invocation of Ctrl+A.

You would think that Ctrl+A like Ctrl+C, Ctrl+X, Ctrl+V, Ctrl+Z
and also commonly used Ctrl+F, Ctr+H, and Ctrl+Y would never be
violated and if someone did mess up any of them
it would never make it into a public version but obviously that would be
an incorrect assumption. Note all but one of the most common shortcuts
are used with the left hand, while the right hand can be on the keyboard or
on the mouse. The exception is Ctrl+H but I probably invoke that with my
left hand as often as with both hands.

There is NO comparable shortcut for Ctrl+A
the gray select All key does not work the same (changes the active cell)
Ctrl+Shift+SpaceBar will also fail in later versions.

And it is correct to say not working properly because Ctrl+A
means one thing in all applications where selecting everything
makes sense because it is so embedded in things, even
before Windows.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave Peterson" wrote in message ...
Do what you have to do now--while the pc is working!

JimO wrote:

LOL! you sound like me with your jokes.

Strange, data was entered as you entered it and the second Ctrl-A worked.
So, I entered the data the way it was originally entered and, uh, the second
Ctrl-A worked.

Strange. Something has been reset and since the system is always
"adjusting" our system for our benefit it must have fixed what was
apparently broke.

Thanks.

"Dave Peterson" wrote in message
...
I put something in A4:A6 (and the rest of the worksheet was empty)
I selected A5 and hit ctrl-a, and A4:A6 was selected.
I hit ctrl-a again and all the cells were selected.

I'm not sure what the layout of your data would be to never select the all
the
cells.

Well, if your worksheet is protected and the developer (you???) specified
that
either unlocked cells (or locked cells) couldn't be selected, then you
wouldn't
be able to select all the cells. Any chance of that?

And I have no idea why MS does anything. I'm sure they did usability
studies
that found that those in the study needed this new behavior (whether they
wanted
it or not!).



JimO wrote:

I selected A5 then typed Ctrl-A. It selected A4 and A5.

Ctrl-A was then typed an additional ten times with the outcome that A4
and
A5 are still selected.

So, any ideas why Microsoft changed the behavior? Even help says it
selects
the entire worksheet.

"Dave Peterson" wrote in message
...
Keep on hitting ctrl-a as many times as you need (you won't need more
than
3,
IIRC).

ctrl-a's behavior changed depending on what was selected and what was
in
surrounding cells.



JimO wrote:

The Edit menu does not contain a Select All item.
Using Ctrl-A does not Select All, if there is an area to select. For
Example consider range (A1:A8) with data in each cell except for A3
and
A6.

A1
A2

A4
A5

A7
A8

Placing the cursor on A5 and typing Ctrl-A only selects cells A4 and
A5.

This is on each computer running Excel 2003 SP2 that I have tested.
Is
Microsoft getting rid of Ctrl-A and Select All? Help still references
Ctrl-A.

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Working with sheets in Excel 2003 Americo Excel Worksheet Functions 1 July 15th 06 03:48 PM
In Excel 2003, under the File menu the Permission link is missing dlrvh1984 Excel Worksheet Functions 2 September 21st 05 03:56 PM
Excell VS Office Cathyandrea Excel Discussion (Misc queries) 1 September 19th 05 07:02 AM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
quattro pro converter Excel 2003 dr88363 New Users to Excel 0 February 27th 05 06:00 PM


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017