Besides, if you are part of the keyboard generation, shortcuts just come more naturally anyways. Read on for 50 keyboard shortcuts that you’d probably find yourself using on Windows 8, when out of swipe mode.

1. 50 Keyboard Shortcut
2. 50 Keyboard Shortcut Keys

Microsoft Excel Shortcuts – Since its release in 1985, Microsoft Excel Shortcuts has been a helpful tool for collating and analyzing information quickly and effectively. Excel spreadsheet is one of the most widely used computer application which helps in organizing, storing and analyzing data in tabular form which is easily evaluated.

Though the charts, formulas and other tools help in manipulating, analyzing and managing all the important data, it can be overwhelming to use the spreadsheets without MS excel shortcuts. Fortunately for Excel users, every menu and operation in the application can be controlled from the keyboard with proper excel shortcuts. The list of Excel shortcuts tricks which is more than 225 can itself be overwhelming to learn and use effectively, but once mastered, the result would be a highly effective and efficient output in shorter time period.

Excel functions, formula, charts, formatting creating excel dashboard & others

Those who are familiar with old excel shortcuts tricks for excel should notice that some of the old excel shortcuts do not work in Microsoft Excel 2013. Ctrl + C and Ctrl + V still do the copy and paste job, but some of the old menu keys do not work anymore. When the old shortcut is clicked, a box pops up informing that the access key is from earlier Microsoft Office.

One more useful tool, though not included in excel shortcuts would be hovering the pointer tool above the buttons to know their functions.

With experience, the excel shortcuts and tricks will be memorized by people who regularly use excel, but initially it is important to know few basic excel shortcuts on keyboard that would save time and energy for users.

The top 20 MS excel shortcuts key used for Microsoft Excel by individuals and businesses alike are:

1. Home
2. Ctrl + Page Down & UP
3. Ctrl +Arrow Keys
4. Ctrl + *
5. Ctrl+5
6. Shift + F10
7. Ctrl + shift + [desired function key]
8. Ctrl + F1
9. F2
10. F4 or Ctrl + Y
11. F6
12. F12
13. Ctrl + Enter
14. Ctrl + Alt + V
15. Shift + Spacebar
16. Alt
17. End
18. Enter
19. Esc
20. F1

Microsoft Excel Shortcuts Key

1. Home

When working on the excel spreadsheet, the Home button on the keyboard conveniently takes the user back to the beginning of a row with just a click. If the scroll lock is turned on, clicking the ‘Home’ button takes the user to the cell in the upper-left corner of the window. If a menu or sub menu is open, the home button selects the first command on the visible menu.

Users can move to the beginning of a worksheet by combining Ctrl + Home buttons. When working in a cell, using the Home/End buttons allows users to conveniently move to the beginning and the end of a cell data.

To extend the selection to the starting point in a row, combine Shift + Home and to extend the selection to the beginning of the worksheet, click Ctrl + Shift + Home buttons.

2. Ctrl + Page Down & UP

Ctrl + Page Down or Ctrl + Page Up button helps in quickly surfing through worksheets in excel. Instead of crawling through the lines, users can jump from one worksheet to another with ease through this keyboard shortcut. Ctrl + Page Up moves to the previous worksheet whereas the Ctrl + Page down moves to the next. If the user has about 8 worksheets and is working on 7^th but wants to check the some data on 3^rd, then all he is has to do is hold down the Ctrl button and press page up 4 times.

3. Ctrl +Arrow Keys

The arrow keys are useful in moving one cell up, down, left, or right in a excel worksheet. With the help of shortcut Ctrl + Arrow keys the user can easily move to the edge of next data region, but only if there are no blank cells on the worksheet. This helps to scroll through pages faster. Pressing Ctrl + Down Arrow key will take the user to the last row on the worksheet whereas clicking Ctrl + Up Arrow key will take the user to the first row in the worksheet. The same applies for right and left arrow keys.

4. Ctrl + *

When the user desires to either copy or delete the current region around the actively working cell, the shortcut Ctrl + * (asterisk) helps in selecting the current active range in the cell with the entire data area that is enclosed by blank rows and blank columns.

The shortcut covers the data set in all directions from the current active space up to the end of the worksheet or a blank row or column. When working on a PivotTable in excel worksheet, the shortcut helps in selection of the entire PivotTable Data. The asterisk key is available on the numeric keyboard for independent selection.

