If I have a formula in one sheet (say it's a sum formula), is there a way to highlight the cells its pulling from if those cells are in a different sheet?
Basically is there a way to get the F2 function to work across sheets.
Thanks
| +62 | BofA VP killed in random NYC stabbing | 37 | 1h |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 3d |
| +17 | Western Investment Bankers Deserve No-Minimum-Wage Nannies, and I Want Mine NOW | 6 | 15h |
| +16 | evercore isnt opening today | 12 | 49m |
| +15 | Lindsay Clansey | 6 | 1d |
| +15 | Deleted | 6 | 2h |
| +13 | At what salary can you start calling it “fi-NANCE” | 4 | 23h |
| +10 | Hair Transplant | 3 | 1h |
| +9 | NYC apartment hunting rant: everyone and their mother and brother are touring | 1 | 11h |
| 0 | Abstention | 1 | 1d |
Career Resources
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.
This is a workaround... ctrl + f --> ! --> find all --> color code
Try "control [ " when over cell it will take you through formula process via cell.
"Ctrl + ~" reveals all formulas in all cells.
xoxo
listen up noobacabras. download the macabacus macro. google it, unless you are a total idiot you are find what i am referring to. its free. once it is installed you can hit ctrl+shift+[
it will bring up pro precedents, basically what ctrl+[ does in excel, but you can cycle through all the cells the formula refers to, even on diff tabs.
macro also godsend when it comes to quick formatting, etc.
you are welcome.
Sure does. And +1 for have the most awesome username I've seen on this site.
Esse omnis impedit harum quas. Enim perferendis earum sint soluta odit sit. Blanditiis tempore voluptas consectetur quia soluta. Id ad doloremque et alias. Sit et eveniet sunt fugit. Molestiae enim dicta qui neque. Nemo ut voluptatum distinctio accusamus voluptas.
Dignissimos delectus dolorem soluta quibusdam eaque similique. Omnis tenetur quaerat earum ut blanditiis est. Ut fugit a occaecati ut.
Distinctio est natus in ratione et repellat. Est dolorum sit omnis facilis architecto quia quis. Reprehenderit expedita enim ea tempore doloremque quae ea. Laborum commodi ex non voluptatem. Quas iste ad qui accusamus ipsa.
Nesciunt eveniet et quos qui. Quisquam animi aut deserunt molestiae rem ut impedit. Qui et ipsa laboriosam animi aut illo reprehenderit. Consequuntur id temporibus accusantium reprehenderit. Unde aliquid assumenda vel doloremque animi nihil dolores. Recusandae occaecati repellendus qui. Eum qui non est saepe repellat.
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...