Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Franktown, Colorado, USA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What does Ctrl+Esc do? (Excel 2000)

    I recently mistyped the shortcut key-combo "Ctrl+Esc" while editing a new spreadsheet. This keystroke seemed to drastically "adjust" my column widths, putting their dimensions into "NNN (mmm pixels)", instead of the usual default measurements. Try as I may, I could not find out either: a) what this keystroke really does; or [img]/forums/images/smilies/cool.gif[/img] how to reverse it (restore the sheet to "normal" column width dimensions).

    A search of Microsoft Help and Online/web help led nowhere helpful, as usual. Can any guru help me here? TIA

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: What does Ctrl+Esc do? (Excel 2000)

    Lorin

    Ctrl+Esc should activate the Start Button menu, in Windows. But in Excel, back when we had Windows 3.x would activate the Task list.

    As to the column widths going crazy on you, well I suggest copy the worksheet into a new workbook and start from scratch. I don't know why it had such an effect.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

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

    Re: What does Ctrl+Esc do? (Excel 2000)

    On my system it brings up the Windows Start menu, and I can not find any other function documented for that combination in the help files.
    Legare Coleman

  4. #4
    New Lounger
    Join Date
    Aug 2002
    Location
    Franktown, Colorado, USA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What does Ctrl+Esc do? (Excel 2000)

    Oh, heck, am I ever embarrassed... <img src=/S/bash.gif border=0 alt=bash width=35 height=39>
    The shortcut key-combo in question is Alt+Esc (not Ctrl+Esc).
    Sorry for the confusion... my questions still stand. Thanks for the replies so far!

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

    Re: What does Ctrl+Esc do? (Excel 2000)

    On my Windows 95 machine Alt-Esc cycles between open applications in full screen mode (as compared to Alt-Tab). Are you sure you didn't press Ctrl-` (the key to the left of "!")? Ctrl-` shows formulas, but may also change column widths on text and number cells.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: What does Ctrl+Esc do? (Excel 2000)

    If you press Ctrl-` (as John say - the key to the left of "!" and under Esc) all columns will widen by about 100% for standard width, so as to better accomodate the formula length. It does seem to widen columns even if they are completely blank. It certainly does not widen the columns enough to accomodate some of John's (and Legare's) formulae !

    Andrew C

  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: What does Ctrl+Esc do? (Excel 2000)

    That sounds like a challenge to me! I remember reading in Walkenback or someone that very long formulas should be avoided as they are difficult to understand and to debug. Here's one of mine from a standard model I use:

    =(($Q$34*$S$34+$Q$35*$S$35+$Q$41*$S$41+$Q$42*$S$42 +$Q$44*$S$44+$Q$46*$S$46
    +$Q$47*$S$47+$Q$48*$S$48+$Q$50*$S$50+$Q$51*$S$51+$ Q$52*$S$52+$Q$53*$S$53)*1.33
    +$Q$45*$S$45*4+IF($S$36,$Q$36/$S$36)+IF($S$37,$Q$37/$S$37,)+$Q$43*$S$43)*AC3
    +IF($S$38,$Q$38*MIN(10,AC3/$S$38),)+IF($S$39,$Q$39*MIN(10,AC3/$S$39),)+$S$34*$N$34
    +$S$35*$N$35+IF($S$36,$N$36,)+IF($S$37,$N$37,)+IF( $S$38,$N$38,)+IF($S$39,$N$39,)+$N$40*$S$40+$N$41*$ S$41+$N$42*$S$42+$N$43*$S$43+$N$44*$S$44+$N$45*$S$ 45
    +$N$46*$S$46+$N$47*$S$47+$N$48*$S$48+IF($S$49,$Q$4 9/$S$49*AC3+$N$49,)
    +$N$50*$S$50+$N$51*$S$51+$N$52*$S$52+$N$53*$S$53
    +IF($S$40,MAX(0,$Q$40*ROUNDUP((AC3-3500)/$S$40,2),))

    It's not as complex as it looks; it just reads a list of options and looks at what is selected and the frequency with which they are delivered.

    Whoever it was, he was right about the debugging part.
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: What does Ctrl+Esc do? (Excel 2000)

    I'm surprised you didn't show that at Halloween! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: What does Ctrl+Esc do? (Excel 2000)

    And have my windows soaped? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    -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
  •