Apr 11 2019 07:21 AM - edited Apr 11 2019 10:25 AM
I recently upgraded my computer to a new imac from the mac mini. Some things changed in excel. I create spreadsheets with multiple sheets in my work book. The last page I use to keep a running total of each item that is listed on those pages. Normally when I am creating my formula on that last page, I would create it by typing "=sum( " and then going back to sheet one and clicking on the cell I want. After that, all I had to do was click on each sheet and it automatically knew to add the same cell on that page to the formula. So I would create my formula quickly by clicking on each sheet like that until I got to the last page before my total page. I can no longer do this on the imac. I have to physically click on each sheet, then the cell I want, then the plus sign. This causes more room for error and is very tedious considering my work load. Is there a way to make it go back to letting me create the formula more efficiently? Usually google is my go to, but I can't find anything to help!
Apr 15 2019 11:46 AM
SolutionApr 23 2019 08:53 AM
@Jamil Mohammad Thank you so much!! I don't know why I wasn't able to find that formula but it sure did help me immensely! Thank you!!!
Apr 23 2019 10:08 AM
Apr 15 2019 11:46 AM
Solution