|
Home > Archive > General Discussion > March 2003 > Q. to anybody who knows excel
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Q. to anybody who knows excel
|
|
| pepe le pew 2003-03-28, 11:16 pm |
| I'm not so sure I can ask this question properly, but here it goes...
If you're scrolling through a worksheet horizontally and for example, you put some kind of block in between column "C". When you scroll right to the succeeding columns it seems to slide under columns A, b, and C. I don't know what it's called and how to do that. I hope someone in here understands what I wanted to ask.
Anyway, thanks for the replies, if there's any.
--pepe | |
| Redstar 2003-03-28, 11:51 pm |
| So, you’re trying to slide Column C under A and B, is that what I'm reading? Or is it a block you’re sliding under A B and C? What kind of block? You lost me somewhere in there  | |
| TekGal 2003-03-29, 5:25 am |
| I got ya pepe le pew - you want (or don't want) frozen panes (or a vertical line between two columns that remains stationery).
Click the column header to the right of where you want the frozen pane (vertical line). Then click "Window" then "Freeze Panes". For example:
If you want A and B columns to stay frozen and the remaining ones to "slide" underneath A and B as you scroll to the right, then click the "C" column header to select the entire column, then hit Window/Freeze Panes.
If you want to remove the frozen pane, just do the same and click Window/Unfreeze Panes.
The exact same thing works if you want a horizontal line, or rows, to remain frozen. Only click the Row header instead.
Hope that helps.  | |
| BlokWatch 2003-03-29, 9:48 am |
| Exactly, an almost invaluable feature too. | |
| enforcer 2003-03-29, 5:13 pm |
| you got it tekgal, that's what i was thinking he was asking |
|
|
|
|