Checkboxes shifting when opened on smaller laptops vs. larger laptops and monitors

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3164267%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ECheckboxes%20shifting%20when%20opened%20on%20smaller%20laptops%20vs.%20larger%20laptops%20and%20monitors%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3164267%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20have%20been%20working%20on%20a%20semi-complex%20form%20in%20excel.%20The%20form%20includes%20checkboxes%2C%20drop-down%20selection%20lists%2C%20fillable%20fields%2C%20etc...%20I%20use%20a%20Dell%20Precision%2015%20inch%2C%20my%20coworker%20uses%20a%20Dell%20Inspiron%2013%20inch.%20When%20setting%20up%20the%20form%20I%20did%20all%20my%20work%20on%20my%20two%20monitors%2C%20in%20sending%20it%20over%20to%20my%20supervisor%20for%20review%2C%20the%20formatting%20all%20stayed%20the%20same%20and%20looked%20as%20it%20should%20(she%20also%20uses%20monitors).%20The%20coworker%20with%20the%20Inspiron%2013%20inch%20reported%20that%20the%20checkboxes%20are%20shifted%20down%20and%20over%20to%20the%20left%2C%20ruining%20the%20formatting.%20I%20opened%20the%20sheet%20on%20my%20laptop%20to%20see%20if%20the%20issue%20carried%20over%2C%20and%20it%20didn't.%20So%20then%20I%20opened%20it%20on%20my%20personal%20laptop%20(also%20an%20Inspiron%2013%20inch)%2C%20and%20was%20able%20to%20see%20the%20issue%20my%20coworker%20had%20discussed.%20I%20haven't%20heard%20from%20any%20other%20people%20on%20my%20team%20who%20are%20testing%20this%20out%2C%20regarding%20the%20formatting%20issue.%20I%20have%20tried%20several%20solutions%2C%20including%20moving%20the%20form%20to%20my%20personal%20laptop%2C%20fixing%20the%20formatting%2C%20and%20then%20sending%20it%20back%20over%20to%20my%20coworker.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20am%20hoping%20someone%20might%20have%20a%20solution%20to%20prevent%20the%20checkboxes%20from%20shifting%3F%20I%20am%20including%20a%20screen-print%20of%20the%20issued%20(how%20it%20should%20look%2C%20vs%20how%20it%20ends%20up%20looking).%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348130i83DD053080A91E1B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22nrackerman_0-1644860969820.png%22%20alt%3D%22%5C%26quot%3Bnrackerman_0-1644860969820.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348131i3B7166B25D7B5667%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22nrackerman_1-1644860984669.png%22%20alt%3D%22%5C%26quot%3Bnrackerman_1-1644860984669.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3164267%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EDeveloper%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

I have been working on a semi-complex form in excel. The form includes checkboxes, drop-down selection lists, fillable fields, etc... I use a Dell Precision 15 inch, my coworker uses a Dell Inspiron 13 inch. When setting up the form I did all my work on my two monitors, in sending it over to my supervisor for review, the formatting all stayed the same and looked as it should (she also uses monitors). The coworker with the Inspiron 13 inch reported that the checkboxes are shifted down and over to the left, ruining the formatting. I opened the sheet on my laptop to see if the issue carried over, and it didn't. So then I opened it on my personal laptop (also an Inspiron 13 inch), and was able to see the issue my coworker had discussed. I haven't heard from any other people on my team who are testing this out, regarding the formatting issue. I have tried several solutions, including moving the form to my personal laptop, fixing the formatting, and then sending it back over to my coworker.

 

I am hoping someone might have a solution to prevent the checkboxes from shifting? I am including a screen-print of the issued (how it should look, vs how it ends up looking).

 

nrackerman_0-1644860969820.png

nrackerman_1-1644860984669.png

 

 

3 Replies

@nrackerman 

Enable developer tools in advance

 

ALT+F11 VBA opens

Click draft mode

Go to the box with the right mouse button.

Format Control-->Properties tab-->Depend on cell position and size.

 

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE 

 

Thank you for sharing this, I gave it a shot, but sadly no luck. I am still experiencing the issue of the checkboxes shifting over.

@nrackerman 

With your permission, if I may recommend, provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

What I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5

 

Don't forget that not every Excel user has a clue about every job and that what you see he can't see.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)