Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

scaling with "fit to" with hidden columns

Status
Not open for further replies.

bacon4life

Electrical
Joined
Feb 4, 2004
Messages
1,543
Location
US
When I use the "fit to" option for printing a spreadsheet with hidden columns, excel does not seem to take into account that the cells are hidden. Does anyone know how to make it scale based on only the visible cells when I print it?
 
I am pretty sure I have used fit-to-print with hidden columns and had no problems. Are you sure they are hidden and not just really skinny? (maybe try expanding and then rehiding them).

=====================================
Eng-tips forums: The best place on the web for engineering discussions.
 
Also maybe try File/print area / set print area after the columns are hidden.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.
 
just to clarify I could not reproduce your problem so just guessing at a solution.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.
 
Thanks Electricpete for your feedback.

In trying to reproduce it in a totally blank worksheet, I realized it does not have anything to do with hidden columns, but rather that I have several "columns to repeat at left". It leaves an identical amount of room on the right side of the page as the left.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top