Selecting multiple cells

Kevin · Aug 4, 2004

I am not allowed to select more than 5 cells while using
the shift key. I was wondering if anyone could help.

JulieD · Aug 4, 2004

Hi Kevin

sounds strange to me .. what happens when you try to select more than 5?
does this happen in all workbooks or only one? what version of excel do you
have?

Cheers
JulieD

Gord Dibben · Aug 4, 2004

Kevin

With the lack of detail in your post, best guess would be that the worksheet
is protected, limiting the range of cells that can be selected.

Go to Tools>Protection and see what's up.

Also visit http://www.cpearson.com/excel/newposte.htm

Gord Dibben Excel MVP