Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
jason938

Need some help in Google spreadsheets

View > Freeze > choose what you want.

image.png.cef4e2d63c6ded3c7c8cfc4c4d9b2f36.png

 

Row is horizontal (so it will stick at the top) column is vertical (so will stay on the side)

 

EDIT:

P.S. please make sure you have this spreadsheet set to share and view, not edit. Right now people could edit your spreadsheet with that link.

image.png.972bb4375b1bb16c38f8c4171ffc8bd3.png

Recommended Posts

Posted · Original PosterOP

Hi,

I noticed that it's possible in Google spreadsheets to lock some cells/range so that when you scroll down those cells still remain. For example here. If you scroll down, that upper menu still remains.

I also have similar spreadsheet & want to make my menu also sticky like that. How do I do that?

Link to post
Share on other sites
Posted · Best Answer

View > Freeze > choose what you want.

image.png.cef4e2d63c6ded3c7c8cfc4c4d9b2f36.png

 

Row is horizontal (so it will stick at the top) column is vertical (so will stay on the side)

 

EDIT:

P.S. please make sure you have this spreadsheet set to share and view, not edit. Right now people could edit your spreadsheet with that link.

image.png.972bb4375b1bb16c38f8c4171ffc8bd3.png


I apologize for the way I am. If my post seemed rude, that was not my intention. Just my ineptness in forming a nice coherent message.

"Why do we suffer a lifetime for a moment of happiness?" - Anonymous

"FuryBSD, name of your sex tape" - Alex Clark

"How long do I have to keep going on? Someone end it already"

Link to post
Share on other sites
Posted · Original PosterOP
12 hours ago, minibois said:

View > Freeze > choose what you want.

image.png.cef4e2d63c6ded3c7c8cfc4c4d9b2f36.png

 

Row is horizontal (so it will stick at the stick) column is vertical (so will stay on the side)

 

EDIT:

P.S. please make sure you have this spreadsheet set to share and view, not edit. Right now people could edit your spreadsheet with that link.

image.png.972bb4375b1bb16c38f8c4171ffc8bd3.png

Thank you very much. That feature is very helpful.

P.S.I have set it for others to edit this document on purpose :), but thx.

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×