Hello, time for something a bit different.
I recently upgraded from Excel 2002 to Excel 2010 and my old spreadsheets don't print properly anymore - specifically, border lines aren't printed unless they're thick borders. I thought it was a formatting problem that the new version of Excel had trouble with, but it also happens on new spreadsheets that I create with Excel 2010. I've tried "high quality mode for graphics" in advanced options and turning draft quality off in my print settings, but it makes no difference. So when I print out a grid that was created with thin borders, everything looks fine in print preview but it comes out of my printer (an HP Laserjet 2200) as just the text on an otherwise blank page.
What's odd is that, as a test, I created a brand new sheet with a simple grid made up of thin borders. Each column had text in the first row as headers (text size 11) and I printed the page. The thin borders had been printed out. Success, I thought. But when I started adding information to the table and printed that out, I was back to no borders. I had increased the text size whilst maintaining fixed table size. I tried reducing the text size back to 11 and printed out - no borders. I tried clearing the contents the cells to which I'd added information and printed out - no borders. But this point, I'd taken out all the additions since I had a successful print with borders so I thought that it would print with borders again, but it didn't - just an almost blank page.
Like I said at first, it works if I just thicken the border, but it looks ugly then. I really would like to be able to print thin borders.
It's frustrating because I know that my printer can print the thin borders. I've seen it happen. But somewhere along the process, something's going wrong and I can't put my finger on it. Has anyone seen this before?
I recently upgraded from Excel 2002 to Excel 2010 and my old spreadsheets don't print properly anymore - specifically, border lines aren't printed unless they're thick borders. I thought it was a formatting problem that the new version of Excel had trouble with, but it also happens on new spreadsheets that I create with Excel 2010. I've tried "high quality mode for graphics" in advanced options and turning draft quality off in my print settings, but it makes no difference. So when I print out a grid that was created with thin borders, everything looks fine in print preview but it comes out of my printer (an HP Laserjet 2200) as just the text on an otherwise blank page.
What's odd is that, as a test, I created a brand new sheet with a simple grid made up of thin borders. Each column had text in the first row as headers (text size 11) and I printed the page. The thin borders had been printed out. Success, I thought. But when I started adding information to the table and printed that out, I was back to no borders. I had increased the text size whilst maintaining fixed table size. I tried reducing the text size back to 11 and printed out - no borders. I tried clearing the contents the cells to which I'd added information and printed out - no borders. But this point, I'd taken out all the additions since I had a successful print with borders so I thought that it would print with borders again, but it didn't - just an almost blank page.
Like I said at first, it works if I just thicken the border, but it looks ugly then. I really would like to be able to print thin borders.
It's frustrating because I know that my printer can print the thin borders. I've seen it happen. But somewhere along the process, something's going wrong and I can't put my finger on it. Has anyone seen this before?
