Apply Formatting

Category: Formatting

Apply Formatting contains features to center across selection, formatting as a header, copy/pasting column width, and unhiding all rows & columns.

The features in this section are small tools that allow you to quickly apply consistent formatting options to your spreadsheets, helping you save time and create professional-looking Excel models that are easier to navigate and understand.

Save up to 2 hours of mundane work per day

debug formulas up to 5 times faster

Tools in this feature:

Center Across

This feature allows you to center content across a range of cells without merging them. This can be useful when you want to maintain the individual cells for data entry, sorting, and filtering purposes but also want to present the data visually in a more organized and aesthetic way. The feature works by applying formatting to the cells so that they appear as though the content is centered across the entire selected range. By avoiding cell merging, the feature also helps to prevent issues with data integrity and functionality that can arise from merged cells.

Format as Header

The feature allows you to apply consistent header color options across your work. You can also change the header colors by going to the Style Settings.

Copy Column Width

Copy Column Width allows you to easily copy the column width of a selected cell and apply it to other columns in the worksheet. This feature is particularly useful when working with large data sets where formatting consistency is important. Once the column width has been copied, you can select one or more columns where you want to apply the same width and use the same tool to apply the copied width. This makes it easier to copy column widths across worksheets and saves time and effort in manually adjusting the column widths, ensuring consistency across entire projects.

Unhide All Rows

The Unhide All Rows feature allows the user to quickly unhide any hidden rows on the current worksheet. This can be useful if rows have been accidentally hidden or if the user needs to view all rows at once.

Unhide All Columns

Similarly, the Unhide All Columns feature allows the user to quickly unhide any hidden columns on the current worksheet. This can be useful if columns have been accidentally hidden or if the user needs to view all columns at once.