ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Textbox's truncated once printed (Excel 2000) (https://www.excelbanter.com/excel-discussion-misc-queries/3756-textboxs-truncated-once-printed-excel-2000-a.html)

Robert Pemberton

Textbox's truncated once printed (Excel 2000)
 
When using text boxs in excel if the data entry is larger than the text box
it does not print out everything in the text box. Is there a way to get it to
print out all the information contained in the text box. For the only two
solutions I can think of is
1) Make the text boxs bigger but my manager rejected the idea.
2)Cut an paste the information onto a excel spreedsheet then print it that
way by using a macro but that is a last resort.

Frans van Zelm

Dear Robert,

1) 2) and 3) Reject your manager. If it doesn't fit, it doesn't.
4) Perhaps ... use a smaller font?
5) Refrase your text ...

Frans

"Robert Pemberton" <Robert wrote in
message ...
When using text boxs in excel if the data entry is larger than the text

box
it does not print out everything in the text box. Is there a way to get it

to
print out all the information contained in the text box. For the only two
solutions I can think of is
1) Make the text boxs bigger but my manager rejected the idea.
2)Cut an paste the information onto a excel spreedsheet then print it that
way by using a macro but that is a last resort.




Dave Peterson

Make the font smaller????



Robert Pemberton wrote:

When using text boxs in excel if the data entry is larger than the text box
it does not print out everything in the text box. Is there a way to get it to
print out all the information contained in the text box. For the only two
solutions I can think of is
1) Make the text boxs bigger but my manager rejected the idea.
2)Cut an paste the information onto a excel spreedsheet then print it that
way by using a macro but that is a last resort.


--

Dave Peterson


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com