ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   when i pick a cell, it picks cells below also, how do i stop this (https://www.excelbanter.com/excel-worksheet-functions/232638-when-i-pick-cell-picks-cells-below-also-how-do-i-stop.html)

cindu

when i pick a cell, it picks cells below also, how do i stop this
 
I'm using excel 2007
When I pick a cell in my work sheet, it selects 1-4 cells below also.
how do I stop this, it is not merging them and what I enter does not show in
each cell, but is does change some existing contents in the selected cells???

Sheeloo

when i pick a cell, it picks cells below also, how do i stop this
 
Do you see 'Extend Selection' on the status bar at the bottom?

If yes, press F8 once.

"cindu" wrote:

I'm using excel 2007
When I pick a cell in my work sheet, it selects 1-4 cells below also.
how do I stop this, it is not merging them and what I enter does not show in
each cell, but is does change some existing contents in the selected cells???


Gord Dibben

when i pick a cell, it picks cells below also, how do i stop this
 
Change your Zoom setting up or down a % or two.


Gord Dibben MS Excel MVP

On Tue, 2 Jun 2009 11:46:01 -0700, cindu
wrote:

I'm using excel 2007
When I pick a cell in my work sheet, it selects 1-4 cells below also.
how do I stop this, it is not merging them and what I enter does not show in
each cell, but is does change some existing contents in the selected cells???




All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com