Post Reply
- Print view
7 posts• Page 1 of 1
- bernieb123
- Posts: 52
- Joined: Sat May 16, 2020 9:13 pm
- Location: Presque Isle, Maine USA
- Quote
Postby bernieb123 »
how to Q in Spreadsheet
Spreadsheet - how to freeze rows & columns in spreadsheet
Already went to view -> rows and columns No freeze option there
Bernie
Last edited by MrProgrammer on Thu Oct 15, 2020 1:56 am, edited 2 times in total.
Reason: Green check and Solved tag added
Bernadette Buddington
Open Office 4.1.7
Windows 10
Top
robleyd
- Moderator
- Posts: 5056
- Joined: Mon Aug 19, 2013 3:47 am
- Location: Murbko, Australia
Re: how to Q spreadsheet freeze
- Quote
Postby robleyd »
From Help - F1:
F1 - Help wrote:Freezing Rows or Columns as Headers
If you have long rows or columns of data that extend beyond the viewable area of the sheet, you can freeze some rows or columns, which allows you to see the frozen columns or rows as you scroll through the rest of the data.
1. Select the row below, or the column to the right of the row or column that you want to be in the frozen region. All rows above, or all columns to the left of the selection are frozen.
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.
2. Choose Window - Freeze.
To deactivate, choose Window - Freeze again.
For more information, search Help for freeze
Last edited by RusselB on Tue Oct 13, 2020 3:08 am, edited 1 time in total.
Reason: Typo corrected
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Top
- bernieb123
- Posts: 52
- Joined: Sat May 16, 2020 9:13 pm
- Location: Presque Isle, Maine USA
Re: how to Q spreadsheet freeze
- Quote
Postby bernieb123 »
Hi David - where is Window-freeze?
Bernadette Buddington
Open Office 4.1.7
Windows 10
Top
RusselB
- Moderator
- Posts: 6646
- Joined: Fri Jan 03, 2014 7:31 am
- Location: Sarnia, ON
Re: how to Q spreadsheet freeze
- Quote
Postby RusselB »
Look in the same row where you found View, and go to the right for 5 items. That should be Window... or at least it is on my system
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Top
robleyd
- Moderator
- Posts: 5056
- Joined: Mon Aug 19, 2013 3:47 am
- Location: Murbko, Australia
Re: how to Q spreadsheet freeze
- Quote
Postby robleyd »
See the screen capture below:
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Top
- bernieb123
- Posts: 52
- Joined: Sat May 16, 2020 9:13 pm
- Location: Presque Isle, Maine USA
Re: how to Q spreadsheet freeze
- Quote
Postby bernieb123 »
thanks, david - solved!
Bernadette Buddington
Open Office 4.1.7
Windows 10
Top
- bernieb123
- Posts: 52
- Joined: Sat May 16, 2020 9:13 pm
- Location: Presque Isle, Maine USA
Re: how to Q spreadsheet freeze
- Quote
Postby bernieb123 »
Thanks David & Russell - Solved
Bernadette Buddington
Open Office 4.1.7
Windows 10
Top
Post Reply
- Print view
7 posts• Page 1 of 1
Return to “Calc”
Jump to
- Getting started
- ↳ Survival guide
- ↳ Beginners
- ↳ Getting Started Guide for 4.x
- ↳ Getting Started Guide for 3.x
- ↳ Install, Setup and Troubleshooting
- ↳ Admin Guide
- ↳ MS Windows
- ↳ Linux
- ↳ Mac OSX
- ↳ LibreOffice
- ↳ Tablets
- ↳ Tutorials
- ↳ Writer
- ↳ Calc
- ↳ Base
- Applications
- ↳ Writer
- ↳ Writer Guide for 4.x
- ↳ Writer Guide for 3.x
- ↳ Writer Tutorials
- ↳ Templates
- ↳ Advanced Uses
- ↳ Calc
- ↳ Calc Guide for 4.x
- ↳ Calc Guide for 3.x
- ↳ Calc Functions
- ↳ Calc Tutorials
- ↳ Impress
- ↳ Impress Guide for 4.x
- ↳ Impress Guide for 3.x
- ↳ Draw
- ↳ Draw Guide for 4.x
- ↳ Draw Guide for 3.x
- ↳ Math
- ↳ Math Guide for 4.x
- ↳ Math Guide for 3.x
- ↳ Math Guide for 3.x
- ↳ Base
- ↳ Base Guide for 4.x
- ↳ Wiki
- ↳ Base Tutorials
- ↳ Forms
- ↳ External Data Sources
- ↳ Reporting
- ↳ Database Examples
- Customizing and Extending
- ↳ Macros and UNO API
- ↳ Basic Guide
- ↳ Code Snippets
- ↳ Extension Repository
- ↳ Macro Repository
- ↳ External Programs
- ↳ Extensions
- ↳ Extensions page
- Community
- ↳ General Discussion
- ↳ Site Feedback
- ↳ Forum Governance
- ↳ User Experience (UX)
- ↳ Announcements
- Business
- ↳ Paid support
- ↳ Consultants Directory