+ Reply to Thread
Results 1 to 3 of 3

Which keyboard shortcut for following through formulas (excel 2010)

  1. #1
    Registered User
    Join Date
    06-28-2005
    Posts
    81

    Which keyboard shortcut for following through formulas (excel 2010)

    Hi, today excel 2010 was installed on my company PC and I'm no longer able to use a keyboard shortcut which used to work up to excel 2007.

    Say that you have in cell A1 a formula like this =A20 (a simple link to the cell A20); in the past it was possible to press a combination like CTRL+SHIF+è (I don't know the english equivalent) when selecting cell A1 to have cell A20 selected instead of cell A1. It was very useful to move between sheets when auditing a model.

    It doesn't work anymore in excel 2010. Anyone has had this issue or knows a solution or an alternative way of doing this. If I remember correctly in excel 2003 you could also select an option to have the mouse double click obtain the same "follow through" result.

    any help ?

    Thanks for your support and sorry for my english (I hope to have made myself understood)

    Paolo

    Italy

  2. #2
    Forum Contributor
    Join Date
    08-01-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    182

    Re: Which keyboard shortcut for following through formulas (excel 2010)

    Hi,

    I dont know about Excel 2010. however, in 2007 it was CTRL+SHIFT+[. Hope it works...
    Last edited by inayat; 10-13-2011 at 06:00 AM.

  3. #3
    Registered User
    Join Date
    06-28-2005
    Posts
    81

    Re: Which keyboard shortcut for following through formulas (excel 2010)

    Thanks, the problem is that in excel 2010 (at least my excel 2010) that shortcut (actually the italian equivalent) doesn't work anymore ... I suspect this is also true for the english excel 2010 and the shortcut you suggest...

    any other idea ?

    [update:] I have been told that the english version of excel 2010 works as expected (ctrl+shift+[) so the problem seems to be in the italian excel version (pre-sp1, don't know if it happens also with sp1 installed)
    Last edited by kayard; 10-13-2011 at 09:00 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1