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:
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" wrote:


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

mikedhmsu;454359 Wrote:
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

Regards,
Simon Lloyd
'Microsoft Office Help' ('The Code Cage - Microsoft Office Help -
Microsoft Office Discussion' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'CTRL+Left-Click for Copying Non-Adjacent Cells Not
Working - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=125785)




--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125785