Printing Large Excel Formula Without Cutoff
Hello. I have created a pretty large excel formula. The problem is when I try to print it, the formula gets cut off even if I extend the column really far and I do not want to make the font too small. Is there a way to adjust the settings so the entire formula either prints on one page or it goes onto the next page? I have attached what the complete formula looks like on the main sheet and what it looks like when I am trying to print it.
Thank you.
To fit on one page, change the scaling option in print preview to 'Fit Sheet on One Page' or whatever is appropriate.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Thank you for your response. However, by doing that, the font gets too small and it becomes unreadable. Is there a way to adjust settings so the long formula would go onto the next page instead?
Not really. Excel treats formulas different than output values. You could, and this is a kludge, go into formula view, add a =" in front of each formula and a " at the end of the formula. This will convert them to strings. Then exit formula view. This would let you print them across pages or even word-wrap the output.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks