1
00:00:00,080 --> 00:00:03,505
You scroll down an order tracker and can no longer tell

2
00:00:03,505 --> 00:00:05,373
which column holds owner or status.

3
00:00:05,373 --> 00:00:09,733
Excel can keep a header row visible while the rest of the sheet moves.

4
00:00:09,733 --> 00:00:13,469
We will use a forty-order fictional workbook, freeze only row one,

5
00:00:13,469 --> 00:00:16,583
scroll to row thirty-five, and then reverse the setting.

6
00:00:16,583 --> 00:00:19,697
This is a screen-view aid, not a print setting.

7
00:00:20,297 --> 00:00:25,152
The practice file has forty orders and three columns: Order ID, Owner, and Status.

8
00:00:25,152 --> 00:00:27,580
Open it in Excel for the web.

9
00:00:27,580 --> 00:00:31,395
Verify row one contains those exact labels, then scroll down until

10
00:00:31,395 --> 00:00:33,129
the header leaves the screen.

11
00:00:33,129 --> 00:00:37,984
At row thirty-five, the record is H zero-three-four, because the first

12
00:00:37,984 --> 00:00:39,718
worksheet row is the header.

13
00:00:39,718 --> 00:00:44,574
This confirms the list is long enough for a real before-and-after check.

14
00:00:45,174 --> 00:00:48,878
The tested English Excel web menu has a direct Top Row

15
00:00:48,878 --> 00:00:52,918
option, so the selected cell does not decide which row is frozen.

16
00:00:52,918 --> 00:00:56,622
If your version only offers a generic Freeze Panes command, click

17
00:00:56,622 --> 00:01:00,326
A two first: row one is above that cell, and no

18
00:01:00,326 --> 00:01:02,010
column is to its left.

19
00:01:02,010 --> 00:01:06,387
Selecting B two for the generic command may freeze column A as well.

20
00:01:06,387 --> 00:01:08,407
Keep the distinction clear before clicking.

21
00:01:09,007 --> 00:01:12,988
On the View tab, open Freeze Panes and choose Top Row.

22
00:01:12,988 --> 00:01:16,969
In the tested English Excel web session, the header stayed visible

23
00:01:16,969 --> 00:01:19,865
while the sheet scrolled to row thirty-five.

24
00:01:19,865 --> 00:01:23,846
If your menu instead offers only generic Freeze Panes, select A

25
00:01:23,846 --> 00:01:26,017
two first and use that command.

26
00:01:26,017 --> 00:01:29,998
Confirm Order ID, Owner, and Status remain readable at the top

27
00:01:29,998 --> 00:01:31,446
while records change below.

28
00:01:32,046 --> 00:01:35,043
If the labels stay on screen, the freeze worked.

29
00:01:35,043 --> 00:01:38,707
It does not guarantee row one repeats on every printed page;

30
00:01:38,707 --> 00:01:41,038
that is a separate page-layout feature.

31
00:01:41,038 --> 00:01:44,702
If a column also stays fixed and you did not intend

32
00:01:44,702 --> 00:01:48,365
it, unfreeze and use Top Row directly, or repeat the generic

33
00:01:48,365 --> 00:01:49,697
command from A two.

34
00:01:49,697 --> 00:01:53,361
If no header remains, confirm the correct worksheet and check that

35
00:01:53,361 --> 00:01:55,692
you did not choose Split panes instead.

36
00:01:56,292 --> 00:02:00,418
When you no longer need the fixed row, return to View,

37
00:02:00,418 --> 00:02:02,294
Freeze Panes, and Unfreeze Panes.

38
00:02:02,294 --> 00:02:06,420
Scroll again: the header can now leave the screen, which proves

39
00:02:06,420 --> 00:02:07,920
the setting was reversed.

40
00:02:07,920 --> 00:02:12,046
The practice answer is concrete: the three labels were visible beside

41
00:02:12,046 --> 00:02:16,173
row thirty-five after freezing and no longer pinned after unfreezing.

42
00:02:16,173 --> 00:02:18,423
The underlying order data never changed.