Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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
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
Automatic closedown of Excel 2000 after a period of activity david Excel Worksheet Functions 1 October 20th 06 06:13 PM
Problem saving the file after moving worksheets into another SteveD62226 Excel Discussion (Misc queries) 0 November 18th 05 10:01 PM
Removing textbox after saving and reopening document? curlyfry76 Excel Discussion (Misc queries) 1 April 12th 05 02:51 PM
data changes unexpectedly Helen N. New Users to Excel 8 December 16th 04 03:49 PM


All times are GMT +1. The time now is 04:56 PM.

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"