HOWTO: Swap Rows and Columns in Microsoft Excel

Need to swap your Excel rows to columns or vice verse, watch this video produced by my guest author.

Pin It

Excel Workbook takes very long to open

Someone complained that one of his Excel workbooks took very long to open.  The file size was 10MB and it will take about 3 mins to open up.  There are 20 Excel worksheets in this Excel workbook.  I went through all the worksheets and all of them were just texts and some form checkbox controls.  There were no formula, picture, macros and VBA code.  The file size seems too big for such a simple Excel workbook.  I tried open and repair the Excel workbook but it did not help.

Pin It

A simple tool to unprotect a password protected Excel 2007 or Excel 2010 worksheet

In the entry “Unprotect a password protected Excel 2007 or Excel 2010 worksheet”, I have showed how to unprotect password protected Excel 2007/2010 worksheet if you have forgotten the password.  Reckoning that it might be challenging for some to follow the steps especially when there are multiple protected worksheet, I have developed a very simple tool to remove the password protection.

Pin It