CTRL+Left-Click for Copying Non-Adjacent Cells Not Working

[mikedhmsu]

I just received a new factory-imaged HDD with Windows Vista Home Premium and
installed my copy of MS Office Professional 2007.

Upon working with a one of my Excel files, I wanted to select a number of
non-adjacent cells to format identically. However, after I right-clicked and
applied preferred formatting, it was only applied to the last set of cells
selected.

Performing this action again -- while holding down CTRL and selecting the
data -- Excel would only recognize the most recent set of cells and not the
total number of cells. But, if I selected one set of cells, press the CTRL
key and select the next set and continue this process (let go of CTRL and
depress again prior to selecting the next set of cells) everything works
fine.

This is not "normal" functioning of Excel as my system at the office works
as expected -- to select non-adjacent cells you keep the CTRL depressed.

Does anyone have suggestions on how to correct this issue?

 

[Simon Lloyd]

You might have the EXT set, take a look here 'Microsoft office help an
blog for Excel, Access, Powerpoint...etc, tips and tricks eve
tutorials.
(http://www.thecodecage.com/blog/2009/06/excel-keyboard-shortcuts/) s
you can see which key combination you may have hit to affect it

I just received a new factory-imaged HDD with Windows Vista Home Premiu
an
installed my copy of MS Office Professional 2007

Upon working with a one of my Excel files, I wanted to select a numbe
o
non-adjacent cells to format identically. However, after
right-clicked an
applied preferred formatting, it was only applied to the last set o
cell
selected

Performing this action again -- while holding down CTRL and selectin
th
data -- Excel would only recognize the most recent set of cells and no
th
total number of cells. But, if I selected one set of cells, press th
CTR
key and select the next set and continue this process (let go of CTR
an
depress again prior to selecting the next set of cells) everythin
work
fine

This is not "normal" functioning of Excel as my system at the offic
work
as expected -- to select non-adjacent cells you keep the CTR
depressed

Does anyone have suggestions on how to correct this issue

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[mikedhmsu]

Thank you! I know of the more common keyboard tips but it was SHIFT+F8 that
did the trick! Just not sure how to make it the default setting.

 

[Simon Lloyd]

It should be an on/off thing, if you have turned it off and saved th
workbook it should be that way in subsequent workbooks

Thank you! I know of the more common keyboard tips but it was SHIFT+F
tha
did the trick! Just not sure how to make it the default setting



tips and tricks even tutorials.
(http://www.thecodecage.com/blog/2009/06/excel-keyboard-shortcuts/)) s


Microsoft Office Discussion' (http://www.thecodecage.com)

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[mhoffa]

It should be an on/off thing, if you have turned it off and saved the
workbook it should be that way in subsequent workbooks.

mikedhmsu;454703 Wrote:





--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)

Hi again...

This fix is not permanent. I am still having the same issue and it's
very frustrating. As of now, I am thinking this issue is caused by a
patch of some sort. Does anyone else have this issue?

I even tried uninstalling and re-install Office 2007 with no luck.