Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2018, 07:42 AM
PatrickYork PatrickYork is offline How do I stop check boxes moving rows when text wraps in an adjacent cell? Windows XP How do I stop check boxes moving rows when text wraps in an adjacent cell? Office 2007
Novice
How do I stop check boxes moving rows when text wraps in an adjacent cell?
 
Join Date: Feb 2010
Posts: 6
PatrickYork is on a distinguished road
Question How do I stop check boxes moving rows when text wraps in an adjacent cell?

I have an Excel 2010 spreadsheet in which I have created a table, using one of the inbuilt Format as Table options.



In each row, I have a single-line text cell, a cell that displays a progress bar, a cell that displays a checkbox, and a text cell that wraps over multiple lines. Initially, the formatting looks fine (as shown in the first attached image).

The problem comes when the wrapping text cell accepts text that causes it to increase its height. This causes the checkbox from the row below to 'jump' into the row with the multi-line text (second image attachment).

As you can see, the progress bar also starts to look a bit rubbish, but I can live with that for now.

Does anyone know how I can get the checkboxes to stay anchored in the cell I put them in, and, ideally get them to keep the same size they have initially?

Any help would be very much appreciated.
Attached Images
File Type: png FormattingOkay.png (6.1 KB, 11 views)
File Type: png FormattingNotOkay.png (6.1 KB, 11 views)
Reply With Quote
  #2  
Old 04-04-2018, 08:59 AM
NoSparks NoSparks is offline How do I stop check boxes moving rows when text wraps in an adjacent cell? Windows 7 64bit How do I stop check boxes moving rows when text wraps in an adjacent cell? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 821
NoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the rough
Default

Developer ribbon
Design Mode
Right click the check box
Format Control
Properties tab
Move but don't size with cells
Reply With Quote
  #3  
Old 04-04-2018, 11:23 AM
PatrickYork PatrickYork is offline How do I stop check boxes moving rows when text wraps in an adjacent cell? Windows XP How do I stop check boxes moving rows when text wraps in an adjacent cell? Office 2007
Novice
How do I stop check boxes moving rows when text wraps in an adjacent cell?
 
Join Date: Feb 2010
Posts: 6
PatrickYork is on a distinguished road
Default

Quote:
Originally Posted by NoSparks View Post
Developer ribbon
Design Mode
Right click the check box
Format Control
Properties tab
Move but don't size with cells
Thank you. That worked great.
Reply With Quote
Reply

Tags
excel 2010, formatting, table

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I stop check boxes moving rows when text wraps in an adjacent cell? Using check boxes and moving to start of document unwanted Word VBA 3 05-31-2016 09:15 PM
How do I stop check boxes moving rows when text wraps in an adjacent cell? Vertical align to bottom of cell when row wraps to next page lausianne Word Tables 3 02-28-2014 05:20 PM
Word2010 check boxes and plain text content control boxes in same table fcsungard Word 5 06-01-2012 01:16 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM
Problem with Developer Form -- Check Boxes and Text Boxes PCC Word 1 05-16-2009 05:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft