Tiny tableau tip: how to copy formatting between worksheets

by Robert Headington

Sometimes you can have multiple similar sheets in a dashboard that need to be formatted in the same way. However, once you have put these into the dashboard, the formatting may not work due to a smaller size or other reasons. If you had to go into each sheet individually, it can be a bit of a pain to change the format all of them.

Another case where copying formatting from sheet to sheet can be really useful is if you are given a workbook where the formatting on multiple sheets isn’t best practice.

If you come across either of these scenarios, you can save time by doing these 3 simple steps:

  1. Create or edit a worksheet with the formatting that you want to apply to other sheets
  2. Right-click the tab of the worksheet with the correct formatting and click copy formatting
  3. Go to the sheet/sheets where you want to apply this formatting, right click their bottom tag and click ‘paste formatting’

Here is a gif showing this in work:


Robert Headington

Tiny tableau tip: how to display negative numbers as positives

1 mins read

Thu 16 May 2019

Tiny tableau tip: how to see all your sheets in one view

2 mins read

Tue 14 May 2019

Dashboard week? day 3: Playing with a new tool

1 mins read

Wed 01 May 2019

Dashboard week day 2 - getting (more) hyped for endgame

1 mins read

Thu 25 Apr 2019