« April 2017 »
Sun Mon Tue Wed Thu Fri Sat
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6

 

Username:
Password:
Excel--Show your top row or column on each page within your worksheet

 



Click here  the more complete directions with screen shots


Directions without screen shots:
Show Column (or Row) on each page on Excel Worksheet
When you have many pages in your excel document, it is hard to remember that first column or row.  This shows you how to show that on each page.

Start with your worksheet

1.    Choose “File”, then “Page Setup”
2. Then go to the “Sheet” tab and click inside “Columns to Repeat at Left”
3. Highlight the column that you want to show on each page
4. The “Columns to Repeat at Left” will fill in
5. Choose “OK”
6. Make sure your view is on “Page Layout” by going to view and choosing page layout
7. Your sheets will  now reflect that column as you fill in data

You can also do this for a row to show on each page by
Step 1:  As above
Step 2:  Click inside “Rows to Repeat at top” instead of Columns
Step 3:  Highlight the row you want to show on each page
Step 4:  The “Rows to Repeat at top: will fill in
Step 5:  Choose “OK”:
Step 6:  Your row will now populate and show on each sheet








Alliance Public Schools cannot be responsible for the content or accuracy of link sites referenced on the school district's web pages. Link sites are not supervised by or within control of the school district. The school district is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement of the site by Alliance Public Schools.

Site Map | Privacy Policy | View "printer-friendly" page | Login   In Japanese  In Korean  En français  Auf Deutsch  In italiano   No português  En español  In Russian  
Site powered by SchoolFusion.com © 2017 - Educational website content management