+ Reply to Thread
Results 1 to 5 of 5

Have to go into edit mode, enter 100s of times, selecting + Ctrl + enter isn't option

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Have to go into edit mode, enter 100s of times, selecting + Ctrl + enter isn't option

    I have hundreds of formula that were not able to occupy the cells with just the fill handle. My work around was to break up the formulas into multiple columns, modify as needed and then in Column A enter
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    which then I drag the fill handle down. Then copy, paste as values and it displays the formula in the cell as it is shown in the edit area. To fix this I then put the cursor in the edit area, hit enter and the cell displays the formula result.
    Is there any way I can do this to all of A column at once? The cells are not formatted as text.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,306

    Re: Have to go into edit mode, enter 100s of times, selecting + Ctrl + enter isn't option

    Can you show a sample of what you are working with, and what you are trying to do?

    I cannot visualize your problem

    I have hundreds of formula that were not able to occupy the cells with just the fill handle.
    why not?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Have to go into edit mode, enter 100s of times, selecting + Ctrl + enter isn't option

    upload.xlsm
    Training plan sheet shows exactly what I am doing.
    Quote Originally Posted by FDibbins View Post

    why not?
    It is because the training plan sheet is trying to organize data in a vertical manner, but the data in planning sheet isn't organized vertically but instead in individual blocks.

  4. #4
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Have to go into edit mode, enter 100s of times, selecting + Ctrl + enter isn't option

    Finding and replacing the = with = worked to convert them all to fully functioning formulas.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,306

    Re: Have to go into edit mode, enter 100s of times, selecting + Ctrl + enter isn't option

    wow that seems like way too much work, Im sure there is a way to automate that, 3 things spring to mind...
    =OFFSET()
    =INDIRECT()
    =INDEX/MATCH

    but because I dont really know what you are doing, you will have to try and explain to me, so I can see if 1 of these woll help you

+ 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. 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
  2. [SOLVED] Ctrl+shift+enter
    By stuntmannen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2013, 09:56 AM
  3. [SOLVED] use of ctrl+ enter
    By abubaniyan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-26-2013, 07:19 AM
  4. [SOLVED] Make "Edit" mode default, rather than "Enter"?
    By Greg Boettcher in forum Excel General
    Replies: 1
    Last Post: 07-26-2006, 08:50 PM
  5. What does Ctrl+Shift+Enter do? How does it differ from Enter?
    By George Furnell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2006, 02:45 AM
  6. Replies: 2
    Last Post: 10-20-2005, 05:05 PM
  7. Save behavior while in Edit/Enter mode
    By RegalTang in forum Excel General
    Replies: 3
    Last Post: 08-19-2005, 04:05 PM
  8. ctrl+shift+enter vs enter
    By tkaplan in forum Excel General
    Replies: 7
    Last Post: 05-27-2005, 12:10 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