fbpx

Day

May 7, 2020

How to split spreadsheet into separate workbooks using Excel VBA?

Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook. It’s useful and reduces our effort in making different workbooks with the same data..     I hope you have enjoyed our earlier blogs, revisit “How to split excel data into separate spreadsheets...
Read More

Turn ON or Turn OFF Scroll Lock in Excel

Imagine your report is due in an hour. You are working along in Excel, everything is going well, but suddenly you notice that you can no longer move around properly in your spreadsheet. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving. Turn-ON/Turn...
Read More