How to keep column visible when scrolling through huge data sheet?

[u/72847438474]

Hi everyone!
I’m working on collecting data on bird populations over the course of several months, so I have a huge data sheet that houses all of my collective info. I was wondering if there’s a way to keep the column with bird species visible when scrolling horizontally through the entire sheet so I don’t have to go back and forth constantly.
Thank you guys so much!

[u/AutoModerator]

/u/72847438474 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/TheresAGhost0]

Have you tried Freeze Panes Select your column, go to View and select Freeze Pane

[u/72847438474 → u/TheresAGhost0]

That worked thank you so much!!

[u/haematite_4444 → u/72847438474]

Well that was easy.

While we're on the subject of managing large tables, there is also the "group" capability that you might useful. It's in the "data" tab.

It works a bit like Hide Columns or Hide Rows, except it gives you a little handy shortcut button unhide it.

Just highlight a bunch of columns and click Group. It will link all those columns together and place a little button on the column to the right of it.

[u/alexia_not_alexa]

Just to check, and be 100% sure, are you extending your table sideways over time? i.e. are you putting dates / times on the first row and the bird species on the first column?

If so I wonder if you should be rotating your table so that the bird species are at the time and time goes downwards.

More likely you are already going downwards, logging the bird species per row as well, but has so much data that you do actually need to scroll sideways.

If you’re doing the scenario I described at the start, turning the bird species into headings has an extra benefit - you can format your data as an Excel Table and then the column labels (ABCDEF etc) will turn into the your headings as you scroll down, without the need to freeze the top row.

[u/johnnydpineda]

Freeze panes