cell capacity formulae

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell capacity for formulae

Cell capacity for formulae

resolvedResolved · 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.


 

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips


Server loaded in 0.1 secs.