1
00:00:00,080 --> 00:00:02,948
A long Google Sheet prints across several pages.

2
00:00:02,948 --> 00:00:06,892
Page one explains the columns, but page two begins with values

3
00:00:06,892 --> 00:00:10,836
and no header, forcing readers to guess what each number means.

4
00:00:10,836 --> 00:00:14,063
Google Sheets can repeat frozen rows in print output.

5
00:00:14,063 --> 00:00:18,365
We will freeze a fictional order-list header, turn on the print

6
00:00:18,365 --> 00:00:22,309
option, and inspect page two rather than assuming the setting worked.

7
00:00:22,909 --> 00:00:25,350
Open a copy of the practice CSV.

8
00:00:25,350 --> 00:00:29,186
It contains one header row and 120 unique fictional order IDs,

9
00:00:29,186 --> 00:00:32,324
from SO zero forty-one to SO one sixty.

10
00:00:32,324 --> 00:00:36,159
The video shows only the first three rows as an excerpt.

11
00:00:36,159 --> 00:00:40,343
In print preview, choose Normal one-hundred-percent scale or Fit to

12
00:00:40,343 --> 00:00:44,179
width rather than Fit to page, and confirm at least two

13
00:00:44,179 --> 00:00:46,271
pages before testing the repeated header.

14
00:00:46,871 --> 00:00:50,759
In Google Sheets, open View, then Freeze, and choose one row.

15
00:00:50,759 --> 00:00:54,295
The header remains visible while you scroll the editing view.

16
00:00:54,295 --> 00:00:57,830
This also establishes which row the print setting will repeat.

17
00:00:57,830 --> 00:01:02,072
If your document has a multi-row header, freeze the correct number

18
00:01:02,072 --> 00:01:04,901
of rows, but avoid freezing data rows accidentally.

19
00:01:04,901 --> 00:01:08,436
Scroll once to confirm the labels stay at the top.

20
00:01:09,036 --> 00:01:10,548
Open File and Print.

21
00:01:10,548 --> 00:01:15,462
In the print settings sidebar, expand Headers & footers and select Repeat frozen rows.

22
00:01:15,462 --> 00:01:19,619
The setting refers to the rows you froze in the Sheet,

23
00:01:19,619 --> 00:01:23,021
so make sure that freeze step is correct first.

24
00:01:23,021 --> 00:01:26,423
Preview the result before exporting a PDF or printing.

25
00:01:26,423 --> 00:01:31,337
Do not confuse this option with repeating a title inside the document itself.

26
00:01:31,937 --> 00:01:34,731
Move to the second page in print preview.

27
00:01:34,731 --> 00:01:39,621
Its top should show Order ID, Owner, and Amount before any fictional order values.

28
00:01:39,621 --> 00:01:43,462
Then inspect the first data row on that page: it should

29
00:01:43,462 --> 00:01:47,654
continue the list without a manually copied header embedded in the sheet.

30
00:01:47,654 --> 00:01:51,496
If the labels are missing, return to the freeze setting and

31
00:01:51,496 --> 00:01:53,242
the Repeat frozen rows checkbox.

32
00:01:53,842 --> 00:01:57,697
Typing the same header again halfway through the sheet is fragile.

33
00:01:57,697 --> 00:02:01,552
It can be sorted as though it were a data row

34
00:02:01,552 --> 00:02:05,407
and may appear at the wrong location when page breaks change.

35
00:02:05,407 --> 00:02:09,612
The repeat-frozen-rows print feature renders the existing header on each

36
00:02:09,612 --> 00:02:12,065
printed page without altering your table data.

37
00:02:12,065 --> 00:02:15,569
Keep a single source header and verify pagination in preview.

38
00:02:16,169 --> 00:02:20,166
The exercise is complete only when preview shows at least two

39
00:02:20,166 --> 00:02:25,253
pages and page two begins with the same three column labels as page one.

40
00:02:25,253 --> 00:02:27,796
The answer file documents that visible check.

41
00:02:27,796 --> 00:02:31,793
If a change in paper size, scaling, or margins moves the

42
00:02:31,793 --> 00:02:35,426
page break, inspect the preview again before sharing the PDF.

43
00:02:35,426 --> 00:02:39,423
The exact break position is less important than the repeated header.