Printing an Excel file

April 22, 2009 7:30 AM

Excel filter: How do I print a specific column on every printed page without having to physically insert the column to the beginning of every page?

I have an Excel datasheet, with names as column 1, with other information filled in. When I look at my spreadsheet on my computer, I typically "freeze" the 1st column so that I can always see the name as my left-most column. How do I do the same thing when I print the worksheet? For example, if my data runs for 2-3 or more pages, how do I set up the print job so that column 1 with the names will print again as the left most column on page 2, left most column on page 3, etc.?
Thanks!

posted by jujube to computers & internet (3 answers total)

Go to File>Page Setup, then the "Sheet" tab. You can list/select rows and/or columns to repeat on every page there.
posted by Perplexity at 7:33 AM on April 22, 2009

This?
posted by sldownard at 7:33 AM on April 22, 2009

Thanks!!
posted by jujube at 7:41 AM on April 22, 2009