Follow

Excel: Apply branded table formatting

Table formatting with UpSlide:

UpSlide branded is designed to speed up the process of formatting raw data to your company standards.

Using the series of buttons displayed above, you will be able to change fonts, background colors, borders or number formats in a manner of seconds. These features are based on the following principles:

  • successive clicks on a single button will cycle through all available formats,
  • once the cycle is complete, the initial formatting is reapplied (as if you used the native undo Excel feature).

Feature description:

  • Smart Format: applies a title style to the first line of the selection, a result style to the last and an item style to the rest.
  • Custom Styles: offers a preview of the available styles, which can then be applied by clicking the preview. These styles can also be applied to one of the Titles, Results or Items button.
  • Titles: cycles through all available title styles before re-applying the initial format.
  • Results: cycles through all available result styles before re-applying the initial format.
  • Items: cycles through all available item styles before re-applying the initial format. 
  • Number Format: cycles through all available number formats before re-applying the initial format. 
  • Background color: cycles through all available background colors before re-applying the initial format. 
  • Column Width: cycles through all available column widths before re-applying the initial format. 
  • Column Height: cycles through all available column heights before re-applying the initial format. 

Technical details:

  • The custom styles are best employed on tables where the first column contains labels. These styles indeed apply a specific indentation and alignment to the first column.
  • The custom styles can impact fonts, background colors and borders, cells with and height or alignment, but they do not affect number formats (for which you can use the Number Format button).
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk