Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
PHP Girl
 
Posts: n/a
Default How to print everything in a cell

I have a spreadsheet that has different sized cells filled with text. I have
2 larger cells and when I go to print these 2 cells cut off about the last 2
sentences. I have tried making the cells larger and removing the formatting
and redoing it but nothing seems to work... HeLP
  #2   Report Post  
FinRazel
 
Posts: n/a
Default How to print everything in a cell

Here are a couple of things you can try:
1. The "Merge and Center" command (button to the right of the "Align Right"
button) will allow you to extend your text over several cells. Highlight
your cell, along with other empty cells next to or beneath it, and click
"Merge and Center" This might make them fit (but you won't be able to sort
your data unless you unmerge the cells)
2. In the Alignment tab of the Format Cells screen, check "Shrink to fit."
This will ensure that all of your text shows up, but it may be quite small.

"PHP Girl" wrote:

I have a spreadsheet that has different sized cells filled with text. I have
2 larger cells and when I go to print these 2 cells cut off about the last 2
sentences. I have tried making the cells larger and removing the formatting
and redoing it but nothing seems to work... HeLP

  #3   Report Post  
PHP Girl
 
Posts: n/a
Default How to print everything in a cell

Thanks for your input. But actually I finally figured it out last night. You
have to cut off the long sentences and although it does not look as neat it
works. I solved the office problem. :-)

"FinRazel" wrote:

Here are a couple of things you can try:
1. The "Merge and Center" command (button to the right of the "Align Right"
button) will allow you to extend your text over several cells. Highlight
your cell, along with other empty cells next to or beneath it, and click
"Merge and Center" This might make them fit (but you won't be able to sort
your data unless you unmerge the cells)
2. In the Alignment tab of the Format Cells screen, check "Shrink to fit."
This will ensure that all of your text shows up, but it may be quite small.

"PHP Girl" wrote:

I have a spreadsheet that has different sized cells filled with text. I have
2 larger cells and when I go to print these 2 cells cut off about the last 2
sentences. I have tried making the cells larger and removing the formatting
and redoing it but nothing seems to work... HeLP

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
A cell in an excel spreadsheet that does not print but shows in pr aji Excel Discussion (Misc queries) 1 September 5th 05 09:46 PM
Excel printing problem - won't print cell under a "fill effect" bo dmotika Excel Discussion (Misc queries) 0 May 26th 05 04:38 PM
Sequencing a Cell over print pages Benjamin Excel Discussion (Misc queries) 0 February 8th 05 10:43 PM
Can I create a cell that will count by one every time I print the. Tyler Hopfner Excel Worksheet Functions 1 February 7th 05 06:10 PM
How do I print all the text in a cell Dorna Tucker Excel Discussion (Misc queries) 4 February 3rd 05 04:23 PM


All times are GMT +1. The time now is 01:33 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"