98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Cell capacity for formulae
Cell capacity for formulae
Resolved · High Priority · Version 2003
Tian has attended:
Excel Advanced course
Cell capacity for formulae
How to expand the individual
cell to hold more formulaes.
RE: cell capacity for formulae
Hi Tian,
Thank you for your question.
Please note a cell can only contain one formula or statement. You can have up to 32,767 text characters in a cell, however only 1024 will display in the cell, the total can be viewed in the formula bar. There is no way to show all 32k in the cell. you can increase the width and depth of the cell using the Format>Row or Column commands on the Menu bar. I hope that has helped.
Mon 15 Dec 2008: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Creating custom listsIn Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc. |