I work for a small business that uses Excel 2010 for our monthly work schedule. It's laid out like a typical monthly calendar, in landscape mode, with perhaps half an inch of blank space to the sides. (The margins are actually set to zero.) I'm not the one who created this spreadsheet; I inherited it from the previous manager, who in turn got it from her own predecessor.
I'm a bit of a perfectionist and it bugs me that I cannot get the darn thing to center properly when I print it. I also need that blank space on the left-hand side to hand write notes to individual staff. I've gone into the "Margins" menu and checked the boxes to center both vertically and horizontally, and it centers vertically just fine, but it still starts at the far left edge of the page. I have noticed that when unchecking the boxes to center the cells, the print preview scoots the tiniest bit further up and left. The preview and the printed version are exactly the same whether or not I set a print area.
I don't believe the problem is a simple user error because I'm using a separate spreadsheet, one which I did create myself from scratch, and it centers on the page just fine. I'm really not willing or talented enough to create an entire new schedule from scratch, and besides that, it has the entire year already filled in, including past months.
Thanks for any help you can give.
Bookmarks