Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Text in an excel spreadsheet

How do I type a large piece of text in an excel spreadsheet as an
introduction to the figures that will then follow in columns?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Text in an excel spreadsheet

Right click on the cell with the large piece of text, and go to Format Cells.
Then click on the alignment tab and check the Wrap Text option. Click OK.
You can then adjust the colun width further if you need to.

"Firecracker" wrote:

How do I type a large piece of text in an excel spreadsheet as an
introduction to the figures that will then follow in columns?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 194
Default Text in an excel spreadsheet

Firecracker

If you need to keep your column widths for your data, just place a text box
where you want you intoduction and format it as a nice place setting (lines,
no lines; colors if appropriate, etc)

Mike Rogers

"Firecracker" wrote:

How do I type a large piece of text in an excel spreadsheet as an
introduction to the figures that will then follow in columns?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Text in an excel spreadsheet

Also, since this is just some introductory/explanatory text, this is a time
when it is probably OK to use the Merge Cells feature to combine several
cells into one large one to type the text into. This might keep from having
to make a single column so wide to accomodate the text that it makes the
actual information in the column below it look weirdly or awkwardly formatted.

Firecracker - you can use a combination of both suggestions - format the
(merged) cell with wrap text to keep it from getting too wide, and you can
adjust the height of the row and width of the column to get the appearance
you desire, or at least one that's acceptable.

"PriorityDone" wrote:

Right click on the cell with the large piece of text, and go to Format Cells.
Then click on the alignment tab and check the Wrap Text option. Click OK.
You can then adjust the colun width further if you need to.

"Firecracker" wrote:

How do I type a large piece of text in an excel spreadsheet as an
introduction to the figures that will then follow in columns?

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
Sumproduct issues SteveDB1 Excel Worksheet Functions 25 June 3rd 09 04:58 PM
Working spreadsheet highlighting function for Excel 2007 Mr. Low Excel Worksheet Functions 4 June 16th 06 06:12 PM
In Excel I want to copy text from spreadsheet to spreadsheet Kris Excel Worksheet Functions 3 June 9th 06 07:58 PM
How do I delete a text box from an Excel spreadsheet? Uncle Binky Excel Discussion (Misc queries) 1 December 9th 05 04:02 PM
create excel spreadsheet to display data from filled text forms pluck4me Excel Discussion (Misc queries) 0 April 20th 05 08:37 PM


All times are GMT +1. The time now is 08:34 AM.

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

About Us

"It's about Microsoft Excel"