Tableau Tip: Formatting across worksheets

by Hashu Shenkar

Suppose you have multiple worksheets and you need them formatted identically. Imagine the drudgery of formatting each one, one-by-one. Probably not what you want to be doing after all your hard work in creating your dashboard!

Let’s use the dashboard below as an example. The view on the top left hand side, Sales over time, has been formatted to give the line graph a cleaner look. Click here to see Coach Kriebel’s post on how to do this.



Now in order to copy this formatting across the other 3 views, we simply need to right click on the worksheet which we have formatted and click on Copy Formatting.


Next, right click on 1 of the 3 worksheets which aren’t formatted, click Past Formatting and BOOM! The formatting has been applied to this worksheet!


Repeat for the other 2 worksheets. There you have it, a cleaner looking dashboard formatted in no time!



Happy formatting!

Tableau Tip: Quickest way to get a table into Tableau from Excel

1 mins read

Fri 21 Aug 2015

Tableau: Filtering using the custom value list

2 mins read

Fri 21 Aug 2015

Tableau Tip: Switch between views dynamically on a dashboard

4 mins read

Wed 19 Aug 2015

How to use the color picker to personalise/brand your visualisations

2 mins read

Tue 18 Aug 2015