When Excel 2013 opens it display its start window. Many users don't use templates so it is frustrating. Pressing the Esc key takes you to the familiar grid. To stop the Start screen displaying use Excel Options. Press in sequence Alt t o (not held down), at the bottom of the dialog untick the Start screen option and click OK. See image below.
Here is the problem. You have a single column range. Each cell in the range needs to be given a unique range name. Doing this manually takes time, but there is a quick and easy method to do it. (more…)
When you are editing a cell you may notice that most of the ribbon icons are greyed out, because you can't use them. The formatting tools however are not greyed out. You can select part of the text in a cell and format it differently to the rest of the cell. See example below.
There can be times when identifying the current or a specific column letter reference is useful. Check out the comments for a shorter formula – thanks Batuque. (more…)
If you want to follow a cell link or find cells that are linked to a cell you can use these two keyboard shortcuts. To follow a link use Ctrl + [ To find linked cells use Ctrl + ] To return after following a link, you can press F5 and then press Enter.
In Excel if you need to hide data or workings sheets you can hide multiple sheets in one action. Unfortunately Excel won’t let you unhide multiple sheets in one step (even in the latest version). To get around this limitation you can use a macro that unhides all the sheets.
(more…)
The MIN and MAX functions allow you to identify the lowest and highest values within a range. But what if you want to find the second, or third highest values? Well there are two companion functions that you can use to do just that. (more…)