Donate SIGN UP

Excel - Again!

Avatar Image
Goofy | 12:18 Thu 01st Sep 2016 | Technology
5 Answers
I used to be able to keep my header rows when the sheet was longer than the page.
How do I get them back please?
It's the same with the left hand column - I can't seem to keep that either.
Why do MS make life so difficult!
Gravatar

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by Goofy. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Drag the top of the vertical slide bar to split the window.
Question Author
That's my problem - can't get the slide bar.
can you see how to freeze the panes? go into view and there will be an icon somewhere in the tool bar
Have you unticked (or whatever) the view to see the vertical (and horizontal) slide bars ?
Question Author
Found the freeze panes thanks BUT
I can freeze top row, but not sure how to freeze 2 rows - I seem to get a square blocked off, not a choice.

1 to 5 of 5rss feed

Do you know the answer?

Excel - Again!

Answer Question >>