First time here? Check out the FAQ!
asked 2012-09-25 14:25:42 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
Hi, excuse my lack of technical vocabulary, I am quite new to spreadsheets and don't even know what terms to use...
Basically I would like to make a spreadsheet with a top row (indicating titles for information in each column) which does not vanish when I scroll down along the document.
Let's say the top row consists of titles at the top of each column indicating types of expenses: food, lodging, transport. And each row below the top row has a different figure for each corresponding column.
I'd like to make it so when i scroll down the spreadsheet the topmost row, the one with the titles FOOD LODGING TRANSPORT remains at the top of the screen, in view, so I can enter new data without having to continually scroll to the top in order to remember what each column represents.
Make sense? I hope so! Any advice appreciated!!!
answered 2012-09-25 14:41:45 +0200Timon
http://wiki.documentfoundation.org/images/6/6d/0300CG3-CalcGuideLibO3.pdf See page 34 Freezing rows and columns. Choose Window - Freeze.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-09-25 14:25:42 +0200
Seen: 358 times
Last updated: Sep 26 '12