Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel shortcut CNTL ~ (Excel 98)

    Does anybody know what CTRL ~ does in excel? It changes the pixels but I don't know the affect of that or why would you use it.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel shortcut CNTL ~ (Excel 98)

    It toggles between viewing results and viewing formula's.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel shortcut CNTL ~ (Excel 98)

    Or is it the same as
    CTRL+SHIFT+#
    Apply the Date format with the day, month, and year.

  4. #4
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel shortcut CNTL ~ (Excel 98)

    Thank you very much.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel shortcut CNTL ~ (Excel 98)

    Its definitely not the same in my Excel. It is supposed to switch between displaying results and formulas. If it is doing something different on yours, then you may have it assigned to a macro.
    Legare Coleman

  6. #6
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel shortcut CNTL ~ (Excel 98)

    I've sure I've noticed you say that before. But to switch between formulae and values I use [CTRL] + [`] - that's the one to the left of 1 (if you see what I mean!) and that has always been the same for me on any machine I've ever used. That said, I just went to check [CTRL]+[SHIFT]+[#] and didn't get the time stamp as I expected. Is this a keyboard layout thing? Regional settings?

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel shortcut CNTL ~ (Excel 98)

    You are correct that it's Ctrl-` (left apostrophe), not Ctrl-~ (tilde)which shows formulae. (Many of us may be guilty of this misstatement!)

    On standard installations, XL 97 Ctrl-Shift-# gives a date format , and Ctrl-Shift-@ yields a time format; Ctrl-shift-`, a.k.a Ctrl-~, sets format to General.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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