When you press the Enter key Excel typically selects the cell beneath the current cell. Some people change this default option so that the selected cell does not move at all when Enter is pressed. When you think about it, you often press Enter and then immediately move back to the cell to either copy it, or format it. If you want to change what the Enter does when you press it, you can change a setting in Excel Options.…
Applying sheet protection stops your sheet structure from being accidentally changed by you, or someone else. You can add sheet protection by right clicking the sheet tab and clicking Protect Sheet or using the Protect Sheet option in the Review tab. You typically use a password when applying protection, but you can also leave the password box blank. This still applies sheet protection and stops accidental changes, but allows you to easily unprotect the sheet; make a change and then…
Sometimes when Excel imports email addresses they are not recognised as emails and are not hyperlinks. They are two ways to fix this.
(more…)Excel has a feature that has been around for many versions, but most users are unaware of it as it is tucked away in a separate menu and dialog. You can have Excel automatically make a backup of the previous version of a file each time you save it. Note: if you click save twice in a row the backup will be identical to the current version. This can be a life saver if your file gets corrupted. In the…