Combine first and last name cells into one
If you have a spreadsheet, where the first and last name are in two different cells, but need them into one for e.g. if importing your data into a website, ...
Fri, 23 Feb, 2018 at 1:30 PM
Password protect an Excel file
Warning:  Microsoft can’t retrieve forgotten passwords.           There are no restrictions on the passwords you use with regards to length, charact...
Fri, 23 Feb, 2018 at 1:42 PM
Updating the date format by bulk
This is the default date format when exporting from SIMS: Most online resources and exams require a different format, normally the generic ones are...
Tue, 24 Jul, 2018 at 10:09 AM
Make an Excel Spreadsheet read only, with a password to edit.
 This example shows you how to make your workbook read-only. Users can still save changes by creating a new copy of the workbook. For a better protection, ...
Fri, 22 Mar, 2019 at 2:02 PM