Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Maximum Characters in one cell

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Maximum Characters in one cell

Resolved · Medium Priority · Version 2003

Reply Wed 1 Sep 2010, 10:18Delegate Claire said...

Claire has attended:
Excel Intermediate course
Excel Advanced course

Maximum Characters in one cell

I regularly have to add large paragraphs of text into one cell. When I have entered a lot of text its goes a bit wierd and the text stops wrapping. I know on MS access you can set the number of characters you can input into a cell. Can you do something similar in MS Excel?

For upcoming training course dates see: Pricing & availability

Reply Wed 1 Sep 2010, 13:51Trainer Anthony said...

RE: Maximum Characters in one cell

Hi Claure, thanks for your query. There is an upper limit on the amount of information you can display in a cell:

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

Hope this helps,

Anthony

Reply Thu 2 Sep 2010, 08:58Delegate Mike said...

RE: Maximum Characters in one cell

Hello friends.. thanks a lot telling us this, this is a very good thread for me.

One cell in Excel can hold 32,767 characters.

The maximum you can see in a cell on the worksheet is 1,024, but
all 32,767 are shown in the formula bar.

Term Papers

Excel articles

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Microsoft Excel Training: Essential for Today's Employees
· How To Print Worksheets In Excel
· From novice to expert users - Microsoft Excel fits all
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

Please browse our web site to find out more about
advanced excel class and other Microsoft training courses.

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips