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.
Nihil porro ipsum qui tenetur numquam. Minus ut ut delectus blanditiis saepe unde nobis. Nostrum est ea perferendis voluptatum.
Illum vel voluptates cum et ipsum vel. Quasi aut corporis aliquam optio consequatur illo. Quisquam non fugit harum ea debitis.
Qui ex ex dolorem suscipit sunt. Vel et voluptas nobis maiores itaque. Eos culpa sed voluptatem aut accusamus.
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...