How to Count Words in Excel (Quick and Easy)

This tutorial takes you through how to count words in Excel. At the end of it, you’ll be able to find out the exact word count in an Excel spreadsheet.

Ready to start?

Would you rather watch this tutorial? Click the play button below!

Finding out the exact word count in a spreadsheet can be done directly in Excel, but the whole procedure is quite complex. It’s possible, but we’d have to use various complicated functions and formulas all at once.

In this tutorial, we’re not gonna go this difficult way, but we’ll have a look at a little trick which can help you in most cases.

So, to find out in a quick and easy way how many words there are in a spreadsheet, we’ll help ourselves with the Microsoft Word application.

How to Count Words in Excel - Microsofot Word application

Let’s give it a try!

How to Count Words in Excel Using Microsoft Word

First, you’ll need to select the area in which you need to find out the word count and copy the selected area.

How to Count Words in Excel - Select the Area
How to Count Words in Excel - Copy the Selected Area

Then, open Microsoft Word.

How to Count Words in Excel -Open Microsoft Word

Use the hot key Ctrl + V to paste the copied data into a Word document.

How to Count Words in Excel - Use CTRC + V
How to Count Words in Excel - Copied

And that’s it!

Check down here, on the left-handed side of the bottom bar how many words there are in the document.

If you for any reason can’t use Microsoft Word and need to find out the word count directly in Excel, just leave a comment in the section below and we’ll be happy to make a tutorial on the more complicated way to count words directly in Excel.

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!