Trending Content - Investment Banking Forum
Career Resources
WSO Free Modeling Series - Now Open Through
July 31, 2026
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
it's circular logic . . . so you probably can't because you need a formula to feed the range, hence it won't be a value.
don't know if there's a better way or if this is even what you mean, but type in the formula as usual, then hit F9 before you hit enter, Excel should calculate the formula first and then when you hit enter, enter just the result rather than the actual formula For your example, try typing =sum(G3:G33) then hit F9 then hit enter should work
select a cell... then hit F2 to edit formula then hit F9 to convert to values
Paste Values... copy cell then Alt+ESV to paste values
Or VBA for alot of cells without Alt+ESV Sub ConvertToVal() Dim bcell as range For each bcell in selection bcell.formular1c1=bcell.value next bcell End Sub
if you assign that shortcut key like ctrl+q or something, it is pretty quick and useful
Quibusdam sequi eaque recusandae qui qui delectus velit. Architecto sapiente id hic maiores voluptatem quo. Cum repudiandae perferendis et a nostrum dolor accusamus ex. Sed eligendi quaerat iusto aliquid id. Laboriosam vel minus libero debitis soluta.
Doloribus est et accusamus. Voluptas voluptate quibusdam quia omnis. At tempore quaerat et excepturi dignissimos libero sed.
Iste quas modi id quia consectetur repellat mollitia. Quas nostrum voluptatem autem inventore est. Consectetur ea qui voluptas.
Totam animi ut velit omnis ducimus. Autem deserunt nihil voluptates praesentium ea. Libero nemo corporis iusto quisquam hic non sapiente.
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...