CTRL+A for Select All giving error

[NR]

Hi,

I am getting error while using CTRL+A for selecting all the cells. The
header of the error reads "resize array formula" and the error message is "no
formula in active cell". This happens with all sheets I have and also for the
new sheet.

Thanks in advance for the help.

 

[Dave Peterson]

First, are you using ctrl-a or ctrl-A (lowercase or uppercase A)?

Second, are you in edit mode (changing a formula) when you hit ctrl-a/A?

If you're using ctrl-A (uppercase), then try lowercase a.

If you're editing a formula, then finish the edit and try ctrl-a.

If you're not in edit mode and you're using ctrl-a, I'd try this:

Start excel in safe mode.
Close excel
windows start button
excel /safe

Then test the ctrl-a

If that works, then maybe you have a "helpful" macro that's taken over that key.

If it is a macro that's stealing the function, you'll have to do some detective
work.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

 

[NR]

I am using ctrl-a and not in edit mode. There is no macro in the workbook.
However, opening the excel in safe mode, made ctrl-a working fine but I am
not sure why is that happening as there is no macro in the workbook.

Regards,
Nishant

 

[Dave Peterson]

There can be macros in other workbooks, too.

Take a look at those debugging sites.