# Microsoft Excel Printing question

**URL:** <https://boards.straightdope.com/t/microsoft-excel-printing-question/305806>\
**Category:** Factual Questions\
**Created:** [May 27, 2005, 8:23pm UTC](https://boards.straightdope.com/t/microsoft-excel-printing-question/305806 "2005-05-27T20:23:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pullet](https://avatars.discourse-cdn.com/v4/letter/p/edb3f5/32.png) [@Pullet](https://boards.straightdope.com/u/Pullet)\
**Post date:** [May 27, 2005, 8:23pm UTC](https://boards.straightdope.com/t/microsoft-excel-printing-question/305806/1 "2005-05-27T20:23:11Z")

</div>

I have a rather large table in Microsoft Excel. It’s the kind of table where there is a list of stores on the y axis and a list of suppliers along the x axis and a little notation where the a given store intersects with a supplier that they use. Because it will take several pages to print this file in some sort of readable font size, I’d like the list of stores in column A (the y axis) to appear on every printed page. How do I make it do this?

Thanks.

---

<div class="post-metadata">

**Author:** ![larsenmtl](https://avatars.discourse-cdn.com/v4/letter/l/d78d45/32.png) [@larsenmtl](https://boards.straightdope.com/u/larsenmtl)\
**Post date:** [May 27, 2005, 8:36pm UTC](https://boards.straightdope.com/t/microsoft-excel-printing-question/305806/2 "2005-05-27T20:36:49Z")

</div>

File | Page Setup… | Sheet | Print titles | Columns to repeat at left: $A:$A

---

<div class="post-metadata">

**Author:** ![gigi](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@gigi](https://boards.straightdope.com/u/gigi)\
**Post date:** [May 27, 2005, 8:46pm UTC](https://boards.straightdope.com/t/microsoft-excel-printing-question/305806/3 "2005-05-27T20:46:27Z")

</div>

What **larsenmtl** said, but then leave out that column when you set your print area. The same thing can be done if you need to see the first row(s) on every page.

---

<div class="post-metadata">

**Author:** ![Pullet](https://avatars.discourse-cdn.com/v4/letter/p/edb3f5/32.png) [@Pullet](https://boards.straightdope.com/u/Pullet)\
**Post date:** [May 27, 2005, 9:00pm UTC](https://boards.straightdope.com/t/microsoft-excel-printing-question/305806/4 "2005-05-27T21:00:11Z")

</div>

Flippn’ sweet!  
I’m going to show everyone in my department how to do this!

Chicken kisses.