How do I freeze or lock cells to show up on each page without typ.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 4 page sheet. I have a header already. But I want to freeze the
cells that head up the first page. I've done it before in school but can't
remember what it is called or how to do it...that's why I'm doing this.
Anyway, I want these cells to print off on each new page without having to
type them on each page. I hope that makes sense and I hope that someone can
help me!
 
If you mean for printing do file>page setup>sheet and select rows to repeat
at top

otherwise for viewing you can select a2 if the headers start in row 1 and do
window> freeze panes

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"(e-mail address removed)"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel 2007 - How do I print my two row header on each page? 2
how do I freeze my column labels so that they print every page? 1
Xiaomi Redmi Note 10 Pro?? Do or die? 11
Insert automatic page numbering into a cell, not a header or foote 1
how to carry forward a total from one page to another 3
Freeze Pane Saving 10
print freezed pane 4

Back
Top