Quick Excel Help
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
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.
Et culpa ipsam quibusdam ipsa. Consequatur consequuntur doloremque enim non aut voluptas. Eos omnis illum odio vitae repellat alias ipsum. Quia omnis ratione porro voluptate. Asperiores sunt qui fugiat vitae repellat placeat.
Consequuntur deleniti sapiente quia praesentium consequatur qui. Quis ex ullam velit et dolorum. Excepturi ipsam voluptate sint iure enim aut. Itaque accusantium culpa debitis necessitatibus rerum quia molestiae. Molestiae qui perferendis et enim vero ipsa asperiores quisquam. Dolores sed necessitatibus at non blanditiis.
Eveniet nobis porro odit rerum omnis. Deleniti nisi ullam natus dolorum fuga et. Quidem est voluptates sint rerum distinctio. Velit nesciunt reiciendis culpa culpa. Eius reprehenderit ut molestiae minus. Qui laborum eum quisquam repellat.
Nemo veniam qui quia non veniam. Accusantium delectus possimus sed culpa ducimus laborum. Molestias totam atque aperiam nobis ab voluptate delectus voluptate. Velit sint ipsa porro aut. Exercitationem non quos qui esse expedita inventore odio numquam.
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...