How to select cells with data
The picture above shows data in column B, some cells contain nothing, they are blank.
I will now go through the steps on how to select cells containing data excluding blank cells and header cell.
- Select cell B3
- Press CTRL + SHIFT + END keys to select all values including blanks.
- Press function key F5
- Click "Special..." button located at the bottom left corner of the dialog box.
- Double click on "Constants"
This will select all cells that contain numbers, text, boolean and error values.
Note that cells containing a space character will be selected as well.
Weekly Blog EMAIL
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Related articles
How to use absolute and relative references
What is a reference in Excel? Excel has an A1 reference style meaning columns are named letters A to XFD […]
How to quickly select a non contiguous range
A non-contiguous list is a list with occasional blank cells and that makes it harder to select the entire cell […]
How to find errors in a worksheet
Excel has great built-in features. The following one lets you search an entire worksheet for formulas that return an error. […]
Remove print preview lines (Page Breaks)
Have you ever wondered how these lines got there on a worksheet? They show where pages will break, in other […]
If your cell text is taking to much space Excel allows you to rotate text in any angle. Here are […]
How to select and delete blank cells
This article demonstrates how to select all blank cells in a given cell range and how to delete them. It […]
Create a numbered list ignoring blank cells
The formula in column B returns a running count based on values in column C. Formula in cell B3: =IF(C3<>"",COUNTA($C$3:C3),"") […]
In this article, I am going to show you two ways on how to find blank cells. Both techniques are […]
A number that is formatted as text will be left-aligned instead of right-aligned, this makes it easier for you to […]
How to quickly select blank cells
In this smaller example, column D (Category) has empty cells, shown in the picture above. If your column contains thousands of […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
