Custom Number Formatting: Hide All Data Across Multiple Sheet Tabs Using Semicolon

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to hide all data across multiple sheet tabs using semicolon. Let’s get started

We want to delete all the data at once in the three sheet tabs of the caption below

In Data sheet tab, hold down the SHIFT key and click on the Unpivot sheet

Click on the intercept triangle between A & 1 to select all the spreadsheet

Execute CTRL + 1 to open the Format Cells dialogue box

Select Custom and Clear the General

Type in three semicolon ;;;

Click OK

From the caption above, we can see that all the data are hidden on the spreadsheet. However, we can see the value in each selected cell in the formula bar





Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *