Greetings.
I'm trying to do a spreadsheet where a single cell scrolls down with me.
I've created an example which I am attaching.
There what I want is the highlighted cell G16 to scroll down with the sheet, but not its row or column, I only want that single cell to be locked in position.
Is it possible? If not, is there a workaround where I could achieve something similar. I do not want row freeze nor column freeze, that doens't works since I need the column where it is writen to stay put.
Freeze SINGLE cell
Re: Freeze SINGLE cell
Sorry! Funny Idea! That cannot work.
Create an empty first row (or use the existing first row for the purpose) and fix it.
Mirror the one cell of interest (G16 in your case) in a still unused cell of the first row (G1 e.g. in your case).
You may use the formulain G1 for the purpose. You will also want to set the same cell format ('Numbers' format e.g.) for G1 as you have in G16.
(Generally: Sheets with formulas and highly specialised cells occurring in arbitrary places are of doubtable design. Try to design your sheets in a way that you have all you need in the view anyway. One example: Calculate sums in a fixed row above the values instead of somewhere near the bottom.)
Create an empty first row (or use the existing first row for the purpose) and fix it.
Mirror the one cell of interest (G16 in your case) in a still unused cell of the first row (G1 e.g. in your case).
You may use the formula
Code: Select all
=IF(G16="";"";G16)
(Generally: Sheets with formulas and highly specialised cells occurring in arbitrary places are of doubtable design. Try to design your sheets in a way that you have all you need in the view anyway. One example: Calculate sums in a fixed row above the values instead of somewhere near the bottom.)
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Freeze SINGLE cell
Instead of freezing, you can divide the sheet window by dragging down the black line above the vertical scroll bar and the other line on the right edge of the horizontal scroll bar. Each part of the screen like this has its own scrollbars.
AOO 4.1.7, LibreOffice 6.2.8
Windows 10 64 bits
Windows 10 64 bits
Re: Freeze SINGLE cell
A quick check shows me that the closest option (though still far from what you are asking for), is to place the cursor in cell B2 and then freeze the screen. Doing this will mean that the cell A1 will always be on screen, no matter what row or column you are working in.
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.
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.