Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

cavemanlawyer15

macrumors newbie
Original poster
Dec 16, 2007
4
0
I used to use Excel for Windows, and then switched to Mac (Office 2008). One feature seems to have disappeared -- when I highlight a cell that contains a formula, in the old version it used to lightly highlight the cells referenced in the formula. That way, if it was a simple SUM function for example, I can immediately see which cells were being counted. Now, it doesn't highlight... I have to look at the actual formula and refer to the column or row numbers themselves. OR, I can hit Ctrl-U to edit the formula, and only then are the cells highlighted.

I'd love it if the cells would highlight by default, without requiring me to be in edit mode. Is this possible?

Thanks.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.