Set Excel Shape size to cell border
Set Excel Shape size to cell border
Author
Discussion

Mr Pointy

Original Poster:

13,414 posts

189 months

Monday 30th August 2021
quotequote all
Ok, my next numpty question: in Excel can I create a shape that's locked to the cell borders it's covering? When you insert a rectangle it's a free form shape that you can resize but I can't find a way of getting the shape borders to snap to the cell borders. I can merge the cells & apply a fill but that's a pain when making changes.

The particular task I'm looking at is creating rack layouts like this:



Using fixed size shapes instead of filling cells might speed up the design process.

number2

5,241 posts

217 months

Monday 30th August 2021
quotequote all
Insert shape, then right-click on the shape and select properties, then "Move and size with cells", "Move and don't size..." etc.