Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Having problem setting cell height to fit text in cell

19 Oct 2015   #1
trinaz

Windows 7 Pro 64bit SP1
 
 
Having problem setting cell height to fit text in cell

Very limited experience with Excel...have a multi page workbook but can't figure out how to auto format existing text to fit in cells so there is no space either on top or bottom of the cell.

Only way I can get this so far is to manually move the bottom line of the text box up to the bottom of the actual text in box. But this causes the print out to overlap sometimes of the text lines in print view.

Is there a way to 'auto-format' individual cells to fit the text in the cell without leaving alot of space above or below the lines, or top/bottom lines, of the cell.




Attached Thumbnails
Having problem setting cell height to fit text in cell-capture.jpg  
My System SpecsSystem Spec
.
19 Oct 2015   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

When you are in the cell that you want to align with the top, Right Click & select Format Cells & when that opens Click on the Alignment Tab & then you will see Horizontal & Vertical, click on the Vertical drop down arrow & select Top. That will align the text to the top of the cell & eliminate that space.

When you move to the next cell to insert the Dollar amount it will be lined up with the bottom of the text in the previous cell, which is what you want.
My System SpecsSystem Spec
19 Oct 2015   #3
trinaz

Windows 7 Pro 64bit SP1
 
 

Quote   Quote: Originally Posted by Ranger4 View Post
When you are in the cell that you want to align with the top, Right Click & select Format Cells & when that opens Click on the Alignment Tab & then you will see Horizontal & Vertical, click on the Vertical drop down arrow & select Top. That will align the text to the top of the cell & eliminate that space.

When you move to the next cell to insert the Dollar amount it will be lined up with the bottom of the text in the previous cell, which is what you want.
Thanks...I think my problem is what I see on the screen in the target cell changes if I leave that cell.

2 jpgs attached...sample 2 is what I see in the cell all text is I entered appears correctly as entered in jpg2

But...if I leave that cell and click on the following or adjoining cell then I loose part of the original text seen in jpg2 as is now shown in jpg1 ?

That's when I get horizontal lines partially running together in print preview and/or actual print output ?


Attached Thumbnails
Having problem setting cell height to fit text in cell-sample-1.jpg   Having problem setting cell height to fit text in cell-sample2.jpg  
My System SpecsSystem Spec
.

20 Oct 2015   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

OK. If you click on the top of a column, so the whole column is selected, then move the cursor to the first cell & right click on it & Select, Format Cells as I suggested in my first post & then Select the Alignment Tab & in the Vertical section, select Top. Also make sure you have a Tick in the Word Wrap check box.

This should then have that whole column formatted so that it always aligns to the top & word wrap occurs if you need more than one line of text.

So when you have finished adding text & then the amount in the next column & move back to the second cell line for the next entry it should behave exactly as it did in the first one where the text aligns with the top of the cell.
My System SpecsSystem Spec
Reply

 Having problem setting cell height to fit text in cell




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Can I compare 2 Excel spreadsheets cell by cell?
I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always ...
Microsoft Office
6 Cell Vs 9 Cell Battery for Laptop?
Someone needs to get a new battery for a very old laptop they have. The battery doesn't work so they have to have it plugged all the time otherwise it wouldn't work. Laptop is 15.6 and sort of heavy but the thing is they never take the laptop outside the house. It will mainly be used on one floor...
Hardware & Devices
Problem sending Pictures via Text to Cell Phone / email
Recently my Brother tried sending 8 pictures to me and my other two Brothers, yes there are four of us. Brother sending pic's is using; A 4S iphone w/ ATT but says, "that's never mattered before". My wife and I have Verizon and I never received the text message to my LG_VN150 phone I can...
Browsers & Mail
How To Send Text/E-Mail *FROM* Verizon Cell Phone/Smartphone *TO* PC?
Hello. I have a question. How does one send a text message or e-mail *FROM* a Verizon cell phone or smartphone *TO* a PC's e-mail server (such as G-Mail or Hotmail)? I have seen many online articles and forums indicate the reverse; that is, FROM a PC e-mail client or online webmail TO a Verizon...
Browsers & Mail
Splinter Cell 1 problem
First sorry for my bad english. I want to play Splinter Cell 1, it's all ok but i can't change resolution and details. It is by default 640x480 and low details and when i try to change sometning, resolution or level of details, screen goes gray i can't see nothing.. but I can hear music in...
Gaming
Problem with splinter cell conviction
hi all i have a problem with tom clancy's splinter cell conviction ....... when the game tries to start it gets a black screen then it crashes to the desktop i dont know why is that ... the pc passes all the requirements and its running on win7-32 bit i even hav a laptop that doesnt pass any of...
Gaming


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 21:26.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App