Results 1 to 6 of 6
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Ctrl+Enter (Excel XP)

    This trick can be very handy.

    It works with formulas as well as with constant values. Relative cell references in the formula in the active cell will adjust themselves automatically in the other cells.

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ctrl+Enter (Excel XP)

    Ricky
    Thanks for sharing - it was a new one for me and will be useful.

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Ctrl+Enter (Excel XP)

    No question this time!

    Instead, I just discovered a feature that I thought others may find useful. It's new for me but the rest of the World may already know of it. Anyway, if you need to enter the same information into several cells, there is a shortcut for doing so...

    Just select the cells, (I'd hold down the Ctrl key and use the mouse to make selections), then type what you want in the last cell selected. Hold down Ctrl and press Enter. That's it, whatever you typed into the last selected cell is now in every cell you selected.

    This works with cells selected anywhere on the sheet. The selected cells do not have to be contigious, where the fill-across or fill-down method would work just fine.
    - Ricky

  4. #4
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cool

    Thanks - very useful.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ctrl+Enter (Excel XP)

    Perhaps now you discovered already the trick, this other one can be of interest as complement for you

    http://www.contextures.com/xlDataEntry02.html

  6. #6
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ctrl+Enter (Excel XP)

    And also useful are the shortcuts:

    CTRL + D (which fills down however many cells are selected)

    CTRL + R (which fills to the right however many cells are selected)

Posting Permissions

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