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