Recommended courses

5. Ctrl+5

For those who like to finish the task on the list and strike it off, the shortcut Ctrl + 5 will do the job effectively.

Striking a task off the ‘To Do List’ will make it clear to the user what has been accomplished and what is left to do. If all the task in the cell has been completed, the entire cell can be selected and strike through by pressing Ctrl + 5 shortcut.

6. Shift + F10

The shift + F10 shortcut functions like the right-click on the mouse, opening up the menu for use. It is agreed that moving hand to the mouse when working on keyboard can be annoyance, hence having this option on the keyboard is a blessing. Further, users can use the arrow keys to move through the menu and press enter to select the desired option. To check the fly-out menus the right arrow can be used.

7. Ctrl + shift + [desired function key]

The control + shift buttons helps in inserting various functions in the worksheet with ease. To insert current time, click Ctrl + Shift + ; Users can format date and time on their worksheet by inserting desired function key along with Ctrl + Shift buttons.

The Ctrl + Shift + = will open the insert cells options. Ctrl + Shift + W will wrap the text. Ctrl + Shift + 7 will select the border or outline of the worksheet. Ctrl + Shift + # will apply date format with the day, month and year. The new Ctrl + Shift shortcuts with various helpful combinations makes the task of managing the Excel worksheet much easier.

8. Ctrl + F1

When working on the worksheet, at times the ribbon can be distracting or encroaching on the work space. The problem can be handled deftly by pressing the Ctrl + F1 shortcut which hides the ribbon. Pressing the shortcut again will make the ribbon visible once again.

9. F2

To edit the current working cell just click on F2 button on the keyboard. User can not only edit the active cell, but can also efficiently position the insertion point at the end of the cell contents with ease using this shortcut.

Clicking on F2 button helps in moving the insertion point into the Formula Bar when editing in a cell is turned off. To display the print preview area on the Print tab in the background, combine Ctrl and F2 keys.

10. F4 or Ctrl + Y

When the user has to repeat a complicated command previously applied to the Excel Worksheet, pressing the F4 key will do the job. The shortcut repeats the last command except some cases where the action cannot be repeated through the shortcut. The shortcut F4 will also deftly cycle through all the combinations of locked and unlocked locations or data when a formula in a cell is being edited.

For example – if the last function was to strike through a column on to do list with shortcut key Ctrl + 5, the action can be repeated with by pressing F4 key with ease. When working on excel worksheet it is very convenient to have a shortcut to repeat last formatting action for complicated lengthy functions with just a click of a button which saves time.

11. F6

When working with Microsoft Excel, users often have to switch between the current worksheet, task pane, zoom-in and zoom-out controls and ribbon for selecting various functions. Reaching out for the mouse for selection can be tedious task, but fortunately the shortcut key F6 comes to the rescue here. When the user has split the worksheet into more than one pane, the shortcut will include the split panes when switching between different areas.

12. F12

Nothing can be more frustrating than the hard work lost when the user fails to save the file, especially if it is data entered on Spreadsheet. The right thing to do is use the shortcut F12 which brings up the save as option for the file. It saves the user lot of unnecessary functions which leads to the save option.

13. Ctrl + Enter

Another useful excel shortcuts include the combination of Ctrl + Enter key which fills the selected cell range with contents of current entry. By using the shortcut the contents of an edited cell can be automatically exported to other selected cells.

14. Ctrl + Alt + V

It is easy to remember this particular shortcut since everyone is quite familiar with the Ctrl + V option which is regularly used to insert the copied content of the clipboard at the desired point. For some of the complicated data used in Excel worksheet, users may have to use Paste Special option. The shortcut Ctrl + Alt + V opens the Paste Special dialog box for pasting the cut or copied object, text, or cell contents on a spreadsheet. The copied content can be pasted in another program as well.

50 Keyboard Shortcut

15. Shift + Spacebar

Since every row in the Excel spreadsheet has an individual function, users may be required to select an entire row for a function. Using the shortcut Shift + Space makes the task easy. Once selected, changes can be applied to the whole row.

To select column use the shortcut Ctrl + Spacebar

16. Alt

