+ Reply to Thread
Results 1 to 2 of 2

Ctrl+Enter for Round2 formula

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Ctrl+Enter for Round2 formula

    In my column B, there is some Cell with Fix Value, some with formula and the formula aint the same. I want to do Round2 for all. My B1 is a formula (eg C1+D1), hence i select the whole column B. Put the Round2 formula in B1, then CTRL Enter. Now all column B has Round2, however, i discover ALL formula become (C2+D2, C3+D3 etc etc.) Even my Fix value has formula now. How can i just add Round2 formula to all cell using the Ctrl Enter method Without amending the original content/formula of the cell???

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Ctrl+Enter for Round2 formula

    Unfortunately I don't understand exactly what you are asking.

    What result are you expecting? From your description CTRL-ENTER is behaving as it should.

    Do you expect your C1+D1 formula to propagate only to empty cells in column-B?

    Does "Round2" have some significance for us? If so then what does it mean?

    Do you really want to propagate your formula to all million-plus rows of column-B?

    With reference to the following image: if you put "=D1+E1" into cell B1 and then perform some operation (not CTRL-ENTER!) that achieves your expected result then what would you expect to see in each of the 10 cells B1:B10, given the starting point shown in the image.

    ctrlEnter.png

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 15
    Last Post: 01-03-2018, 03:32 PM
  2. [SOLVED] convert array formula (max if ) without using ctrl sht enter
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-07-2017, 11:31 AM
  3. [SOLVED] Formula Returing #DIV/0 when using Sift+Ctrl + Enter
    By budvegas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2013, 10:41 AM
  4. With VBA Enter Ctrl Shift Enter For Array Formula
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-17-2013, 09:02 AM
  5. [SOLVED] CTRL+SHIFT+ENTER array formula not working
    By frusterated in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2012, 12:02 AM
  6. Array Formula: CTRL+SHIFT+ENTER?
    By WebKill in forum Excel General
    Replies: 2
    Last Post: 05-27-2011, 01:56 PM
  7. Replies: 2
    Last Post: 10-20-2005, 05:05 PM

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