As you have come to this site, probably you have just experienced this: Your worksheet spreads over more than one printed page and you want to set rows and columns to repeat. That way, the header row or column will be printed on each page. Large tables are much easier to read. But now you see… Continue reading Can’t select rows / columns to repeat when printing? Easy fix!
Admittedly – it can be a nightmare: Printing Excel sheets. You permanently feel like Excel hates you when you want to print an Excel sheet. That said, let’s take a look at the basics (like defining the print range) as well as advanced topics (like changing headers and footers on several sheets simultaneously).
Formatting an Excel table for printing is usually troublesome. You have to adapt the print area, select rows and columns to repeat and set the header and footer. In this Excel Tip, we’ll have a look at setting headers and footers.