Ampler resizes a selection to exact measurements — in centimetres, inches, or points — and can match print margins or PowerPoint shape dimensions, so a range fits exactly where it’s going.
Quick answer: Select the cells and click Resize cells on the Ampler ribbon, then set the width and height in cm, inches, or points — or fit to print margins or a PowerPoint shape.
How to use it
Set the width and height in cm, inches, or points.
- Select the cell area to resize — for example, so it prints nicely.
- Click Resize cells.
- Set the size in points, inches, or centimetres, or click Fit to print margins under width.
You can also resize a selection to match PowerPoint shape dimensions, so a table drops into a slide at exactly the right size.
Keyboard shortcut
Resize cells has no default shortcut. To assign one, open the Settings dropdown on the Ampler ribbon, choose Shortcuts, click Modify on the function, and press your key combination.
Why use it
Sizing a range to fit a page or a slide by dragging is guesswork. Resize cells sets exact measurements — and can fit the selection to the print margins or to a PowerPoint shape — so the range lands exactly where it’s meant to.
How consultants use it
Excel ranges often become printed exhibits or tables pasted into a deck, and they have to fit exactly. Three habits apply:
- Exact measurements: width and height are set in cm, inches, or points.
- Fit the page: a range is sized to the print margins for a clean printout.
- Fit the slide: a range matches a PowerPoint shape so it drops into a deck at the right size.
Resizing to exact measurements makes a range fit the page or the slide precisely.
Tips & best practices
- Use Fit to print margins for print-ready tables.
- Match PowerPoint shape dimensions when a table is going into a deck.
- Set the unit (cm, inch, point) your templates use.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you set an exact cell size in Excel?
Select the cells, click Resize cells on the Ampler ribbon, and set the width and height in centimetres, inches, or points.
How do you fit an Excel range to the print margins?
Use Ampler’s Resize cells and click Fit to print margins under width.
Can you size an Excel range to a PowerPoint shape?
Yes. Resize cells can match a selection to PowerPoint shape dimensions, so it fits a slide exactly.