ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Print titles: can noncontiguous columns at left be printed & how? (https://www.excelbanter.com/excel-worksheet-functions/56554-print-titles-can-noncontiguous-columns-left-printed-how.html)

HatMar

Print titles: can noncontiguous columns at left be printed & how?
 
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

Print titles: can noncontiguous columns at left be printed & how?
 
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.
ViewCustom Views...
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"HatMar" wrote:

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

Print titles: can noncontiguous columns at left be printed & how?
 
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

On Mon, 21 Nov 2005 09:13:03 -0800, HatMar
wrote:

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




All times are GMT +1. The time now is 10:06 PM.

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