Sorting, Saving, and Sheet Management Essentials

Discuss sort orders, explain save options and file types in Tableau, clarify the Ctrl-S shortcut for publishing to Tableau Public, and demonstrate how to rename and manage sheet titles.

Understand the nuances of saving, sorting, and publishing in Tableau Public to streamline your workflow and avoid common pitfalls. Learn when to use specific file formats like TWB and TWBX to effectively manage and share your Tableau projects.

Key Insights

  • Using Ctrl+S in Tableau Public triggers publishing to Tableau Public, not local saving—users must use File > Save for local saves.
  • Tableau workbooks can be saved in two formats: TWB (references local data) and TWBX (includes data for sharing with others who may not have access to the original data source).
  • Noble Desktop explains how to rename sheets, edit titles, and manage visibility of sheet titles to better organize your Tableau dashboards.

This lesson is a preview from our Tableau Course Online (includes software) and Tableau Certification Online (includes software & exam). Enroll in a course for detailed lessons, live instructor support, and project-based training.

We talked about sort. We were ahead of the game. I talked about the data sort order, which is the original sort order, ascending, descending, and all of that.

Saving options. We talked about it as well. There is no keyboard shortcut for save.

Locally saving. There is a keyboard shortcut to save to Tableau Public. That's Ctrl-S.

So if you like keyboard shortcuts, you're not going to like the fact that you don't have a keyboard shortcut just for saving your workbook. If you want to save your workbook while you're working on it, then what you'll do is you'll click file and then you'll click save. Don't use Ctrl-S because it'll ask you to sign in to Tableau so you can publish it.

In this case, the keyboard shortcut Ctrl-S is what publishes to Tableau Public. And it's the last step when we go to create our dashboards. You can also save Tableau Public as if you want to save and modify the existing workbook.

You want to create a duplicate copy. You can do that. When you save the first time, it saves to a TWB file.

Links to TWX includes data and is readable by the reader. You can also save this as a TWX file. Those are the two options when you use save as.

I'll just briefly show this to you. File, save as. This is where I can name this Tableau day one Tableau.

But I can also go over here and click a package. This is something I can share with someone who has the free version of Tableau and they can interact with the data. In the same way I'm working with it.

But this is just a local file on my computer that connects to the data that's already on my computer. The TWX will include the information that's used for this visualization, but it will not include the CSV for superstore data because that's on my computer. But it just includes enough information to create the visualizations.

I'm going to click cancel. Okay, so we talked about publishing to Tableau public. Sheet names.

We talked about this. We're ahead of the game. You can double click on the title.

Step-by-step instructions. One, you can rename the sheet by going to here. And then you can double click on the title and then change this sheet name to whatever you want.

You can hide the title and then you can show the title again after you hide it.

photo of Garfield Stinvil

Garfield Stinvil

Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble Desktop. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently.

Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. 

Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills.

More articles by Garfield Stinvil

How to Learn Tableau

Build practical, career-focused Tableau skills through hands-on training designed for beginners and professionals alike. Learn fundamental tools and workflows that prepare you for real-world projects or industry certification.