Stop text carries over

G

Godwin Chan

We all knows that long text will carries over to the next empty cell, but how
to stop it.

That is the long text in cell A1 will not carries over to cell B1
 
D

Dennis

You have 2 options, the text will wrap so your cell/row will become deeper or
you can shrink the text to fit in you existing cell width. These are in the
Format - Cells - Alignment options
 
N

Nayab

You have 2 options, the text will wrap so your cell/row will become deeper or
you can shrink the text to fit in you existing cell width. These are in the
Format - Cells - Alignment options






- Show quoted text -
Click to expand...

hey you have one more option. Stop writin so long text... kidding!!
 
G

Godwin Chan

Actually the case I face is
Cell A1 Cell B1
Cell C1
F/F & EQUIPMENTS (Compu software) ( nothing in it) Site office

but the sheet shows
F/F & EQUIPMENTS (Compu (blank) Site
office

The remaining text in A1 "software)" cannot carries over .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Carry over YTD balance to next worksheet 4
Text does not carries Over 3
Use a master workbook to carry over changes to multiple workbooks 1
Extract Month and year from Cell containing date, month, year & time 2
Excel does not accept text format! 0
Paste to excel from word - auto format problem 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
how to carry forward a total from one page to another 3

Top