Selecting multiple rows selects entire page

E

Ed Gross

I have a user who brought me a problem I've never seen before. She's
trying to select a couple rows by click-draging on the row numbers.
When she lets go of the left mouse button, the entire page is
selected. It doesn't affect the other spreadsheets she has, so it has
to be something someone did to this specific sheet, but I can't find
anything.

Any Ideas?

Thanks,
Ed Gross
Network Admin
TJ Hale Co.
 
R

Richard O. Neville

To select two rows, other methods can be used: (1) click on the number for
row 10, then hold down the shift key and click on row 11; (2) click on row
10, then hold down the Ctrl key and click on row 15 (or any non-contiguous
row or rows). See if this will work around the problem.
 
G

Gord Dibben

Ed

Right-click on the sheet tab and "View Code".

Anything in there that may be affecting the sheet?

Gord Dibben Excel MVP
 
Top