| จำนวนหน้าตามหัวข้อ: [1 2] > |
How to enlarge lines in Excel เธรดต่อผู้เขียนข้อความ: Lise Berthiaume
|
|---|
I have a text to translate in Excel unfortunately my text has 2 lines in French and it does not go on second line so I lose half of my text. How to get my text on two lines in the same cell?
Thank you,
Lise
| | | |
Francis MARC
ลิธัวเนีย
Local time: 12:58
ภาษาอังกฤษ เป็น ภาษาฝรั่งเศส
+ ...
| use the tool bar | Dec 8, 2005 |
Go to "Format" in the upper bar, then select "Cell", then "Alignment" and check the box for an automatic line return
| | | |
Robert Zawadzki (X) 
Local time: 11:58
ภาษาอังกฤษ เป็น ภาษาโปแลนด์
+ ...
| Not sure what are English names of these options, but | Dec 8, 2005 |
Select a row clicking on its number on the left
Right-click it
Format cells
Alignment (SECOND TAB)
Wrap lines (first option under a divider)
I have Excel 2003
[Edited at 2005-12-08 16:24]
| | | |
Lise Berthiaume
แคนาดา
Local time: 05:58
ภาษาอังกฤษ เป็น ภาษาฝรั่งเศส
TOPIC STARTER | Thank you but... | Dec 8, 2005 |
I do have Excel 2000 and I do not have your commands. I tried but I can not find the allow two lines or the other command.
| | |
|
|
|
two2tango
อาร์เจนตินา
Local time: 06:58
สมาชิก
ภาษาอังกฤษ เป็น ภาษาสเปน
+ ...
If you have two separate lines in the same Excel cell, with an "enter" between them, you can separate them using alt+enter (i.e. pressing "enter" while you hold down the "alt" key).
Regards,
Enrique
| | | |
Dr. Janos Annus (X)
ฮังการี
Local time: 11:58
ภาษาอังกฤษ เป็น ภาษาฮังการี
+ ...
| Select the cells | Dec 8, 2005 |
Select the cell, then Format, Cells, in the pop up window at the bottom: check Wrap Text
Or select the Row, Format, Row, Autofit
I guess this works.
| | | |
Lise Berthiaume
แคนาดา
Local time: 05:58
ภาษาอังกฤษ เป็น ภาษาฝรั่งเศส
TOPIC STARTER
I tried every things that you told me but if I do alt + enter I can write the text but the following line disapears. Could it be lock?
Thank you
| | | |
Lise Berthiaume wrote:
I have a text to translate in Excel unfortunately my text has 2 lines in French and it does not go on second line so I lose half of my text. How to get my text on two lines in the same cell?
Thank you,
Lise
Select your cells or all of them (Ctrl/Strg+A).
Go to Format (on the Menu Bar), from there select the first option Cells (or press Ctrl+1) and in the window that opens select the tab called Alignment.
There you have a tickbox which reads Wrap text. Select it, and, voila! you have it.
| | |
|
|
|
Brandis (X)
Local time: 11:58
ภาษาอังกฤษ เป็น ภาษาเยอรมัน
+ ...
find this all versions of excel have this in a form or the other. Brandis
| | | |
Lise Berthiaume
แคนาดา
Local time: 05:58
ภาษาอังกฤษ เป็น ภาษาฝรั่งเศส
TOPIC STARTER
I tried wrap text but it did not solve my problem. Somebody else has an idea? I think that the form is locked to fit one page of the report. So the only thing that I see is to try to reduce my text. But you know that it is not easy. How to translate busy with an other word which counts 4 letters?
| | | |
pcovs
เดนมาร์ก
Local time: 11:58
ภาษาอังกฤษ เป็น ภาษาแดนิช
| How about lengthening your column? | Dec 8, 2005 |
Can you make your translation column longer?
This could make life easier for you if 'wrap text' doesn't work for some reason.
'Remove page break' could also be an option (I'm not sure about the English version of this).
If you can find at the bottom of the page a punctured line, you should place your cursor in the cell immediately below this line, go to 'Insert' and chose 'remove page break'.
[Edited at 2005-12-08 20:11]
[Edited ... See more Can you make your translation column longer?
This could make life easier for you if 'wrap text' doesn't work for some reason.
'Remove page break' could also be an option (I'm not sure about the English version of this).
If you can find at the bottom of the page a punctured line, you should place your cursor in the cell immediately below this line, go to 'Insert' and chose 'remove page break'.
[Edited at 2005-12-08 20:11]
[Edited at 2005-12-08 20:16] ▲ Collapse
| | | |
Can Altinbay
Local time: 05:58
ภาษาญี่ปุ่น เป็น ภาษาอังกฤษ
+ ...
เพื่อระลึกถึง
Lise Berthiaume wrote:
I do have Excel 2000 and I do not have your commands. I tried but I can not find the allow two lines or the other command.
Even in 2000, you should have a Format menu in the menu bar. This menu has a Cells... item. It brings up a dialog box, which should have an Alignment tab, which should be the second one from the left. Click Wrap Text. Do all of this AFTER selecting the column into which you are translating, so that you don't have to do it over and over.
| | |
|
|
|
Lise Berthiaume
แคนาดา
Local time: 05:58
ภาษาอังกฤษ เป็น ภาษาฝรั่งเศส
TOPIC STARTER | Thank you to everybody | Dec 8, 2005 |
But I think that the form has been locked to keep it on a page instead of two pages. But beleive me I will keep all the informations that you gave me for other translations. I am not use to work with Excel and I think that I will be able to use your answers soon.
Thank you again for your help.
Lise
| | | |
Jo Macdonald
สเปน
Local time: 11:58
สมาชิก (2005)
ภาษาอิตาลี เป็น ภาษาอังกฤษ
+ ...
Hi Lise,
Also, you can change the size of the line or column by putting the cursor between two lines or columns so the cursor changes to a line with 2 arrows. Then drag the line or column to the width you want.
| | | |
Lise Berthiaume
แคนาดา
Local time: 05:58
ภาษาอังกฤษ เป็น ภาษาฝรั่งเศส
TOPIC STARTER
The first thing that I did it is try to drag it did not work.
| | | |
| จำนวนหน้าตามหัวข้อ: [1 2] > |
Login to reply/comment 
