Results 1 to 4 of 4

Thread: excel 2007

  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel 2007

    I have just been 'upgraded' to excel 2007 and have 2 quick questions:
    • Is there a replacement for the paste special values button, which appears to have disappeared?
    • Given that the tools menu has disappeared, under Help>popular options>Show all windows in the task bar I am advised that there is an option to display all workbooks in the windows task bar. However there is no link or other help that shows me how to switch this feature on/off
    Can somebody please point in the right direction for the above 2 features

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    1. There is a paste values item in the Paste dropdown on the Home tab.
    2. Office button - Excel Options, Advanced section, scroll down to the Display part and it's the third option.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the information Rory - My initial impression is that everything takes more effort in 2007:
    1. This action now takes potentially 3 clicks rather than one!
    2. This option is nicely hidden where you would not look?

    But no doubt I will get used to it given time!

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    1. You can also add the Paste Values button to the QAT.
    2. Not exactly an option I would use very often, and not much more obscure than where it was before, IMO.
    As a general rule though, yes, it all takes more effort.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •