How to change 0 to - in excel

Have you ever worked on a set of data with blank rows in between? It can be pretty annoying, right?

Table of Contents

Oftentimes, we do encounter this format of data whenever we export data from a system or a database.

With the blank rows in between, it’s quite difficult to sift through the data as you have to scroll further down just to see the rest of the records.

You can’t even select all the data by pressing CTRL + A.

Notice that Excel doesn’t recognize the records after the blank rows as part of the data set.

With this data arrangement, you won’t be able to properly filter the records or even create charts.

In short, these blank rows are definitely making things difficult.

In this article, I’ll show you the quickest ways to solve this problem.

Method 1: “Go to Special” Option

To hide blank or null rows, the first step is to select the data set.

Since we can’t make use of CTRL + A to select it, we can do either of the following:

• Select the entire columns of the data set (as shown below).

• Or, select the firs
  how to hide unused cells in excel
  how to hide blank rows in excel