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

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?


CPU: i7 3770k 3.9GHz | COOLER: Arctic Freezer 34 eSports | GPU: GIGABYTE GTX 1070 G1 Gaming 8GB | MOTHERBOARD: MSI Z77A-G45 GAMING | RAM: G.Skill Trident X 16GB | STORAGE: Crucial M550 SSD 120GB + 2TB HDD + 4TB HDD +4TB HDD | CASE: Cooler Master HAF 912 Plus | PSU: XFX PRO1050W Black Edition (80+ Gold) | KEYBOARD: Corsair Vengeance K70 | MOUSE: Logitech G502 | MOUSEPAD: Marvo MG010 | MONITOR: Philips 298P4 29" UltraWide | SPEAKERS: Microlab Solo7C | HEADSET: Trust GXT 410 Rune Illuminated | OS: WIndows 10 64bit
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


"We're all in this together, might as well be friends" Tom, Toonami.

Sorry if my post seemed rude, that is never my intention.

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

 

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.


CPU: i7 3770k 3.9GHz | COOLER: Arctic Freezer 34 eSports | GPU: GIGABYTE GTX 1070 G1 Gaming 8GB | MOTHERBOARD: MSI Z77A-G45 GAMING | RAM: G.Skill Trident X 16GB | STORAGE: Crucial M550 SSD 120GB + 2TB HDD + 4TB HDD +4TB HDD | CASE: Cooler Master HAF 912 Plus | PSU: XFX PRO1050W Black Edition (80+ Gold) | KEYBOARD: Corsair Vengeance K70 | MOUSE: Logitech G502 | MOUSEPAD: Marvo MG010 | MONITOR: Philips 298P4 29" UltraWide | SPEAKERS: Microlab Solo7C | HEADSET: Trust GXT 410 Rune Illuminated | OS: WIndows 10 64bit
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


×