Forum Discussion
Check boxes aligned on Excel worksheet but not when printing...
DianeDennis Fair enough, but perhaps you get my point, being that you start every section that needs to have a check-box (or bordered cell) on its own row.
Is this maybe a question for support?
DianeDennis Difficult to judge from pictures alone. Can you upload your workbook? Delete any private and confidential information though.
DianeDennis Opened your file on both a Mac and a PC. On both machines it didn't look nice at all. The check-boxes were not aligned. Even if they had been properly aligned in the sheet, I would not have been surprised that they don't line up in a printed version.
You have a text in C9 (2259 characters) in one merged cell spanning 8 columns and 15 rows. Then cell B13 is merged over 10 rows and you have "spaced" the numbers by using multiple line feeds, with text-boxes floating on top. Merged cells can give rise to all sorts of nasty problem. Perhaps the alignment issue is caused bit that.
Why not redesign the schedule. Cut up your text in smaller bits and place them on the regular grid, avoiding merged cells.
Riny_van_Eekelen Hi!
Ooh boy, that shot so high over my head radar picked it up. ;o) I think I need to find some good training videos lol.Would you be able to explain further your final paragraph?
What is the "regular" grid? When I "view grid" it's the lines of the spreadsheet I'm seeing, as opposed to some other grid.
And this: "Cut up your text in smaller bits and place them on the regular grid, avoiding merged cells." I don't understand, I'm sorry.
If it's too much to explain, do you by chance know of a good set of videos/training I could watch to give me a better understanding of what you wrote?
Thank you so much for helping me with this!!
Diane
Riny_van_Eekelen Oh! Absolutely! Thank you!! Here you go. 🙂