How to Use Registry Cleaner to Clean Junk File: Fast Solution to Error: Counting how many rows in several excel sheets in 2007

Friday, September 23, 2016

Fast Solution to Error: Counting how many rows in several excel sheets in 2007

Counting how many rows in several excel sheets in 2007

Hi all, I have around 50 excel sheets with different amount of rows in it.

Is there a quick way of counting how many rows that contain data in total across all the excel sheets?

This would be a massive help!

Thanks.

Anwsers to the Problem Counting how many rows in several excel sheets in 2007

Download SmartPCFixer for Free Now

Hi,

Are you familiar with the personal macro workbook personal.xlsm? It's a hidden workbook that when created opens with Excel and the contents of it are available to any workbook.

If not look here on how to create it if you haven't already.

http://dmcritchie.mvps.org/excel/getstarted.htm

Now what I'd do is put a single instance of it in there and then it's available for any open workbook.

Windows Recovery - Totally Fix All Errors including Counting how many rows in several excel sheets in 2007

Click on the Start button on the Taskbar.
Type "System Restore" (without quotes) in the Search box and hit Enter or,
Click on System Restore (when you see System Restore pop up in the list of search results).
Make sure the "Recommended restore" radio button is checked on the restore utility window.
Click on Next and follow the instructions given.

Note: There is the option on the restore utility to select "Choose a different restore point". Unless you have a specific reason to select a different date and time than what Windows recommends, just select the recommended option stated in the steps above. If you choose to select another one, follow these steps:

Click on that desired date and time, and Windows 7 will perform a scan for any affected programs in that restore point.

Once completed, click Next and follow the instructions given.

Once you have selected the restore point, your system will start the restoring process, after which you will have to restart the system.

Another Safe way to Fix the Problem: Counting how many rows in several excel sheets in 2007:

How to Fix Counting how many rows in several excel sheets in 2007 with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.