Talk

Advanced search

Excel geeks: I need you...

(3 Posts)
LupusinaLlamasuit Wed 08-Jul-09 13:32:31

Got a looong Gantt chart thingy in Excel(think landscape style but about 3 A4 pages long)

Need to convert this to an attachment that can be easily printed and readable. Thinking 3 pages of PDFs.

But how best? Leave it in landscape format? Transpose and have it in portrait? Or will this not make a difference?

Can I freeze panes to print, so if it does end up as 3 pages will include headings etc?

Any other suggestions

LupusinaLlamasuit Wed 08-Jul-09 13:36:27

ACtually I may have worked it out (doh!) - I was overcomplicating.

Now I just need to work out how to print the cell notes as well as main content...

MadreInglese Wed 08-Jul-09 13:39:54

You need to be in page setup

Orientation - landscape

Scaling - fit to <leave blank> pages wide and <1> tall

Header - whatever you add in here will appear as the title on each page

Sheet/Print titles - in 'columns to repeat at left' click on the little wizard button, it will take you back to your worksheet and you just highlight the far left column(s), and they will then appear on each sheet

Then just print to pdf

Hope that makes sense hmm

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now