How do I get Excel to automatically repeat headings

%3CLINGO-SUB%20id%3D%22lingo-sub-1133379%22%20slang%3D%22en-US%22%3EHow%20do%20I%20get%20Excel%20to%20automatically%20repeat%20headings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1133379%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20complex%20spreadsheet%20and%20as%20I%20go%20down%20the%20page%2C%20I%20lose%20the%20headings%20%26amp%3B%20keep%20having%20to%20go%20up%20to%20the%20top%20of%20the%20page%20to%20see%20which%20column%20is%20which.%26nbsp%3B%20There%20used%20to%20be%20a%20way%20to%20have%20excel%20automatically%20repeat%20headings%2C%20so%20the%20spreadsheet%20scrolls%20down%20under%20the%20heading%20and%20the%20heading%20is%20always%20on%20the%20screen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20a%20bit%20rusty%20with%20Excel%20and%20now%20needing%20to%20do%20far%20more%20complex%20things%20with%20it%20and%20I'd%20love%20to%20know%20how%20to%20do%20this.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20can%20you%20create%20a%20calendar%20with%20information%20created%20from%20%3CSPAN%3Ea%20spreadsheet%20that%20includes%20formulated%20dates%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1133379%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1133463%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20get%20Excel%20to%20automatically%20repeat%20headings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1133463%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F536068%22%20target%3D%22_blank%22%3E%40Albanbelle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Page%20Setup%20you%20may%20define%20what%20to%20repeat%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20536px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167719i15C9AD7C186ABC06%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAs%20for%20the%20calendar%20that's%20bit%20abstract%20question%20and%20better%20to%20ask%20it%20with%20separate%20conversation.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1133824%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20get%20Excel%20to%20automatically%20repeat%20headings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1133824%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F536068%22%20target%3D%22_blank%22%3E%40Albanbelle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assume%20you're%20talking%20about%20the%20live%20spreadsheet.%20Sergei's%20answer%20dealt%20with%20the%20way%20to%20do%20this%20when%20printing.%20In%20the%20live%20spreadsheet%2C%20on%20the%20View%20toolbar%20you'll%20see%20some%20tools%20to%20freeze%20top%20row%20or%20first%20column.%20It%20sounds%20like%20that's%20what%20you're%20looking%20for.%20On%20the%20top%20menu%20bar%2C%20it's%20available%20under%20Window%3C%2FP%3E%3CP%3Eas%20shown%20below%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167766i3BA75BE228A70EE7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167767iAE232AA886E28673%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a large complex spreadsheet and as I go down the page, I lose the headings & keep having to go up to the top of the page to see which column is which.  There used to be a way to have excel automatically repeat headings, so the spreadsheet scrolls down under the heading and the heading is always on the screen.

 

I'm a bit rusty with Excel and now needing to do far more complex things with it and I'd love to know how to do this.  

 

Also can you create a calendar with information created from a spreadsheet that includes formulated dates?

4 Replies

@Albanbelle 

In Page Setup you may define what to repeat

image.png

As for the calendar that's bit abstract question and better to ask it with separate conversation.

@Albanbelle 

 

I assume you're talking about the live spreadsheet. Sergei's answer dealt with the way to do this when printing. In the live spreadsheet, on the View toolbar you'll see some tools to freeze top row or first column. It sounds like that's what you're looking for. On the top menu bar, it's available under Window

as shown below

clipboard_image_0.png

 

clipboard_image_1.png

Would be nice to know where the Page Setup is?

@Sergei Baklan 

@Terry199 

If Windows

here

image.png

or 

image.png