With a small change in the macro, you can modify it so that it will create text boxes that are just as large as whatever range of cells you have selected: The following macro will create a text box directly over the selected cell, and size it to be exactly the same size as the selected cell: If you have many, many such text boxes to create, on lots of different workbooks, you can create the desired text boxes using a macro. Just choose Draw (on the Drawing toolbar) | Snap | To Grid. If you need to create quite a few of these text boxes, all at one time, you can turn the snap-to-gird feature on permanently. The result is a text box that is exactly the desired size. When you hold down the Alt key, it forces Excel to "snap" the sides of your text box to a drawing grid which just happens to match the cell boundaries in your worksheet.
To position shapes or objects to the closest intersection of the grid, click Snap to Grid. You might have to double-click the shape or object to open the Formattab. If you do not see the Drawing Toolsor Formattabs, make sure that you selected a shape or an object. Under Drawing Toolson the Formattab, in the Arrangegroup, click Align. To enable it, head over to the Page Layout tab -> Align and choose Snap to Grid. The gray highlighting indicating the option is selected turns off.Ĭlick the shape or object in the worksheet. Snap to Grid will help you place and resize the shapes easily. To turn off these options, click Snap to Gridor Snap to Shape. To snap shapes or other objects to grid lines that go through the vertical and horizontal edges of other shapes or objects, click Snap to Shape.Ĭlick the shape or other object, and then on the Shape Formattab, in the Arrangegroup, click Align. Gray highlighting indicating the option is selected turns on. To turn on or turn off both Snap to Grid and Snap to Shape, on the Page Layout tab, in the Arrange group, in the Align dropdown list, click the Snap to. Snap to Shape provides the same behavior, except shapes are snapped to the edges of other shapes. To snap shapes or other objects to the closest intersection of the grid, click Snap to Grid. When Snap to Grid is turned on, the edges of the shape will 'snap' to the nearest grid line. Turn on the snap-to optionsĬlick the shape or other object, and then on the Shape Formattab, under Arrange, click Align.
However, you can control the alignment and snap-to capabilities by turning it off. When you draw, resize, or move a shape or other object in Excel, you can set it so that it will align or "snap” to the nearest intersection in the grid (even if the grid is not visible) or snap to other shapes or objects.