This is used to flick between tabs on an Excel worksheet. Ctrl + Page Up/Page Down (flick between tabs) Ctrl + Home – shoot the cursor back up to cell A1, aaaand…ġ0.
These final two tips are really extensions of the 4th point from my previous post on time saving tips. I find myself using a mouse less and less with Excel these days, as it’s a lot quicker to zoom around with the keys.
Honestly people, let’s get this back on track! (/end rant)Īnd now onto the final two shortcuts, which are both based around simple keyboard navigation. “Your” is the possessive word, and “you’re” is an abbreviation of “you are”. Here I’ve demonstrated the shortcut with one of my grammatical pet hates. I can’t really dress this one up too much – simply put, if you want to toggle filters on and off much more quickly then use this shortcut on any set of data! If you’re a regular user of Excel, then chances are you use filters on quite a regular basis to quickly drill down to relevant info. Well with this shortcut you can move the cursor manually down a line while typing, which gives you that extra little bit of control.ħ. You may be aware that the ‘Wrap Text’ button allows text within a single cell to be displayed on separate lines (as opposed to having a long line of text spill into other adjacent cells). Alt + E (start a new line in the same cell/wrap Text) However if you press F4 after the cell reference it’ll add these in for you. This can be a pain if you’re working on particularly lengthy formulas. In my previous post I talk about the importance of using $ symbols to lock formulas in place. F4, whilst writing formula (locks cells with $ symbols)
#Excel coomands for mac outlook how to#
If you don’t make use of named ranges in your worksheets, then this tip might not make sense – but that should really give you more impetus to start using them, so you can come right back here and learn how to find them again! As it turns out, it’s incredibly easy – simply press F3!ĥ. F3 (brings up list of named ranges used in sheet) Stupidly easy – rather than running your eyes/finger up and down the page to find the cell reference, just double click on the cell (or press F2 on it) and it will go back into edit mode and show all the referenced cells in nice colourful boxes.Ĥ. This tip was added after watching several colleagues struggle to keep tabs on what cells were being referenced in some of their formulas. F2, or double click (show formulas and references) It can be especially good if you’re analysing and comparing formulas next to each other.ģ. The one next to the number 1 look (If you’re a mac owner then you’re probably beyond all help, sorry).Īnyway this shortcut can be used to toggle showing the formulas on the page. That is, the tilde key was traditionally always there (~) but now probably has something like the following (¬) instead. If you’re not sure what the tilde key is, it’s the one at the top left of your keyboard next to the number 1. Ctrl + Tilde Key (shows formulas in cells) If you find yourself doing this kind of thing regularly then it’s definitely worth remembering.Ģ. Simply use this shortcut at the bottom of a big list of numbers and it’ll do an immediate sum of them for you. Well, apparently quite a lot, as I’ve used this shortcut all the time since, every day. “How much time can this possibly save me?” scoffed I. I first read this tip elsewhere about 3 months ago and scoffed at it openly. It’s packed with formulas and macros aimed at keyword marketers but useful for anyone who wants to sharpen up their skills and knowledge.Īs of January 2021, we’ve refreshed this list with an additional 10 shortcuts that will knock your socks off with their sheer usefulness!
If you’re not already familiar with them, you may want to check out my previous posts: 5 Great Time-Saving Excel Tips and 5 Great Uses of the IF Formula.įor the slightly more advanced users, there’s also our latest Excel Cheat Sheet. Hello and welcome to another Excel blog post – third in this series, where I attempt to explain and demonstrate some great Excel shortcuts for you to use in your everyday working lives (or just for fun).
0 kommentar(er)
