Printing part of an Excel Spread Sheet

  wee eddie 21:17 07 Aug 08
Locked

I have frozen the Top 3 Rows of a Spread Sheet, which allows me to Scroll down the Sheet and still view the Column Titles.

I now wish to Select a dozen or so Rows and print them. No problem. Just select the Print Area.

However, I have been unable to find a way of including the Column Headers without including all the intervening Rows.

I could, of course, Copy the Spread Sheet and just delete all that I do not wish to Print, but there must be a proprietary way of doing this?

  Clapton is God 21:52 07 Aug 08

First hide the "intervening rows" which you don't want to print

  Zaphod 3 03:22 08 Aug 08

Click File, page setup, in the sheet tab there is an option for rows to repeat at top. Click in the multi coloured bit on the right next to the print preview and option buttons. Select your row and you should be fine.

  wee eddie 06:48 08 Aug 08

That's done the trick

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

New Corel ParticleShop plugin now available: 11 new brushes & 6 new brush packs

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…