Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
FRUSTRATED
 
Posts: n/a
Default How do I make rows expand to fit wrapped text in cells?

I am submitting a grant which must be done in Excel. The grant was
originally written in Word, and I am cutting and pasting, a paragraph at a
time, into Excel. When I do Format - Row - Autofit, it shrinks the cell to
one line, regardless of how many lines of wrapped text are in there. I'm on
a deadline and really need help fast...
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

If you have a lot to convert, I'd save the original word file as a text file
and then open that into excel. I'd use the "DELIMITED" choice and ensure
that all of the delimiters are turned off. Once you have the data in excel,
format the cells using FORMAT CELLS - ALIGNMENT - WRAP TEXT
"FRUSTRATED" wrote:

I am submitting a grant which must be done in Excel. The grant was
originally written in Word, and I am cutting and pasting, a paragraph at a
time, into Excel. When I do Format - Row - Autofit, it shrinks the cell to
one line, regardless of how many lines of wrapped text are in there. I'm on
a deadline and really need help fast...

  #3   Report Post  
PC
 
Posts: n/a
Default

Try
Selecting the cells and using

Format/Cells/Alignment and select "Wrap Text"

Instead of the process you are using.

HTH

PC


"FRUSTRATED" wrote in message
...
I am submitting a grant which must be done in Excel. The grant was
originally written in Word, and I am cutting and pasting, a paragraph at a
time, into Excel. When I do Format - Row - Autofit, it shrinks the cell

to
one line, regardless of how many lines of wrapped text are in there. I'm

on
a deadline and really need help fast...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make bi-Lingual on a colum in many rows? logengr Excel Discussion (Misc queries) 0 January 22nd 05 10:59 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
how do i make a graph from text ? Jan Derksen Charts and Charting in Excel 1 January 6th 05 01:45 AM
Make a text file from Excel workbook Ramana Murthy Excel Discussion (Misc queries) 7 January 3rd 05 05:37 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM


All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"