The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

To make all cells the same size in Excel and Google Sheets, select all the columns/row and then click on the Format tool to change the Column width or Row height.

Open your Excel workbook and then select the cells from where you want to remove formatting. If you want to select all cells, press the Ctrl+A hotkey.

Open your Excel workbook and press the Ctrl + G keys to open the Go to dialog. Click Special. Select blank and click OK. It should highlight all the blank cells in your workbook.