This command is called "Fill Down"Īs I have stated before, there are just some of the many keyboard shortcuts that Excel 2016 puts at your disposal.
Ctrl + D - Fills all the selected cells below with the information from the top one.Alt + Shift + F1 - Adds a new worksheet to your workbook.Ctrl + F1 - Displays or hides the ribbon.Ctrl + Shift + (semicolon) - Inserts the current date.
Moreover, once a tab has been activated, a new series of keyboard shortcuts will appear that will allow you to access specific functions or commands from it. In order to view the available shortcuts, all you have to do is press the "Alt" key to bring up the corresponding letters for each tab, as you can see in the image below.įor example, you can press "Alt" and then the letter "P" to instantly go to the "Page Layout" tab. With the help of keyboard shortcuts you can switch between them and access the desired functions and commands in just a couple of seconds without having to use your mouse. The ribbon is a term used by Microsoft to refer to their own type of toolbar that was introduced with Microsoft Office 2007, and it groups an application's features in tabs for a quicker and easier access. So, if you are familiar with these keyboard shortcuts, you know how much they can ease your work and, if not, then you might want to start using them.
If you want to make your own hotkeys for Excel, then you will have to install an older version of the program. Sort, Filter, and Use PivotTable Reports.Ĭlick "buy" to start climbing the ladder of Excel in a successful way today.Unfortunately, Microsoft removed the keyboard shortcut customization option for Excel 2016.
We have compiled keyboard shortcuts for Mac users to use in Excel 2016 to help them get started. The keyboard shortcuts that are listed in this book will help you to use Excel in a fashioned, organized and productive way. Your preparation requires that you begin to practice the use of keyboard shortcuts. That is why you need to really prepare yourself. Without an encyclopedic knowledge of Excel, one maybe found wanting in so many areas as far spreadsheet is concerned. Microsoft Excel, a spreadsheet program used for budgeting, accounting, bookkeeping, small businesses and many more tasks is among the best spreadsheet programs available in the market today. *Begin to excel in Microsoft Excel in a painless way*