It is vital to contain as data with which you are functioning when making worksheet in Excel. The helpful things include to worksheet is counter. This assists to way number of lines of data in worksheet. Creating this counter is not hard, but it is vital to utilize right formula.


Instructions

Step 1

Start Microsoft Excel. Create new spreadsheet or worksheet.

Step 2

Give name to columns by giving them explanatory titles. E.g. make "Description", "Price", "Quantity" and "Total Cost" column to track orders.

Step 3

Include column and provide it title "Count." Go to base of spreadsheet and type "=COUNT (firstrow: lastrow)." E.g. if initial cell in spreadsheet has data is B2 and final cell having data B50, formula is "=COUNT (B2:B50)."