Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells widen after saving and reopening file
Excel is driving me crazy after rearranging columns, saving the new
configuration, and then reopening the saved file. Original situation: There is a number of columns titled from right to left: Japanese | English | French | Italian | Dutch | German | Korean | Chinese | etc. The columns | Japanese | English | show several thousands of cells. Each cell of the Japanese text was already translated into English. All cell in the other columns remain empty. Since I need to translate this text into German, I want to have the English and German column side by side. There is no problem to move the columns around so that the screen shows only the columns for English (left) and German (right) on the screen. After saving and reopening this new file, the two columns layout is OK, but each cell has been increased in height from 5 mm to about 20 to 30 mm! Why that? How to solve the problem and keep the original height of each cell? ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells widen after saving and reopening file
I'm not sure if I understand your problem, but if all you want is to
resize the row height, then select all rows that contain data, right-click on the row index, and select & change row height to desired size. Regards, Steve Sigi Rindler schrieb: Excel is driving me crazy after rearranging columns, saving the new configuration, and then reopening the saved file. Original situation: There is a number of columns titled from right to left: Japanese | English | French | Italian | Dutch | German | Korean | Chinese | etc. The columns | Japanese | English | show several thousands of cells. Each cell of the Japanese text was already translated into English. All cell in the other columns remain empty. Since I need to translate this text into German, I want to have the English and German column side by side. There is no problem to move the columns around so that the screen shows only the columns for English (left) and German (right) on the screen. After saving and reopening this new file, the two columns layout is OK, but each cell has been increased in height from 5 mm to about 20 to 30 mm! Why that? How to solve the problem and keep the original height of each cell? ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells widen after saving and reopening file
Thanks Steve!
I am a happy camper again since it took me just 10 seconds to make the new formatting stick. Sigi wrote in message oups.com... I'm not sure if I understand your problem, but if all you want is to resize the row height, then select all rows that contain data, right-click on the row index, and select & change row height to desired size. ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic closedown of Excel 2000 after a period of activity | Excel Worksheet Functions | |||
Problem saving the file after moving worksheets into another | Excel Discussion (Misc queries) | |||
Removing textbox after saving and reopening document? | Excel Discussion (Misc queries) | |||
data changes unexpectedly | New Users to Excel |