Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default error selecting cells -excel 2007

in excel 2007
when i'm in page layout view, there are certain cells that when i click on
them, multiple cells become selected-- 3 or 4 at a time. they are NOT
merged. other times, when i click on the same cells, only one cell is
selected.

when i'm in normal view, clicking on these same cells, only single cells
select as clicked on as they should.

any ideas?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default error selecting cells -excel 2007

Hi,

Is it possible that you are clicking in the Header or Footer area of Page
Layout? There really are no cells there, those are the Left, Center and
Right headers and footers.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"cathyh" wrote:

in excel 2007
when i'm in page layout view, there are certain cells that when i click on
them, multiple cells become selected-- 3 or 4 at a time. they are NOT
merged. other times, when i click on the same cells, only one cell is
selected.

when i'm in normal view, clicking on these same cells, only single cells
select as clicked on as they should.

any ideas?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default error selecting cells -excel 2007

no - not in the header/footer area.

"Shane Devenshire" wrote:

Hi,

Is it possible that you are clicking in the Header or Footer area of Page
Layout? There really are no cells there, those are the Left, Center and
Right headers and footers.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"cathyh" wrote:

in excel 2007
when i'm in page layout view, there are certain cells that when i click on
them, multiple cells become selected-- 3 or 4 at a time. they are NOT
merged. other times, when i click on the same cells, only one cell is
selected.

when i'm in normal view, clicking on these same cells, only single cells
select as clicked on as they should.

any ideas?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default error selecting cells -excel 2007

This is a bug in Excel 2007 when in page layout view.

Try changing the Zoom level slightly up or down a couple of percent.


Gord Dibben MS Excel MVP

On Thu, 18 Jun 2009 20:06:01 -0700, cathyh
wrote:

in excel 2007
when i'm in page layout view, there are certain cells that when i click on
them, multiple cells become selected-- 3 or 4 at a time. they are NOT
merged. other times, when i click on the same cells, only one cell is
selected.

when i'm in normal view, clicking on these same cells, only single cells
select as clicked on as they should.

any ideas?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default error selecting cells -excel 2007

This fixed it for me.

"Gord Dibben" wrote:

This is a bug in Excel 2007 when in page layout view.

Try changing the Zoom level slightly up or down a couple of percent.


Gord Dibben MS Excel MVP

On Thu, 18 Jun 2009 20:06:01 -0700, cathyh
wrote:

in excel 2007
when i'm in page layout view, there are certain cells that when i click on
them, multiple cells become selected-- 3 or 4 at a time. they are NOT
merged. other times, when i click on the same cells, only one cell is
selected.

when i'm in normal view, clicking on these same cells, only single cells
select as clicked on as they should.

any ideas?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting non consectutive cells/rows/columns in excel 2007 PammyBB Excel Discussion (Misc queries) 3 March 26th 09 04:34 PM
selecting multiple cells in Excel 2007 cjb22 Excel Discussion (Misc queries) 20 November 11th 08 05:35 PM
MS Excel 2007 highlights multiple cells when selecting single cell biz_kid1 Excel Discussion (Misc queries) 5 September 14th 08 06:42 PM
Excel 2007 - change shading when selecting groups of cells [email protected] Excel Discussion (Misc queries) 1 April 7th 08 03:58 AM
Selecting In Excel 2007 Mary Fetsch Excel Discussion (Misc queries) 0 October 22nd 07 02:40 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"