Hi all
Can somebody help?
I have an 2 excel formula in a worksheet.
1 that adds up 15 cells, and 1 that adds up about 30 cells.
On the first one, when I press F2 on my formula it highlights all the cells it is summing in different colours (so I know which ones it is picking up).
On my second one, it does not do this.
Is there a limit as to how many cells it will perform this on? As it is quite a helpful feature.
Thanks in advance
cd:
Are you sure those cell refs are in the same sheet as the formula? That's the only way you will see that feature work.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
In Excel 2003 the limit is thirty cells, after that, the cells will be in the formula, but the nice colours won't display.
You can extend this by defining ranges instead of using individual cells.
HTH
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks