Tag Archives: excel

Microsoft Office 2016, crashing, freezing issues

If you have Microsoft Office 2016 and are having crashing, freezing issues (mainly with Word or Outlook), 99% of the time it's due to not getting Office updates. Especially if you bought the office suite with your computer. UPDATE: If you have ANY other version of Office installed (Ex: Office 2010, 2013, etc.) this is…
Read more

Excel – Lookup value in column and return value from another column

You can build a lookup that allows you to specify the lookup column and return value column completely independently, and also control of the nature of the approximate match, if not exact. Here is the full function: =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) Return_value_range – The range that holds the return values Lookup_value – The value you…
Read more

Unprotect an excel sheet without password

If you have ever protected an excel sheet; forgot the password or got a excel sheet and needed the password to edit it, here is how to "unlock it": http://uknowit.uwgb.edu/page.php?id=28850 Here is the VBA code that you will need to crack and show you the password: Sub PasswordBreaker()     'Breaks worksheet password protection.     Dim…
Read more