Organizing, analyzing and storing data are the most important tasks of any functional organization, to maintain its position in the corporate world. All of these tasks have been actively implemented by using interactive computer applications in spreadsheet form, allowing the display and management of data in tabular form. Microsoft Excel is the most popular office application to do that.
Microsoft Excel Online Microsoft Excel 2016
Download.com.vn has shared with you the common keyboard shortcuts in Microsoft Excel . 15 shortcuts from the latest version of the following article will help you control and use this app more effectively.
- Alt : Allow ribbon access through the keyboard to use all available options. To skip this action, users only need to press the Esc key .
- F5 : Display a Go to window that allows the user to go to any specific cell.
- Ctrl + Shift +; : Insert the current time in the selected cell.
- Ctrl +; : Insert the current date in the selected cell.
- Alt + Shift + F1 : Insert a new page into the selected document.
- Ctrl + 1 : Open the Format cells window that contains the formatting options for the selected text.
- F11 : Create and display a chart of the selected data.
- Ctrl + F9 : Minimize current Excel window to taskbar.
- Ctrl + F10 : Maximize the selected Excel window.
- Ctrl + F3 : Open the Excel Name Manager window .
- Ctrl + Space : Select all the column of selected cell.
- Shift + Space : Select all the rows of the selected cell.
- Ctrl + - : Delete selected column or row.
- Ctrl + Shift + = : Open the Insert window that allows inserting new columns or rows.
- Ctrl + Home : Move to cell A1 .
These 15 Excel keyboard shortcuts help you quickly and easily navigate between selections in Microsoft Excel. They are based on the latest version but still apply well to previous versions. If you want to achieve success managing all your data operations in Excel, these keyboard shortcuts will certainly contribute a lot to help you get there.