![]() Each sheet is a month and not only does it figure the payroll based on the time checked in and out but it carries forward YTD info and tracks vacation time used and balance. What are some of your favorite and most-used shortcuts? Let me know in the comments below.Ĭopy Sheet just became my new best friend!!!! Thank you for sharing this! These 7 techniques are just the tip of the iceberg when it comes to all of the ways you can save time with keyboard shortcuts in Excel. Have you used any or all of these shortcuts before? Can you see yourself putting some of them to use to save time and help others? The formula to add up the numbers is created automatically, and you can simply hit Enter to get your sum. If you want to quickly add all of the numbers in the range directly above a cell, just use this shortcut. You will probably have to change the format to an option that displays the time.)Ĭheck out my article on how dates work in Excel for more details. (If you've entered the time in the cell, but it is not showing when you leave the cell, you may want to check the cell's format settings. If you want both the date and the time in the same cell, just enter a space between the respective shortcuts. It will automatically enter the date or time from your computer system. If you want to put the current date or time in a cell, use this shortcut. I have this article on the Best Keyboards for Excel Keyboard Shortcuts that you might want to check out. Some keyboards may not have the PgUp and PgDn buttons, so be aware of that. The up shortcut will move you to the next tab to the right, and the down shortcut moves you to the left. Using this shortcut will move you to other open sheets in the workbook. Want some more tips and timesavers for working with tabs? Check out this post: 7 Shortcuts for Working with Worksheet Tabs in Excel 5. This procedure can also be done to copy multiple tabs at once. When you release mouse button, the duplicate tab will appear to the right of the original.Before releasing your click, hit the Ctrl button ( Opt button for Macs) and you will see a little plus symbol (+) appear in the icon.Then drag to the right until the down triangle arrow moves from the left of the tab to the right.Start by clicking on the tab you want to copy.You can make a duplicate of an existing sheet using this shortcut. 5 Keyboard Shortcuts for Rows and Columns in Excel.7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel.2 Keyboard Shortcuts to Select a Column with Blank Cells.Check out these tutorials for workarounds to that issue: Now, if there are cells with no data in your column, this shortcut only selects the cells down to that first non-blank cell, so keep that in mind. ![]() If you want to select the entire column, just start at the top and use Ctrl + Shift + ↓ to highlight all the way to the end of the column. This is especially helpful if you have a spreadsheet with really long columns of data. This includes applying number formatting, changing fonts and fill colors, inserting shapes, and more. Repeat Your Last ActionĪfter performing an action on a cell in your worksheet, using this shortcut allows you to repeat the action in another cell. I've got more tips when it comes to filtering drop-down menus in this helpful article: 7 Keyboard Shortcuts for the Filter Drop Down Menus 2. When writing formulas, you can see the argument options by placing your cursor over the relevant data and using the shortcut to see what other options are available for selection.For cells that don't have data validation lists, this shortcut will bring up an auto-fill list containing all of the unique entries from the column that the cell is on.For cells with data validation lists, this shortcut will open the drop-down menu that displays your options.If your filters are turned on, you can open the filter drop-down menu from any of the headers.This shortcut can be used in several different situations. ![]() □ These tips are not as well known as Ctrl + C for copy and Ctrl + V for paste, but they're almost just as useful. If you're not already considered a hero around at work, sharing these simple Excel shortcuts might help to elevate your status in the eyes of your coworkers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |