View - split, freeze? Which do I use?

Select cell B2 and select Freeze Panes (first option on the list). This will not affect visibility of the worksheet tabs.

Splitting gives scrollbars on both sides of the divide - freeze panes does not.

Thanks so much!

For my Daylily Plants workbook, I had to select B3 because B2 is merged with B1, while E1 and E2 are separate and I need to see both rows when scrolling. B3 set the row freeze under Row 2 and the column freeze after Column A, which is exactly what I needed.

Try freezing with either B3 or C2 selected (whichever does what you want), or any cell you choose.

The cell you choose determines the number of rows and columns frozen: choosing D4 would mean that columns A to C would be frozen and rows 1 to 3 likewise.

Play with it a bit - you can't break anything!

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.