Reef Central Online Community - View Single Post - Excel Spreadsheet for Reef Aquarium Logging

crumbletop · 01/20/2006, 05:06 PM

andynyc,

You don't need to split the panes. Just click on the cell that has the stuff above it that you want to remain the same for vertical scrolling, and the stuff to the left of it that you want to remain the same for left right scrolling and then select Window->Freeze Panes.

Jack

01/20/2006, 05:06 PM	#5
crumbletop Registered Member Join Date: Nov 2005 Location: Nashville, TN Posts: 4,718	andynyc, You don't need to split the panes. Just click on the cell that has the stuff above it that you want to remain the same for vertical scrolling, and the stuff to the left of it that you want to remain the same for left right scrolling and then select Window->Freeze Panes. Jack __________________ "Misers get up early in the morning; and burglars, I am informed, get up the night before." - GK Chesterton Current Tank Info: 90 gallon AGA RR. 20 gal sump. 6x54W T5. AquaController Jr.