Re: [libreoffice-users] CALC: repeat first line to each page

On 3/28/2014 5:11 AM, Rafnews wrote:
> Hi,
>
> i would like to know if there is an option like under MS Excel, to 
> repeat first line or 2 first lines of the document on each printing 
> page (or PDF page) ?
>
> thx.
>
> A.
If you're used to Excel (like I am), this does not seem very intuitive, 
but here's how to do it in LO 4.x:

From the menu, choose "Format", then "Print Ranges", then "Edit". On 
the "Rows to repeat" line, define which rows you want printed on every 
page, such as "$2:$4" (without the quote marks).  As shown in my 
example, the repeating rows don't HAVE TO be the first rows in the 
spreadsheet.  You can set up repeating columns as well, if you wish.  
You do NOT have to set up a Print Range if you don't want to.

Hope this helps,

-- Tim
===========================



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted