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.1. 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). Editing Copy ctrl+ c ctrl+ c Paste ctrl+ v ctrl+ v Undo ctrl+ z ctrl+ z Redo ctrl+ y ctrl+ y File Open ctrl+ o ctrl+ o New ctrl+ n ctrl+ n Print ctrl+ p ctrl+ p Save ctrl+ s ctrl+ s Save as f12 + shift+ s Go to next workbook ctrl+ tab + Close file ctrl+ f4 ctrl+ w Close all open Excel files alt+ f4 ctrl+ q Ribbon Show ribbon accelerator. Windows shortcuts in blue.Opens a previously saved document. Cut- Removes the selection from the active document and places it on the clipboard. Open a new workbook quickly. To use one of these combinations Hold the Command (Apple) key down and strike the letter key. Commonly used keyboard combinations. Select the data you want to sort, or do not highlight anything if you wish to sort the entire document.
Excel Keyboard Shortcut To Highlight Column To Next Change Mac Keyboard ShortcutWell, 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. Selecting an entire column lets you sum up the data with different conditions.As of January 2021, we’ve refreshed this list with an additional 10 shortcuts that will knock your socks off with their sheer usefulness!I first read this tip elsewhere about 3 months ago and scoffed at it openly. I mostly use it when I want to sum up the monthly data in a single row. It’s packed with formulas and macros aimed at keyword marketers but useful for anyone who wants to sharpen up their skills and knowledge.Instead, you can use the Mac keyboard shortcut Shift + Spacebar to select the entire row on the go.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.4. F2, or double click (show formulas and references)This tip was added after watching several colleagues struggle to keep tabs on what cells were being referenced in some of their formulas. It can be especially good if you’re analysing and comparing formulas next to each other.3. Have a go at playing with this now!6. 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. F4, whilst writing formula (locks cells with $ symbols)In my previous post I talk about the importance of using $ symbols to lock formulas in place. “Your” is the possessive word, and “you’re” is an abbreviation of “you are”. 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!Here I’ve demonstrated the shortcut with one of my grammatical pet hates. Ctrl + shift + L (turn on/off filters)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.7. 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). There’s no stopping you now, so get stuck in and start using these shortcuts now!Pasting as values strips formatting away from what is being pasted. When used in conjunction with other keyboard quick navigation keys, these will enable you to fly around the page(s) with ease. Ctrl + Page Up/Page Down (flick between tabs)This is used to flick between tabs on an Excel worksheet. Ctrl + Home – shoot the cursor back up to cell A1, aaaand…10. 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. Especially useful for pasting text from websites into emails. A true efficiency booster if you paste as values a lot.Bonus: Ctrl + Alt + V works across Word and Outlook too, making it easy to strip formatting and just keep pure text for the applications. It runs through the steps in the menu, then you hit enter at the end. The shortcut gives you a way to paste just the text without formatting, using only the keyboard rather than going through the right click menu. This is how I need to paste 90% of the time. While not strictly just an excel shortcut, it’s the one I use the most. F12 (go directly to the Save As dialog for the current folder)The champion. Employing this simple shortcut means you can delete whole clusters of rows or columns using the keyboard alone. I regularly use this to rearrange columns on things like keyword research, without reaching for that oh so inconvenient mouse.Bonus! If you press F4 after doing this, it will repeat the action.The Yin to Ctrl + shift + plus’s Yang, this will eliminate any rows or columns you have selected in their entirety. Always ask to run flash on chrome for macThis is one of the more beautiful shortcuts to use, applied with an elegant inward motion of the thumb, followed seamlessly with the ring finger and index finger. Good for when I realise I need to delete a column but can’t because filtering is on, and I need it off immediately. After this, when you press Alt + 5, your current Excel file will be catapulted into a new Outlook message, with itself as the attachment ready to go!If you do a lot of filtering, for example in keyword research and grouping, you’ll know that for every filter turned on, a filter must be turned off, right? Wrong! Turn them all off at once with Alt + A + C. Alt + 5 (put file as attachment straight into an outlook email)For this one to work you have to click ‘customize quick access toolbar’ and select ‘Email’, just once. No more of this with F12, which takes me straight into the saving folder in which the file currently exists, which is where I want to be.17. Excel has its own saving and opening interface which is snazzy looking but paradoxically seems built to increase the number of clicks required to reach the final saving folder window. It also sounds like ‘hack’ so you can remember it. To make it happen without reaching for that oh so cumbersome mouse, this one proides an alternative that’s easier on the wrist. Follow it with a few tabs and enter and you can have your duplicates removed in seconds without using the mouse.Centered text looks great in tables. It brings the remove duplicates box up.
0 Comments
Leave a Reply. |
AuthorMelinda ArchivesCategories |