How to easily convert Decimal Degrees to Degrees Minutes Seconds [in Excel]. Came across this Microsoft Excel formula the other day which easily allows you to convert Decimal Degrees to Degrees Minutes Seconds within seconds. It is very easy to use – simply copy and paste the formula into Excel and change the [Lat Cell] or [Long Cell] text within the formulas to point to the cells with the Decimal […]
This post we show how to remove an Excel spreadsheet password in 6 easy to follow steps. It is an update to an earlier article where we discussed how you may be able to unprotect an Excel spreadsheet if you have forgotten the password used to protect it. Click here to read that article. Unfortunately, there is no way that we can view or recover what your lost password is. […]
Excels 56 ColorIndex Colors Color Palette Excel’s Color Palette has an index of 56 colors which can be used throughout your spreadsheet. Each of these colors in the palette is associated with a unique value in the ColorIndex. For reasons unknown, aside from the index value, Excel also recognizes the names for Colors 1 through 8 (Black, White, Red, Green, Blue, Yellow, Magenta, and Cyan). interior ColorIndex HTML […]
Navigate your worksheets with ease Learn to easily navigate your Excel worksheets with these straightforward keyboard shortcuts. Move straight to the very top of your Excel worksheet by pressing Ctrl+Home. Similarly, you can move to the very last cell (that contains or did contain data – far bottom right) within your Excel worksheet by pressing Ctrl+End. There will be times when you want to navigate to […]
Do you often re-type over content in a cell in Excel then realise that you shouldn’t have just done that? Excel’s Undo (Ctrl + Z) feature provides you with a quick way to reverse (i.e. undo) any changes you have made to a worksheet such as accidentally deleting data, applying incorrect formats, or moving formulas. Similarly, if you have reversed back a change, but then realise that the change should […]
Ever had one of those moments when you have been working hard all day on a spreadsheet and your boss/client needs it by close of business and just as you are tidying things up and just about to hit the save button and… whoosh – something totally unexpected happens and your computer loses power or shuts down or (insert multiple other scenarios here…) and “Arghhhhh!!!!” – you have lost all […]
Needing to increase your productivity, don’t take your hands off of the keyboard when you need to copy and paste data within your spreadsheets, simply use Ctrl + C to copy the data in your selected cell(s) and Ctrl + V to paste it to the destination cell. Continue the Discussion Continue the discussion and leave a comment below – Do you have a favourite productivity tip you would […]
