Excel - Printing The Same Column Heading On All Pages

 

Overview: When printing a large spreadsheet, it may be useful to display the header row on each page printed.

1. From the top toolbar, click FILE and scroll to PAGE SETUP.
2. Click on the SHEET tab.
3. Under ROWS TO REPEAT AT TOP or COLUMNS TO REPEAT AT LEFT, choose the desired columns and/or rows.
4. Click OK.

Richard G. White
RichardGWhite.com

 

IT Links

Richard's SOP Docs
AnswersThatWork
Computer Performance
DNSstuff
Experts-Exchange
The Hotfix Share
How-To Geek
PCMag
Tek-Tips
What Is My IP?

Windows

Windows IT Pro
Paul Thurrott's SuperSite for Windows
LabMice.net
Annoyances
MCSEWorld
ElderGeek
NT Help
ISAServer.org
JSI Faq
MCPMag
Petri
WindowsNetworking
Group Policy Resource Center
Windows Security
Windows Secrets

Exchange

The Exchange Information Store
The Exchange Information Store Blog
Slipstick.com
Outlook Exchange
MSExchange.org
Exchange Admin
Jim McBee's Mostly Exchange Web Log
MS Exchange Blog

Security, Antivirus and Spyware

Symantec
Trendmicro
MSExchange.org Antispam
CERT
SecurityFocus

Web

W3 Schools
Macromedia
ASP.net
asp101
World Wide Web Consortium
CSS Vault
HTMLhelp
StopDesign
BigNoseBird.Com
Dreamweaver FAQ
A List Apart

IT Blogs

PatchAholic...The WSUS Blog!
Microsoft Most Valuable Professional Blogs

Tech News

CNET
ZDNet

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Richard G. White, 2007