There is no argument that keyboard shortcuts are very useful while working on excel spreadsheet. How about having a shortcut that opens up a menu of excel shortcuts on the ribbon? Alt button is the key that displays the Key Tips or new shortcuts on the ribbon of Microsoft Excel. For example, when you click on the Alt button, the options for new shortcuts on the ribbon open up – H for home, P for Page Layout and M for Formula. When you further press Alt + M the formula function opens up.

Alt key is also combined with various keys for creating different shortcuts, the most popular being Alt + F4 to close an open file.

17. End

The End button when used with Excel worksheet turns the End Mode on or off. This can be viewed in the bottom corner of the spreadsheet.

When the end mode is on, user can press the arrow keys to move to next blank cell in the column or row as required. Once the arrow key has been used to access the blank cell, the end mode turns off. The End button has to be clicked once again to activate it for further use. If the spreadsheet has only blank cells then the shortcut moves to the last cell in the column or row.

The End button is also used to select the last command on the menu when a menu or submenu is visible.

Dec 19, 2013  Watch video  Spectacular sets that makes Dhoom: 3 a pulse rising chilling cop thief adventure that has a highly satisfying and spectacularly dazzling individual part of Aamir Khan that stays with you for long and asks repeat viewing. Dhoom 3 movie download hd 720p.

18. Enter

When the entry in the cell or the Formula Bar is completed, user can select the Enter shortcut to complete the entry and move on to the next cell.

For example when the date is entered in the column, by pressing enter key the Data entry for Rental Company can be accessed for editing.

• Galloway, Stephen (2011-05-10).. Pirates of the caribbean 4 watch online. Retrieved 2011-04-21.

When the spreadsheet is in the data format, the shortcut moves to the first field in the next record. It can be combined with different keys for accessing different excel shortcuts. For example, using the Alt + Enter shortcut will create a new line in the same cell.

19. Esc

No matter how experienced you are, there are sticky places you get on the Excel worksheet from which the escape route will be through shortcut button Esc. The shortcut is also used to cancel undesired, completed or wrong entry in a cell or formula bar. If there are menus, submenus, message windows or dialog boxes open, the shortcut will close them.

20. F1

50 Keyboard Shortcut Keys

Finally, if the user is still at loss and needs some help, F1 is the right shortcut for call out for help.

It opens the Excel help task pane which has a search box where the user can seek help either offline or online.

The list should help novice Excel users to get familiar with excel shortcuts, which will help them achieve the task quickly and easily.

Related Articles:-

Here are some articles that will help you to get more detail about the Excel Shortcuts so just go through the link.

Excel VBA Course - All in One Bundle

120+ Online Courses

500+ Hours

Verifiable Certificates

Lifetime Access

Windows 10 was designed with touchscreens in mind, but Microsoft hasn't forgotten more traditional PC users. The operating system comes with plenty of built-in keyboard shortcuts -- including new shortcuts for the Command Prompt -- for those who prefer a physical keyboard.

Here's a handy list of the most useful keyboard shortcuts for navigating Windows 10. You might also find it useful to know how to open programs with keyboard shortcuts in Windows 10.

The basics

• Ctrl + A: Select all items in a window.
  
• Ctrl + C or Ctrl + Insert: Copy selected or highlighted item (e.g. text, images and so on).
  
• Ctrl + V or Shift + Insert: Paste selected or highlighted item.
  
• Ctrl + X: Cut selected or highlighted item.
  
• Ctrl + Z: Undo previous action.
  
• Ctrl + Y: Redo action.
  
• Ctrl + N: When File Explorer is your current window, open a new File Explorer window with the same folder path as the current window.
  
• Windows key + F1: Open 'how to get help in Windows 10' Bing search in default browser.
  
• Alt + F4: Close the current app or window.
  
• Alt + Tab: Switch between open apps or windows.
  
• Shift + Delete: Delete selected item permanently (skip the Recycle Bin).
  

Start menu and taskbar

You can use these keyboard shortcuts to open, close and otherwise control the Start menu and the taskbar.

• Windows key or Ctrl + Esc: Open Start menu.
• Windows key + X: Open the secret Start menu.
• Windows key + T: Cycle through the apps (including pinned apps) on the taskbar.
• Windows key + [Number]: Open the app pinned in the [number] position on the taskbar. For example, if you have Edge pinned in the first position on the taskbar and you click Windows key + 1, Edge will open. If the app is already open, a new instance or window will open.
• Windows key + Alt + [Number]: Open the right-click menu for the app pinned in the [number] position on the taskbar.
• Windows key + D: Show or hide desktop (Windows key + , will display the desktop briefly).

