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 wrote:

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