Forum Discussion
Check boxes aligned on Excel worksheet but not when printing...
- Jan 29, 2021
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?
- Riny_van_EekelenJan 23, 2021Platinum Contributor
DianeDennis Difficult to judge from pictures alone. Can you upload your workbook? Delete any private and confidential information though.
- DianeDennisJan 29, 2021Brass Contributor
- Riny_van_EekelenJan 29, 2021Platinum Contributor
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.
- DianeDennisJan 23, 2021Brass Contributor
Riny_van_Eekelen Oh! Absolutely! Thank you!! Here you go. 🙂