ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i make a paragraph appear in one cell area? (https://www.excelbanter.com/excel-worksheet-functions/21209-how-do-i-make-paragraph-appear-one-cell-area.html)

mmuradian

how do i make a paragraph appear in one cell area?
 
Ok, I am using Excel to keep track of my child support payments. But I also
want to be able to list instantances or occurrances like journal entries when
problems arise from parent/teacher conferences or bad behavior from my child
or my ex. But when I print this out to take to my attorney, I don't want to
have several blank pages or pages with one line of text on it. I want the
one cell that everything is typed in to be displayed as a paragraph. How can
I fix that?

JulieD

Hi

i'm actually not 100% clear on what the current problem is .. but using cell
comments (insert / comment) to record the 'journal entries' might be a
solution - the option for display these are under tools / options / view tab
and for printing under file / page setup / sheet tab.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mmuradian" wrote in message
...
Ok, I am using Excel to keep track of my child support payments. But I
also
want to be able to list instantances or occurrances like journal entries
when
problems arise from parent/teacher conferences or bad behavior from my
child
or my ex. But when I print this out to take to my attorney, I don't want
to
have several blank pages or pages with one line of text on it. I want the
one cell that everything is typed in to be displayed as a paragraph. How
can
I fix that?




DME

One option would be to merge several cells so they appear to be one cell.
Just hightlight a range of cells then choose Format, Cell, Allignments Tab.
Check Merge Cells and Wrap Text. Then just type info in the merged cell.

Craig




"mmuradian" wrote in message
...
Ok, I am using Excel to keep track of my child support payments. But I

also
want to be able to list instantances or occurrances like journal entries

when
problems arise from parent/teacher conferences or bad behavior from my

child
or my ex. But when I print this out to take to my attorney, I don't want

to
have several blank pages or pages with one line of text on it. I want the
one cell that everything is typed in to be displayed as a paragraph. How

can
I fix that?




Myrna Larson

Yeah, then prepare yourself for the myriad problems that merged cells create
<g.

On Fri, 8 Apr 2005 13:30:40 -0500, "DME" <craigjoseathotmaildotcom wrote:

One option would be to merge several cells so they appear to be one cell.
Just hightlight a range of cells then choose Format, Cell, Allignments Tab.
Check Merge Cells and Wrap Text. Then just type info in the merged cell.

Craig




All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com