Repeat Spreadsheet Column Headings at Top of Subsequent Pages

[prezlyn]

Hello,

I want to repeat spreadsheet headings at the top of every page. However, I am getting the "Print titles must be contiguous and complete rows or columns." I have tried the following: Page Layout - > Print Titles ->Sheet : Cell errors as : chose <blank> to no avail. Any suggestions?

Thank you,
Cristine

 

[Mister H]

Hi Cristine

If I am understanding correctly then you need to go into Page Setup



Hopefully the image shows. Goto Page Layout and click the little triangle box in the bottom right corner of the Page Layout Tab. Select Sheet and then Rows To Repeat...

If you need further help just ask

 

[prezlyn]

Hi Cristine

If I am understanding correctly then you need to go into Page Setup



Hopefully the image shows. Goto Page Layout and click the little triangle box in the bottom right corner of the Page Layout Tab. Select Sheet and then Rows To Repeat...

If you need further help just ask

Hello Mister H.,

I have done that and I am still getting the "Print titles must be contiguous and complete rows or columns" error message.

. I am trying to insert and image, not certain if you can the snapshot to see what I am talking about. I am lost as to what the issue is.


Any other suggestions as to what the issue might be?

Sincerely,
Cristine

 

[prezlyn]

https://photos.google.com/photo/AF1QipMl6miCl9kTcJAJO9GynG0-n0YN28U7Xr-Tnfak

 

[Fluff]

The link you've posted is not working. It comes back with

404. <ins>That’s an error.</ins>

The requested URL was not found on this server. <ins>That’s all we know.</ins>

But from the error message you're getting it sounds as if you are not selecting an entire row, but rather a number of different cells.

 

[prezlyn]

The link you've posted is not working. It comes back with
But from the error message you're getting it sounds as if you are not selecting an entire row, but rather a number of different cells.

I am selecting the entire row. I select from the left starting with the #1 . Also, how can I send you an image of what I am talking about? I tried to attach an image 2 different ways and neither one is working. I just tried the clicking the link that I sent you and it is working for me. Not sure why there is an error message?

 

[Fluff]

Did you mark the image for sharing?

 

[prezlyn]

https://drive.google.com/file/d/118X1yzySJyiGKNcu2ArDgYoef4k7YDd2Dw/view?usp=sharing

 

[prezlyn]

https://drive.google.com/file/d/118X1yzySJyiGKNcu2ArDgYoef4k7YDd2Dw/view?usp=sharing

I want to repeat the first 4 rows on each page.

 

[Fluff]

It needs to be
$1:$4