New Sticky Note

The new user interface is in preview!

Want to check it out? Click here! (If you don't like it, you can still switch back)

The draft is underway!

Click here to go to your war room, or visit the war room item in the draft menu.

League Forums

Main - Community Help Forum

Re: Excel spreadsheet experts

By martinwarnett
6/27/2024 8:08 am
Ok, use LibreOffice but would like any help ;)

I have a lot of data in a spreadsheet, refers to an entity represented by columns A and B.

As I scroll across, columns A and B obviously scroll off.

Is there any way to "pin" columns so that they are always visible?

EDIT:

AH, been informed to "freeze" columns in libre office calc, right click on the column header of the first column AFTER the columns you want frozen, then select "Freeze Rows and Columns"
Last edited at 6/27/2024 8:17 am