Ubuntu
openoffice.org package

Freezing both rows and columns in OO spreadsheet

Asked by L Franko

Hi
I have a spreadsheet that has 2 columns on the left hand side for "date" and "debit/credit proof" that I would like to scroll across the sheet as I make entries. I am able to do this with no problem, however I would also like to freeze a header row that defines my other columns as I move down the sheet. I can only manage to freeze either columns or rows, but not both at the same time. Thank you in advance for helping me.
Lori

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Tony Pursell
Solved:
Last query:
Last reply:
Revision history for this message
Best Tony Pursell (ajpursell) said : 		#1

From the Help:-

"To freeze both horizontally and vertically, select the cell that is below the row and to the right of the column that you want to freeze."

If this answers your question, please mark the problem as solved.

Tony

Revision history for this message
L Franko (lori-ramwools) said : 		#2

Thank you, Tony. Problem solved.

Lori

Revision history for this message
Talha (tsajjad) said : 		#3

thank sbuddy