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
- Press with left mouse button on "Special..." button located at the bottom left corner of the dialog box.
- Double press with left mouse button 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.
Related articles
This article demonstrates a User Defined Function (UDF) that counts unique distinct cell values based on a given cell color. […]
Use the following formula to convert a column number to a column letter: =LEFT(ADDRESS(1, B3, 4), MATCH(B3, {1; 27; 703})) […]
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),"") […]
The Quick Access Toolbar is located at the very top of your Excel window, I highly recommend that you place your […]
In this article, I am going to show you two ways on how to find blank cells. Both techniques are […]
Excel has great built-in features. The following one lets you search an entire worksheet for formulas that return an error. […]
A number that is formatted as text will be left-aligned instead of right-aligned, this makes it easier for you to […]
Selecting cell ranges in Excel can sometimes be a real pain scrolling forever it seems. There is a quick and easy […]
A non-contiguous list is a list with occasional blank cells and that makes it harder to select the entire cell […]
In this smaller example, column D (Category) has empty cells, shown in the picture above. If your column contains thousands of […]
This article explains how to substitute part of a formula across all cells in a worksheet. It is easier than […]
This article demonstrates how to select all blank cells in a given cell range and how to delete them. It […]
What is a reference in Excel? Excel has an A1 reference style meaning columns are named letters A to XFD […]
Making your sheets easy to read is a fundamental approach of creating useful worksheets. Your message must be crystal clear, […]
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 […]
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.
