Ask Your Question

easy way to put checkboxes at the same position in a cell

asked 2017-10-27 23:28:19 +0200

kerwyn gravatar image

updated 2017-10-28 09:19:43 +0200

I'm using a spreadsheet wherein I use a list of things, each with a checkbox. I want to position these checkboxes at the exact same spot as the one before, so that this becomes a tidy list.

I used the menu to position my checkboxes, but this is very hard. The position I chose often changes, even after anchoring within the cell and protecting the postion.

Is there an easy way to align them?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-10-28 01:12:44 +0200

Ratslinger gravatar image


You can use the Align tool on the Form Design toolbar:

image description

This only took a couple of minutes. First placed checkbox in A1. Then right clicked checkbox to copy & pasted in A2 - A4 not caring about position (they were pasted to far left of cell). With A1 checkbox in wanted position, selected all checkboxes (hold down Shift & left click each checkbox). Then use Align tool to align the left or right edge.

edit flag offensive delete link more


Hi, thank you for your answer! I followed your steps, but the align tool is greyed out when i select the cells...

kerwyn gravatar imagekerwyn ( 2017-11-02 20:31:15 +0200 )edit

You must be in Design Mode for the form (it's a selection on the toolbar). You'll also notice, the answer states to select the checkbox, not a cell. You are aligning controls within cells.

Ratslinger gravatar imageRatslinger ( 2017-11-02 20:39:43 +0200 )edit

Hi, I tried this in Design mode but the align tool is still greyed out. I even made sure it was included in the Design toolbar. Any other ideas? Thanks!

evarino gravatar imageevarino ( 2019-02-04 21:37:39 +0200 )edit

The Align tool does not become enabled until multiple objects are selected. You select multiple by clicking each wanted object with the left mouse button while holding down the Shift key.

Ratslinger gravatar imageRatslinger ( 2019-02-05 03:33:11 +0200 )edit

Thank you, R. I was able to use the Align tool this way, but the checkboxes won't center. I finally gave up on this and I'm just using X's in the spaces.

evarino gravatar imageevarino ( 2019-02-05 03:37:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-27 23:28:19 +0200

Seen: 982 times

Last updated: Oct 28 '17