Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I print noncontiguous rows on the same page? | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
I WANT TO SET PRINT RANGE TO NUMBER OF COLUMNS | Setting up and Configuration of Excel | |||
print titles won't appear on some pages | Excel Discussion (Misc queries) | |||
print 1 long row(20 columns) in excel to one single page | Excel Worksheet Functions |