The desktop: Windows, Snap Assist and virtual desktops

These shortcuts control how individual windows act on your desktop, including virtual desktops.

• Windows key + M: Minimize all open windows.
• Windows key + Shift + M: Restore minimized windows.
  
• Windows key + Home: Minimize all windows except the selected or currently active window.
  
• Windows key + Up arrow: Maximize selected window.
  
• Windows key + Shift + Up arrow: Maximizes the active window vertically while maintaining its width.
  
• Windows key + Down arrow: Minimize selected window.
  
• Windows key + Left arrow or Right arrow: Snap selected window to the left or right half of the screen. (If the window is already there, Windows key + Up or Down will snap it into a quadrant.)
  
• Windows key + Shift + Left arrow or Right arrow: Move selected window to the left or right monitor.
  
• Windows key + Tab: Open Task view (virtual desktops).
  
• Windows key + Ctrl + D: Add new virtual desktop.
  
• Windows key + Ctrl + Right arrow: Move to the next virtual desktop (to the right).
  
• Windows key + Ctrl + Left arrow: Move to the previous virtual desktop (to the left).
  
• Windows key + Ctrl + F4: Close current virtual desktop.
  

The Windows key

These keyboard shortcuts use the Windows logo key to perform various tasks, such as launching both Windows and third-party apps.

• Windows key + A: Open the Action Center.
  
• Windows key + S: Open Cortana in text mode, so you can type in the search bar. (Windows key + Q does the same thing.)
  
• Windows key + C: Open Cortana in listening mode (similar to saying 'Hey, Cortana').
  
• Windows key + E: Open File Explorer.
  
• Windows key + F: Open the Windows 10 Feedback Hub.
  
• Windows key + Ctrl + F: Search for PCs on a network.
  
• Windows key + G: Open the Game bar.
  
• Windows key + H: Open the Share sidebar.
  
• Windows key + I: Open the Settings menu.
  
• Windows key + K: Open the Connect sidebar (for connecting to new Bluetooth devices or Miracast).
  
• Windows key + L: Lock your computer.
  
• Windows key + O: Lock screen orientation.
  
• Windows key + P: Open presentation or projection sidebar.
  
• Windows key + R: Open the Run window.
  
• Windows key + U: Open Ease of Access center.
  
• Windows key + W: open the Windows Ink Workspace for scribbling on tablets or touchscreen laptops.
  
• Windows key + Print Screen: Take a screenshot of the entire desktop and save it to the Screenshots folder in the Pictures folder.
  
• Windows key + (+) or (-): Zoom in and out with magnifier.
  
• Windows key + Esc: Exit magnifier.
  

Command Prompt

You can use these keyboard shortcuts inside the Windows 10 Command Prompt.

• Ctrl + C or Ctrl + Insert: Copy selected text to the clipboard.
• Ctrl + V or Shift + Insert: Paste copied text inside the Command Prompt.
• Ctrl + A: Select all text on current line. (If current line has no text, all text inside the Command Prompt will be selected.)
• Ctrl + Up or Down: Move screen one line up or down.
• Ctrl + F: Search Command Prompt via Find window.
• Ctrl + M: Enter Mark mode (allows you to select text with mouse). Once Mark mode is enabled, you can use the arrow keys to move the cursor around.
• Shift + Up or Down: Move cursor up or down one line and select text.
• Shift + Left or Right: Move cursor left or right one character and select text.
• Ctrl + Shift + Left or Right: Move cursor left or right one word and select text.
• Shift + Page Up or Page Down: Move cursor up or down one screen and select text.
• Shift + Home or End: Move cursor to beginning or end of current line and select text.
• Ctrl + Shift + Home/End: Move cursor to beginning or end of screen buffer and select text and beginning or end of Command Prompt's output.

Update, July 12, 2017: This story was originally published on July 29, 2016 and has since been updated with more shortcuts.

Turn a photo into an Excel spreadsheet: Microsoft's new tool for Android phones saves you endless time.

Save on Netflix, Amazon, HBO and Spotify: Credit cards for cord-cutters offer cash back for streaming.

• Review
  Windows 10 review: Microsoft gets it right
• News
  Microsoft Windows 10 April 2018 Update aims to shield us from notifications