View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Little Mermaid The Little Mermaid is offline
external usenet poster
 
Posts: 7
Default How to match data in worksheet same as in Print Preview?

I would be most appreciative if someone could help me here.
I am quite new to excel and I cant understand why when I have set up the
spreadsheet (Columns and Rows) and type information into the cells as I want
it to be displayed that it is different in the print preview.
Am I right to understand that print preview shows exactly how my pages will
appear when they are printed?
For example in a cell: I type a company name that is say 5 words long. 4
words fit on the first line in the cell then the last word goes to next line
(same cell).
However in print preview all 5 words are on the same line.
How can I put the data into the cells on my worksheet without constantly
checking print preview to see if it is different then adjusting the worksheet
to match? Is this possible?
If I havent made myself clear please ask me for any further information
that might help.
I have just started a new job and they really would benefit by using excel
(currently using tables in word which is very messy), so I am putting
together some worksheets at home to see if I can tidy things up a bit.
Many thanks for any help I can get.
Kind regards
Dawn

--
IT Student