So… I hope this is a relatively easy excel question.
I want to set up a spreadsheet that the first two columns on the left will scroll to the right as I do. So I can compare the data in columns A and B side by side columns further down the line.
Also the same concept but at the top- I’d like the top two rows (which are used as headers) to scroll down as I a scroll down so that the title of the column is always visible no matter how far down I scroll.
Does that make sense? I had worked with one before that did that but now I have to build my own spreadsheets and have no idea how to employ this function.