Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Mar 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What happened to Shift-Edit?

    Hi,
    I recently switched from Office 2003 to 2010 and am still losing a lot of time looking for familiar commands.
    In Excel 2003 there were certain options that became available be clicking on "Edit" while holding the Shift key. I used those options all the time when exporting graphs to documents that needed to be printed.
    Where have those options gone in Excel 2010?

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Quote Originally Posted by wimneel View Post
    Hi,
    I recently switched from Office 2003 to 2010 and am still losing a lot of time looking for familiar commands.
    In Excel 2003 there were certain options that became available be clicking on "Edit" while holding the Shift key. I used those options all the time when exporting graphs to documents that needed to be printed.
    Where have those options gone in Excel 2010?
    Perhaps its' because I have both 2003 and 2007 on my machine, but clicking on Edit while holding the shift key only brings me the regular edit menu. What were the options you were looking for?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by wimneel View Post
    Hi,
    I recently switched from Office 2003 to 2010 and am still losing a lot of time looking for familiar commands.
    I have found this site very useful for transition from Office 2003 to 2010.....
    Learn where menu and toolbar commands are in Office 2010

    I am looking into this freebie ......
    Download English UBitMenu for private use (free for private use)

  4. #4
    New Lounger
    Join Date
    Mar 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The option I am referring to is called "Copy Picture". It basically allows you to export a graph as a picture. I know there are other ways of exporting graphs, but in my experience "Copy Picture" is the one that leads to the best quality pictures (specially for printed documents).

  5. #5
    New Lounger
    Join Date
    Mar 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for your suggestions, tfspry. The first one is very useful, but I haven't been able to find out where Shift-Edit went. As for the second one, shift-Edit opens exactly the same menu options as Edit, not the one I am looking for.
    For a screen shot of the shift-Edit option I am looking for, take a look at Peltier's excellent site: http://peltiertech.com/Excel/ChartsH...ChartData.html.

  6. #6
    New Lounger
    Join Date
    Mar 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Found it! On the home tab, under the "Copy" button. Don't know why I didn't see it before. Sorry to waste your time.

  7. #7
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by wimneel View Post
    Found it! On the home tab, under the "Copy" button. Don't know why I didn't see it before. Sorry to waste your time.
    Great that you found the Copy Picture menu!!!

    For the future this site may also be useful during the transition.....
    Featured courses: Make the switch to Office 2010

  8. #8
    New Lounger
    Join Date
    Mar 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks a lot for your help!

  9. #9
    New Lounger Jon Peltier's Avatar
    Join Date
    Mar 2011
    Location
    Massachusetts
    Posts
    3
    Thanks
    0
    Thanked 2 Times in 1 Post
    You didn't find Copy Picture, because it's been intuitively placed on the Paste split button.
    Jon Peltier
    Peltier Technical Services, Inc.
    http://PeltierTech.com/WordPress/

  10. #10
    New Lounger
    Join Date
    Mar 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That's in Office 2007; in Office 2010 "Copy as Picture" is - more intuitively - under "Copy" on the Home tab

  11. #11
    New Lounger Jon Peltier's Avatar
    Join Date
    Mar 2011
    Location
    Massachusetts
    Posts
    3
    Thanks
    0
    Thanked 2 Times in 1 Post
    I hadn't noticed they had changed that one in 2010. Most of the "interesting" things are pretty much the same. I should load them up side by side and compare.
    Jon Peltier
    Peltier Technical Services, Inc.
    http://PeltierTech.com/WordPress/

Posting Permissions

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