Forum Home
Press F1
Thread ID: 23282	2002-08-12 04:29:00	Excel Floating Lines Possible or not?	Chilling_Silence (9)	Press F1

Post ID	Timestamp	Content	User
70371	2002-08-12 04:29:00	I havwe a freidn who wishes to have the first and last line of her excel spreadsheet "Float" on-screen while editing the spreadsheet, is this possible, even with a plugin? I believe its Excel 2K. Thanks Chilling_Silence	Chilling_Silence (9)
70372	2002-08-12 04:46:00	You can use either Split Window or Freeze panes if thats what you mean to show the last cells.	parry (27)
70373	2002-08-12 04:48:00	How would I go about doing this please?	Chilling_Silence (9)
70374	2002-08-12 09:00:00	Sorry had to shoot to a meeting so made a quick post. To split the screen, select Window-Split. This effectively gives you a duplicate view of the same sheet. Keep the bottom part of the split as you last row so you can always see it. The split can be dragged down or to the left. I think it comes up as a 4 way split, so you can slide to the left to get rid of the vertical split, the move it down near the bottom out of your way so you can still see the last row. Each split has its own scroll bars, so scoll the bottom one down until you see the last row. Freezing panes is slightly different, where only one view of the sheet is shown, but certain rows (you determine where the "freeze"starts) are frozen so when you scroll down (or up depending upon where you froze panes) these rows remain in place. This is especially good for things like header rows where you want to see what you have named the column and dont want to have to scoll up if you happened to be on row 200 to see what the column name is. Select the row underneath the ones you want frozen then select Windows-Freeze panes. cheers Parry	parry (27)
1