If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Retain Cell Size
I have developed a spreadsheet to carry reference information into my
planner. The sheets are 3 3/4 X 6 3/4 so my cell size must remain exactly the same. When I have changed the font for clarity or to readability, the program adjusts the cells to accomodate the new font. How can I seal the matrix so that if there is a change in the font, it will give me one of the errors (#####, or whatever) instead of "HELPING" me by modifying the cell size. When I go to trim the sheets for punching and inserting into my planner, they MUST be sized identically and the different fonts are needed to quickly show what type of information is on a page. Help. Help |
#2
|
|||
|
|||
Retain Cell Size
Go through and manually set the column widths and row heights by selecting
row/column, right-click, adjust height/width, input value, press enter. (even if you don't change the value, go through the dialogue). This seems to force XL to realize that you want control over sizing, and will no longer adjust cells size to accomodate font size. Note that font that is too large will not produce an error, it get cut off along the top, and try to squeeze out the right-side -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Morto Kopor" wrote: I have developed a spreadsheet to carry reference information into my planner. The sheets are 3 3/4 X 6 3/4 so my cell size must remain exactly the same. When I have changed the font for clarity or to readability, the program adjusts the cells to accomodate the new font. How can I seal the matrix so that if there is a change in the font, it will give me one of the errors (#####, or whatever) instead of "HELPING" me by modifying the cell size. When I go to trim the sheets for punching and inserting into my planner, they MUST be sized identically and the different fonts are needed to quickly show what type of information is on a page. Help. Help |
Thread Tools | |
Display Modes | |
|
|