Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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, 13 views)
File Type: png FormattingNotOkay.png (6.1 KB, 13 views)
Reply With Quote
 

Tags
excel 2010, formatting, table



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 08:46 PM.


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