|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Developer ribbon
Design Mode Right click the check box Format Control Properties tab Move but don't size with cells |
#3
|
|||
|
|||
Thank you. That worked great.
|
Tags |
excel 2010, formatting, table |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using check boxes and moving to start of document | unwanted | Word VBA | 3 | 05-31-2016 09:15 PM |
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 |