Forum Discussion
Print Preview Not Matching Original Document
wingsofElyon sorry I don't have a solution for you. But when I open your workbook the alignment isn't correct on my screen nor in print preview. I don't know how you are creating those circles but the non-bold circles appear to be some form of text code in the cell while the bold circles are shapes added on top of the sheet. If you want alignment, you might have better luck using all shapes (or all characters but guessing you couldn't do the bold that way and hence added the drawing objects) and maybe even group the shapes, but that is just a thought.
- mtarler thank you for your response and your thoughts. Unfortunately I don’t think that’s the case. I started a new document and just typed stuff in and the alignment is off also. All I did was merge some cells and type a list and the list is way off in print preview but aligned in the original. Again I appreciate your thoughts and hope others may have suggestions also.
wingsofElyon I also agree with mathetes that you are not using Excel in the way it is really designed (but then again I do that all the time) and that I would also suggest word or a typeset package like Publisher. I also agree with SergeiBaklan that non-monospaced fonts are going to cause more problems, but even with monospaced fonts the way a page is rendered it will render fonts different than images. So I go back to suggesting you might want to convert everything to objects that you specify the exact location for. You can probably get away with some text for headers and such that don't require specific alignment. Also, I didn't check what fonts you were using to create those circles and such, but you can also run into problems with font libraries that aren't truetype fonts because although the software may scale it one way the printer may step it differently. And you still have the issue that as you open it on different machines, they will be viewed differently (your sheet didn't view right on my computer) and not show right.
Another idea: but first, an observation: you're not really using Excel for the kinds of things that Excel excels in; rather, you're using it more because of its rows and columns, i.e., its layout features. Yet it's precisely its layout that is messing you up.
So my suggestion: use Microsoft Word instead. You can insert a table in Word, where that's appropriate. You can insert graphic features....
If I had been tasked with creating the kind of scoring sheet you're trying to create here, I would have started with Word rather than Excel.... But I might also have gone for more of a complete graphics program. Come to think of it: you could create this as a PowerPoint slide.
mathetes
I stated this in the comment below with an answer given (wondering if it is the same reason) but I wanted to state it here also for you. I was able to get a copy of Microsoft word to work on my computer (2007) and started doing this. It is doing the same exact thing on word.
