Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 26-11-2008
Member
 
Join Date: Nov 2008
Posts: 58
Sizing automatic font in Excel

I have a number of cells that contains the long character which does not get properly stored in the same cell.

To see all the words contained in cells with long sentences, I had to reduce much of the character, but losing too readability. At the time all the cells are set with the same character (6), but I want to make sure that every cell has a character suitable for the size of the cell (which I repeat is standard), possibly without having cells one by one and manual operation.

What I try in essence is whether there is some education, taking a particular cell and its contents, the appropriate font size of the maximum possible so that the writing is legible without leave from the edges.

Any suggestions would be highly appreciated.
Reply With Quote
  #2  
Old 26-11-2008
Member
 
Join Date: Oct 2008
Posts: 167
Re: Sizing automatic font in Excel

I am not there for a specific function to notice if the text is longer than the cell ... Some addresses with calls to API, the calculation of pixels or twips occupied in width from the string ...

I suggest a "smart":

1. For each cell controlled create a temporary Textbox that has the same font and tighten the cell. The property AUTOSIZE the TextBox is True.

2. Identifying the cycle. Width that if more of. Width of each cell cycle produces a decrease in the Font size of a certain size (typically a 0.5) ...
Reply With Quote
  #3  
Old 26-11-2008
Member
 
Join Date: Oct 2008
Posts: 33
Re: Sizing automatic font in Excel

Hi,

I also had the same issue regarding how to manage the characters in the same cell,after lot of search I come to a some conclusion that as under.
At the end I resolved so that the cells were checked by a few thousand, but they were always generated by the same 30-40 strings that I have the list, I checked manually 30-40 these cells showing next to each font maximum allowed, then combined with cycles of vertical search and downsizing of character I have arranged everything quickly.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Sizing automatic font in Excel"
Thread Thread Starter Forum Replies Last Post
Font colors are not working in Microsoft Excel Spreadsheet Akolekar MS Office Support 2 15-02-2012 08:03 PM
Not able to change font color in some cells of Microsoft Excel Garsen's MS Office Support 2 01-02-2012 02:08 PM
Automatic filtering in Excel RenNoClue Software Development 4 27-01-2012 08:08 PM
automatic subtraction in excel smartsoul2 Windows Software 3 10-02-2011 05:58 PM
How do i change font color in a range on Excel 2007 AK_Chopra Windows Software 3 09-06-2009 08:16 PM


All times are GMT +5.5. The time now is 10:32 AM.