SOLVED

Check boxes aligned on Excel worksheet but not when printing...

%3CLINGO-SUB%20id%3D%22lingo-sub-2084395%22%20slang%3D%22en-US%22%3ECheck%20boxes%20aligned%20on%20Excel%20worksheet%20but%20not%20when%20printing...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2084395%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20created%20a%20form%20with%20a%20few%20checkboxes.%20The%20checkboxes%20are%20lined%20up%20when%20looking%20at%20the%20form%20on%20the%20computer%20screen%2C%20but%20when%20printed%20the%20checkboxes%20print%20in%20the%20wrong%20spot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%20image%20is%20where%20they%20should%20be%2C%20the%20second%20image%20is%20where%20they're%20ending%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%2C%20please%20oh%20please%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much!%3C%2FP%3E%3CP%3EDiane%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2084395%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089054%22%20slang%3D%22en-US%22%3ERe%3A%20Check%20boxes%20aligned%20on%20Excel%20worksheet%20but%20not%20when%20printing...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089054%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20this%20maybe%20a%20question%20for%20support%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089215%22%20slang%3D%22en-US%22%3ERe%3A%20Check%20boxes%20aligned%20on%20Excel%20worksheet%20but%20not%20when%20printing...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089215%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F904430%22%20target%3D%22_blank%22%3E%40DianeDennis%3C%2FA%3E%26nbsp%3BDifficult%20to%20judge%20from%20pictures%20alone.%20Can%20you%20upload%20your%20workbook%3F%20Delete%20any%20private%20and%20confidential%20information%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi!

 

I've created a form with a few checkboxes. The checkboxes are lined up when looking at the form on the computer screen, but when printed the checkboxes print in the wrong spot.

 

The first image is where they should be, the second image is where they're ending up.

 

Can anyone help me, please oh please?

 

Thank you so much!

Diane

12 Replies

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.

@Riny_van_Eekelen Oh! Absolutely! Thank you!! Here you go.  

@Riny_van_Eekelen Hi All!

 

Should I go ahead and contact support about this?

 

Thank you again!!

Diane

@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

@DianeDennis Sorry for being unclear. Let me ask first if the lay-out you have now is important? The table on the right hand side doesn't seem to line-up with the text column on the left. Could you, for instance, have the text in the top potion of the schedule and the table below it?

@DianeDennis Attached and example for you to judge. When I print Sheet2 to a PDF, the check-boxes neatly line up with the corresponding rows in the Excel file. Now, I must admit that I sinned by using merged cells. Sorry, but I tried to keep it to a minimum.

@Riny_van_Eekelen Hi!

 

Please, no apology needed! Thank you.

 

Unfortunately yes it's required that it be laid out the way it is. Well, it's not required per se but there's a perception amongst users, that will never be changed, that it is the required layout so I'm forced to follow it.

 

In the past I eventually gave up on the checkboxes and just used the grid itself to make small boxes that people could put an X inside. I'm wondering if I may have to go that route again.

 

Thank you again!!

Diane

@Riny_van_Eekelen It's nice! I wish I could get away with switching it up.

Best Response confirmed by DianeDennis (Occasional Contributor)
Solution

@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.

@Riny_van_Eekelen 

 

lol, actually I didn't get your point until you spelled it out. Thank you! Some things my brain just refuses to comprehend.

 

Thank you for figuring it out for me!

Diane