Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2005

Tip: Looking for answers? Try searching our database.

Print titles: can noncontiguous columns at left be printed & how?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
HatMar - 21 Nov 2005 17:13 GMT
Under Page Setup, Print Titles, Select columns to repeat at left:  I tried to
select noncontiguous columns, but got error.  Can this be done successfully
as I cannot move the columns to a contiguous location due to multi-users of
Gary L Brown - 21 Nov 2005 17:41 GMT
You can hide and unhide the columns you don't want to print.  To make things
easier, you can create views to easily switch back and forth between the
hidden column format and the unhidden column format.
View>Custom Views...
HTH,
Signature

Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".

> Under Page Setup, Print Titles, Select columns to repeat at left:  I tried to
> select noncontiguous columns, but got error.  Can this be done successfully
> as I cannot move the columns to a contiguous location due to multi-users of
Gord Dibben - 21 Nov 2005 20:47 GMT
No.

You cannot have non-contiguous columns repeat at left.

But you can select A:E and hide B and D so only A,C and E repeat at left.

Gord Dibben Excel MVP

>Under Page Setup, Print Titles, Select columns to repeat at left:  I tried to
>select noncontiguous columns, but got error.  Can this be done successfully
>as I cannot move the columns to a contiguous location due to multi-users of
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.