how to find total number of rows having data in an Excel Workbook across all worksheets

Sure, here are the steps to find the total number of rows having data in an Excel Workbook across all worksheets:

1. Open the Excel Workbook.

2. Press Ctrl + Shift + Right Arrow then Ctrl + Shift + Down Arrow. This will select all the cells that contain data in the current worksheet.

3. Look at the name box (the box that usually displays the cell reference of the selected cell, to the left of the formula bar). It will display something like A1:G20, which means that data is present from row 1 to row 20.

4. Note down the number of the last row that contains data.

5. Repeat steps 2-4 for each worksheet in the workbook.

6. Add up the numbers you noted down for each worksheet. This is the total number of rows that contain data in the workbook.

Please note that this method assumes that there are no blank rows in the middle of your data. If there are, those rows will not be counted.