How to count lines in Excel

Microsoft Excel offers a very interesting way to count how many lines. We can cater to this problem statement by using the “CTRL + Down Arrow Key”l. We can perform the below mentioned way to count how many lines in excel:

We’ll learn about this methodology step by step.

To do this yourself, please follow the steps described below;

Step 1 – Excel sheet

– Open the desired Excel workbook where you want to count how many lines are present

Step 2 – Go to the last line

– Now press “CTRL + Down Arrow Key”, you will be taken to the last line, and in the image above we can see that there are 1048576 lines in excel