financial excel course london - excel counting blank

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » financial excel course london - Excel 2007 counting blank cells

financial excel course london - Excel 2007 counting blank cells

resolvedResolved · Low Priority · Version Standard

Caroline has attended:
Excel Intermediate course

Excel 2007 counting blank cells

How to count blank cells?

RE: excel 2007 counting blank cells

Dear Caroline


Thank you for attending the Excel Intermediate Course.

Knowing which cells are empty can be very useful task as it might have been done as a mistake by the user. To count the No. of cells that are blank you can use a function called COUNTBLANK.

It is quite straightforward.

Step 1: Click on the cell where you want the result.
Step 2: Type =COUNTBLANK(Range)

[b]NB:

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips


Server loaded in 0.08 secs.