Hello, is there a way to made buttons, automatically fit cells (at creation or resize of row/column ?
(Don’t know the first version supporting this all. Recent versions do.)
Form controls are hosted by shapes, and in a spreadsheet any such shape is anchored either To Cell (two variants) or To Page. The respective setting can be made via the context menu. For control objects the default is To Page, and a cell to fit the shape to isn’t defined.
Change the anchor setting to To Cell, and the context menu will show an item Fit to Cell Size. It will work as its name tells.
1 Like