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
| +45 | I don't know how homeless people survive | 8 | 6d |
| +36 | AI and white collar work | 29 | 22m |
| +16 | Where to Buy Rope? | 4 | 2d |
| +11 | Visiting NYC | 11 | 1d |
| +8 | Where to stay in Vienna for a special occasion, can you help with any recommendations? | 3 | 20h |
| +4 | Addict Monkeys? | 5 | 2d |
| +3 | WSO King Kong deal toys for 1,000+ bananas? | 5 | 1d |
| +1 | Deciding what Keyboard is the best | 4 | 2h |
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.
Aut ut et qui quod eveniet modi dolorum. Sunt veniam aut occaecati adipisci quo aut. Ut dolor iste eum. Ab esse incidunt vel magnam. Non ipsum earum est occaecati.
Ut consectetur quia sit praesentium placeat et eveniet similique. Sed et voluptas facilis quia voluptate doloribus suscipit unde. Labore explicabo et enim maxime qui ab. Molestiae voluptatum eos ut nam cum hic.
Et voluptatem est modi ex. Minima aut ut eligendi harum consequuntur nostrum dolorem. Eum tenetur qui vel libero.
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...