You just need to press the ENTER key to apply it. Using this shortcut will add the SUM function to your selected cell for all the preceding cells. The same shortcut works if you want to get the sum of all the cells in a row.Ĭlick on the cell just after the last cell of the row and press ALT + = to get the sum. Just click on the cell right below the cells you want to add and press ALT + = to get the sum of all the cells above it without needing to select them first. It’s a pretty simple function but if you repeatedly use it by selecting all the cells you want to add, it can collectively take a big chunk of your time. It’s hard to imagine working in an Excel file and not using the SUM function to add different cell values. Shortcut #6: Insert The Sum Of Multiple Cells To enter dynamic date and time values, you can use the NOW function in your Excel worksheets. The values won’t be updated automatically when you open the document later. They’d only show the exact date or time when you used the shortcut. MS Excel will display both the values in its default format date as integers and time as decimal values.Īlso, remember that the date and time in your selected cells will be entered as static text values. You can also enter both the values in the same cell by entering either the date or time first, then applying the other shortcut after hitting the space bar once. To get the current date, just press CTRL + To enter the exact time, double click on a cell and press CTRL + SHIFT + If you don’t remember the current date or want to enter the exact time in a cell, use these handy keyboard shortcuts. Shortcut #5: Insert The Current Date And Time In A Cell It’s a simple function but it helps you organize your content better without using extra cells or merging multiple cells to maintain alignment. You can also add bullet points to this list using another shortcut: ALT + 7 (in the NUM keyboard) Just double click on a cell to enter edit mode and press ALT + ENTER when you want to add a line in the same cell. It allows you to enter long text descriptions and passages with multiple lines in the same cell. This is one of my favorite Excel keyboard shortcuts. Shortcuts #4: Add New Lines And Bullets In The Same Cell This shortcut comes in handy if your Excel worksheet has different formulas and you want to frequently check how certain values are calculated. Here’s the standard Excel sheet view in which the formulas are not visible.Īnd this is what you’ll see when you press CTRL + ~Īs you can see, all the formulas in the sheet are now visible to you. Let me explain this with a couple of screenshots. To use it, just press CTRL + ~ anywhere in your worksheet. It allows you to switch your view from cell values to formulas and vice versa. This is a really useful keyboard shortcut for both advanced and new Excel users. Shortcut #3: Switch Between Cell Values And Formulas Doing so will return the data set to its original unfiltered form. Plus, you can use the same shortcut to remove filters from a cell. When you click on a filter, it gives you a dropdown of different options using which you can organize data in the filtered column. This shortcut comes in handy if you frequently filter different tables or data sets for information. Press CTRL+SHIFT+L after selecting the first cell of the column where you want to apply a filter. The keyboard shortcut for applying filters in MS Excel is simple. If you’re used to playing with heavy Excel worksheets that have lots of data, you’ll find auto filter a real lifesaver.Īpplying filters to a cell allows you to extract the information you’re looking for, organize the data in different ways, and identify trends within data sets. Shortcut #2: Toggle Auto Filter In Columns The cells with a comment box have a small red mark for identification. The great thing about the comment box is that you can also add bullets and formatting to it like a normal cell. This opens a comment box where you can leave additional notes, reminders, or any other information that provides context to the cell’s value. To use it, click on the desired cell and press SHIFT+F2 on your keyboard. It allows you to add comments to a cell that users can view by hovering over it. If you’re working on an Excel sheet that you have to share with your team members or just want to add reminders to a cell for your reference, you’ll love this keyboard shortcut. Shortcut #1: Insert A Note/Comment On A Cell In this article, I’ll share some of the most useful Excel keyboard shortcuts and how you can use them to get things done faster. There’s so much you can do with Microsoft Excel and using the right keyboard shortcuts at the right time makes it more enjoyable (plus helps you make an impression on your bosses) If you’re a frequent user of Microsoft Excel, you can add several months to your life by using Excel shortcuts.Īccording to a study, you can save 64 hours every year by using keyboard shortcuts as a frequent Excel user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |