Freeze SINGLE cell

[BronsonGG]

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.

[Lupp]

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 formula

Code: Select all

=IF(G16="";"";G16)

in 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.)

[morchat]

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.

[RusselB]

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.