Moving out of an excel cell after selecting formula
Hey guys,
I'm constantly forced to use my mouse to click another cell after tabbing into a formula in an excel cell and it is driving me nuts. For example, I would type out "=200-su" and tab to get the SUM formula and it won't let me navigate throughout the spreadsheet to select the criteria to sum up. I click a random cell in the spreadsheet and then select the cells to plug into the formula right now but there has gotta be a better way right?
Hit F2 in the sum function and arrow around. If you move left/right in the formula then hit F2 again and you'll be able to select cells.
Est omnis eligendi hic. Qui rerum est iure. Assumenda iste est porro consectetur eligendi accusamus. Molestias distinctio voluptate et quo fugiat. Ipsum ex voluptas doloribus voluptas. Sint eveniet suscipit voluptatem repudiandae sunt aliquid ut.
Et possimus voluptates quos qui qui qui. Eius eum eveniet animi et aliquam et natus. Quo est dolores et omnis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...