keyboard shortcut

We know the keyboard shortcut for selecting the total column (CTRL+spacebar).
once when i was using this, some how it got removed. Can any one of you
helpme how to get the shortcut back. Also share some information about
assigning or removing keyboard shortcuts in excel.

http://www.cpearson.com/excel/ShortCuts.htm

=========
Aditya <Aditya@discussions.microsoft.com> wrote in message
news:2A4D5108-25D5-425D-A425-749D79FDF20E@microsoft.com...
> We know the keyboard shortcut for selecting the total column
(CTRL+spacebar).
> once when i was using this, some how it got removed. Can any one of you
> helpme how to get the shortcut back. Also share some information about
> assigning or removing keyboard shortcuts in excel.

Hi Aditya,

One of the most popular reasons for shortcuts not working in MS-Excel is their assignment to a macro. Jut go thru the following steps:

Go to Tools Menu ---> Macro----> Click on Macros

Check you assigned Ctrl+Spacebar to any of the macros. If so, delete the macro and you will be back with the same shortcut for select column.

Let me know if you need anything else in this regard.

Thanks,
Nagesh.

Aditya We know the keyboard shortcut for selecting the total column (CTRL+spacebar).
once when i was using this, some how it got removed. Can any one of you
helpme how to get the shortcut back. Also share some information about
assigning or removing keyboard shortcuts in excel.