MintyTools
ApplyFormatting=MINTY.APPLYFORMATTING()
Buy MintyToolsBuy$69

Apply Formatting

Format headers, match column widths, center text without merging, and reveal hidden rows or columns.

  • One of 30 tools in MintyTools
  • Excel 2013–365 on Windows
  • 14-day money-back guarantee

Try it - click the ribbon

Summary.xlsxExcel
B1Quarterly summary
ABCD
1Quarterly summary
2Q1Q2Q3
5Training650720810
6Total6,6507,3207,920
Summary
Ready
Why doesn’t the total add up? Two rows are hidden. Fix that, then tidy the headings.

Inside this tool

5 commands, one button.

Commands included in Apply Formatting
IconCommandWhat it does
Center AcrossCenter a heading across selected cells without merging them, keeping the worksheet structure easier to manage.
Format as HeaderApply the configured MintyTools header style to the selected range for a consistent report hierarchy.
Copy Column WidthCopy the width of the active column and apply it to the rest of the selected columns.
Unhide RowsReveal every hidden row in the active worksheet without locating each hidden interval manually.
Unhide ColumnsReveal every hidden column in the active worksheet in one focused command.

How it works

Use the Apply Formatting tools when selected cells, rows, columns, or tables need consistent professional formatting.

Choose a focused formatting command from MintyTools and apply its predefined style to the active Excel selection.

Standardize common workbook elements quickly while reducing the repeated clicks needed to format each selection manually.

Keep exploring

See the whole Formatting sheet or every tool.

MintyTools demo

Video not loading? Watch on YouTube ↗