#ALT EXCEL SHORTCUTS ON A MAC MAC#
Excel Shortcuts for Mac to Help You Save Time 10 Best AppSumo Deals for Entrepreneurs & BloggersĪlthough you can perform these manually, knowing these shortcuts will help you save some time and let you focus on things that matter. Wouldn’t it be better if you could spend a little less time navigating, formatting, and entering formulas for the data? Hence we’ve put together a list of keyboard shortcuts for Microsoft Excel. Take the time to study up on existing CTRL commands and play with the ALT key and figure out the commands you would use the most.Many marketers who own a MacBook use Microsoft Excel every day, whether it’s to analyze data, create a pricing table, or to make a presentation to the client.Ĭreating reports in Excel is a laborious, time-consuming task. Using a combination of keyboard shortcuts with the CTRL and ALT keys, you’ll work faster and more efficiently. There’s no need to switch to a mouse and click excessively. The awesome thing about the CTRL and ALT keys is that you can do basically any command in Excel using your keyboard. Here are a few more ALT and CTRL combos that I use frequently: If you ever need to exit the ALT menu at any time or need to go back, you can use the ESC key to cancel the ALT menu. Using ALT+N+V+T, you’ve just created a pivot table for your data that took less time than if you were to use your mouse. To create a pivot table, you would hit N to select the Insert tab.Īfter selecting the Insert tab using the ALT+N combination, there is a new layer of letter options. When you type that letter on your keyboard, you open up the next layer of options. Hit the ALT key and your menu should look like this:Īs you can see, the main tabs have been each assigned a letter.
The ALT key transforms the menu into a navigable keyboard with endless possibilities. Instead of using your mouse to navigate through the menu, the ALT key will take your Excel menu and assign each item a letter. But when I needed to create a pivot table or paste as values, I had to use my mouse and navigate the menu.
#ALT EXCEL SHORTCUTS ON A MAC HOW TO#
When I first started using Excel on a daily basis, I only knew how to use the CTRL key to speed up my work. Learning how to use the alt key will help you go through tasks quicker and more smoothly than using a mouse. When hot keys aren’t enough, use the ALT key to navigate the menu. This one is super-handy for when you need to sort through any data. Try starting at the top of your column and using…ĬTRL+SHIFT+down: This selects all of the data in the column, which is great when combined with this next step:ĬTRL+SHIFT+L: This creates a filter on your data sheet. You can also add the SHIFT key into the mix to select all of your data. If you want to go back to the top, CTRL+up will bring you back to the top of the column. For example: if you have a column and you want to get to the cell at the bottom, you’d use CTRL+down. So go out there and study up!ĬTRL+arrow: The combination will help you jump to the ends and beginnings of your data. I’m highlighting a few of my favorites that I use the most, but there are a LOT more out there. The great thing is that there are already a good amount of combinations that can help you in your daily Excel tasks. The CTRL key allows you to use your keyboard to do otherwise time-consuming tasks that can be a hassle. Most people know how to use CTRL+C and CTRL+V to copy and paste. Find out what the existing hot keys are and use them. Here are a few tips and tricks to utilizing keyboard shortcuts in Excel to accelerate your work. So I’ve learned a bunch of shortcuts on my keyboard, and it’s made me a lot more efficient.
It breaks my rhythm and adds time to my work that I can’t always afford. In my PPC career of wading through huge sheets of data and creating super-detailed reports, I’ve found that the most time-consuming part of using Excel is switching from typing on my keyboard to using my mouse. Today’s post is by Account Associate Bailey Lau, conqueror of huge data files.
0 kommentar(er)
