Repair Corrupted Excel Workbook
You can encounter corrupted workbooks time to time. Sometimes one of your workbooks gets corrupted, sometimes a file you received is. But there is no...
Beat Excel! Get to next level in Excel!
Top Excel Tips
This will be an ever improving Top Excel Tips post. I’ll be adding new tips every couple of days until total count reaches 100 tips....
How to Sort Data Horizontally in Excel
When you have your data arranged in a horizontal table instead of a vertical table, you may need to sort your data horizontally instead of...
Save Prompt Without Any Changes
Sometimes when you open an Excel file and then close it without making any changes on it. But to your surprise, Excel pops a dialog...
Insert Hyperlinks from Text (VBA)
When you need to insert a series of hyperlinks into an excel sheet from a list of links, this small macro named “insert hyperlinks from...
Editing Multiple Formulas
Here is a very useful tip about editing multiple formulas at once. This one will save you a lot of time and effort whenever you...
