Whether you have a word count restriction for your spreadsheet or are simply curious about the word count in a particular column, Excel 2007 allows users to find the number of words with a predetermined formula. Excel formulas are created to adjust to any data that is modified. For example, if you change a value in cell A5 and the formula in cell B6 is linked to cell A5, the value of cell B6 will change. By knowing the word count formula, you can calculate the number of words within a given column and rows.
Identify the column and amount of rows you wish to count the words. For example, if you wish to calculate the amount of words in column B from rows 3 to 15, write down "B3" and "B15" for future reference.
Double-click in the cell where you want the word count value to appear.
Enter the formula inside the cell. Using the example column from Step 1, the formula looks like this:
Replace "B3:B14" with the range of rows from your column.
Press the "Enter" key on your keyboard to calculate the number of words within the column range. The formula is replaced by a numerical value that represents the word count. If you wish to modify the formula, left-click the cell once and modify it through the textbar above the spreadsheet column labels.
How to Hide Cell Contents in Excel
Excel 2013 and 2010 provide two methods for hiding cell contents without losing any data. To hide one or more individual cells,...