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.
|