More than one cell is selected when I left click. Why?
I have an Excel 2007 worksheet. When I left click on a cell, instead of that
cell having a box around it, the selection box is around that cell and 5 others under it. And when I try to select a row, that row and five below it are selected. How do I fix this? |
More than one cell is selected when I left click. Why?
I'm betting that you have merged some cells. This gives the appearance of a
giant cell. Rightclick on that cell Format|cells|alignment tab|uncheck merge (select all the cells on the worksheet first to get get rid of all these merged cells) womusic wrote: I have an Excel 2007 worksheet. When I left click on a cell, instead of that cell having a box around it, the selection box is around that cell and 5 others under it. And when I try to select a row, that row and five below it are selected. How do I fix this? -- Dave Peterson |
More than one cell is selected when I left click. Why?
Thanks for the info. I went back in to try it but it's not doing it anymore.
Strange. Thank you anyway though. "Dave Peterson" wrote: I'm betting that you have merged some cells. This gives the appearance of a giant cell. Rightclick on that cell Format|cells|alignment tab|uncheck merge (select all the cells on the worksheet first to get get rid of all these merged cells) womusic wrote: I have an Excel 2007 worksheet. When I left click on a cell, instead of that cell having a box around it, the selection box is around that cell and 5 others under it. And when I try to select a row, that row and five below it are selected. How do I fix this? -- Dave Peterson |
More than one cell is selected when I left click. Why?
Excel makes it possible to extend a selection. You can toggle this by hitting
the F8 key (it's a toggle key). Maybe you were in extend mode when you had your earlier trouble. womusic wrote: Thanks for the info. I went back in to try it but it's not doing it anymore. Strange. Thank you anyway though. "Dave Peterson" wrote: I'm betting that you have merged some cells. This gives the appearance of a giant cell. Rightclick on that cell Format|cells|alignment tab|uncheck merge (select all the cells on the worksheet first to get get rid of all these merged cells) womusic wrote: I have an Excel 2007 worksheet. When I left click on a cell, instead of that cell having a box around it, the selection box is around that cell and 5 others under it. And when I try to select a row, that row and five below it are selected. How do I fix this? -- Dave Peterson -- Dave Peterson |
More than one cell is selected when I left click. Why?
ME 2,
and it's driving me mad I say, though I am not a new user, this thread was the only place I found the problem addressed and F8 nor merged cells are the problem ....or solution "womusic" wrote: I have an Excel 2007 worksheet. When I left click on a cell, instead of that cell having a box around it, the selection box is around that cell and 5 others under it. And when I try to select a row, that row and five below it are selected. How do I fix this? |
More than one cell is selected when I left click. Why?
By the way I've found this only happens in the page layout view
"Just_Mike" wrote: ME 2, and it's driving me mad I say, though I am not a new user, this thread was the only place I found the problem addressed and F8 nor merged cells are the problem ....or solution "womusic" wrote: I have an Excel 2007 worksheet. When I left click on a cell, instead of that cell having a box around it, the selection box is around that cell and 5 others under it. And when I try to select a row, that row and five below it are selected. How do I fix this? |
More than one cell is selected when I left click. Why?
Make small changes to the Zoom factor and see if the problem goes away.
Gord Dibben MS Excel MVP On Mon, 11 May 2009 09:34:08 -0700, Just_Mike wrote: By the way I've found this only happens in the page layout view "Just_Mike" wrote: ME 2, and it's driving me mad I say, though I am not a new user, this thread was the only place I found the problem addressed and F8 nor merged cells are the problem ....or solution "womusic" wrote: I have an Excel 2007 worksheet. When I left click on a cell, instead of that cell having a box around it, the selection box is around that cell and 5 others under it. And when I try to select a row, that row and five below it are selected. How do I fix this? |
All times are GMT +1. The time now is 05:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com