1 / 16

50 Shortcut Keys Of MS Excel

Here are some steps you can follow to learn advanced skills in Excel

excelassignmenthelp
Download Presentation

50 Shortcut Keys Of MS Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Shortcut Keys Of MS Excel excelassignmenthelp.com

  2. 50 shortcut keys of MS Excel Ctrl + N: Create a new workbook Example: Pressing Ctrl + N will create a new, blank workbook. Ctrl + O: Open an existing workbook Example: Pressing Ctrl + O will open the “Open” dialog box, allowing you to select an existing workbook to open. Ctrl + S: Save the current workbook Example: Pressing Ctrl + S will save the current workbook to its current location. Ctrl + P: Print the current worksheet Example: Pressing Ctrl + P will open the “Print” dialog box, allowing you to select a printer and print options.

  3. 50 shortcut keys of MS Excel Ctrl + Z: Undo the last action Example: Pressing Ctrl + Z will undo the last action taken in the workbook. Ctrl + Y: Redo the last action Example: Pressing Ctrl + Y will redo the last action that was undone with Ctrl + Z. Ctrl + X: Cut the selected cells Example: Select a range of cells and press Ctrl + X to cut the cells. Ctrl + C: Copy the selected cells Example: Select a range of cells and press Ctrl + C to copy the cells.

  4. 50 shortcut keys of MS Excel Ctrl + V: Paste the copied or cut cells Example: Press Ctrl + V to paste the cells that were previously copied or cut. Ctrl + F: Find text or value in the worksheet Example: Press Ctrl + F to open the “Find and Replace” dialog box and search for specific text or values in the worksheet. Ctrl + H: Replace text or value in the worksheet Example: Press Ctrl + H to open the “Find and Replace” dialog box and replace specific text or values in the worksheet.

  5. 50 shortcut keys of MS Excel Ctrl + A: Select the entire worksheet Example: Pressing Ctrl + A will select all cells in the current worksheet. Ctrl + B: Bold selected text or value Example: Select text or values and press Ctrl + B to make the text or value bold. Ctrl + I: Italicize selected text or value Example: Select text or values and press Ctrl + I to make the text or value italicized. Ctrl + U: Underline selected text or value Example: Select text or values and press Ctrl + U to make the text or value underlined.

  6. 50 shortcut keys of MS Excel Ctrl + 1: Open the “Format Cells” dialog box Example: Press Ctrl + 1 to open the “Format Cells” dialog box, which allows you to change cell formatting. Ctrl + ;: Insert the current date Example: Press Ctrl + ; to insert the current date in the active cell. Ctrl + Shift + #: Apply the time format Example: Select a range of cells containing time data and press Ctrl + Shift + # to apply the time format.

  7. 50 shortcut keys of MS Excel Ctrl + Shift + $: Apply the currency format Example: Select a range of cells containing currency data and press Ctrl + Shift + $ to apply the currency format. Ctrl + Shift + %: Apply the percentage format Example: Select a range of cells containing percentage data and press Ctrl + Shift + % to apply the percentage format. Ctrl + Shift + &: Apply a border to selected cells Example: Select a range of cells and press Ctrl + Shift + & to apply a border to the cells. Ctrl + Shift + #: Apply the date format Example: Select a range of cells containing date data and press Ctrl + Shift + # to apply the date format.

  8. 50 shortcut keys of MS Excel Ctrl + Shift + !: Apply the comma format Example: Select a range of cells containing numeric data and Ctrl + Shift + ~: Apply the general format Example: Select a range of cells containing various types of data and press Ctrl + Shift + ~ to apply the general format, which displays data as is without any formatting. Ctrl + Shift + ^: Apply the exponent format Example: Select a range of cells containing numeric data and press Ctrl + Shift + ^ to apply the exponent format, which displays numbers in scientific notation.

  9. 50 shortcut keys of MS Excel Ctrl + Shift + *: Select the current region Example: Press Ctrl + Shift + * to select the current region, which is the contiguous range of cells that contain data and is bounded by blank rows or columns. Ctrl + Home: Go to the beginning of the worksheet Example: Press Ctrl + Home to go to cell A1, the beginning of the worksheet. Ctrl + End: Go to the last cell containing data in the worksheet Example: Press Ctrl + End to go to the last cell containing data in the worksheet. Ctrl + Page Up: Go to the previous worksheet Example: Press Ctrl + Page Up to go to the previous worksheet in the workbook.

  10. 50 shortcut keys of MS Excel Ctrl + Page Down: Go to the next worksheet Example: Press Ctrl + Page Down to go to the next worksheet in the workbook. Ctrl + Tab: Switch to the next workbook window Example: If you have multiple workbooks open, press Ctrl + Tab to switch to the next workbook window. Ctrl + Shift + Tab: Switch to the previous workbook window Example: If you have multiple workbooks open, press Ctrl + Shift + Tab to switch to the previous workbook window.

  11. 50 shortcut keys of MS Excel Alt + =: Insert the SUM function Example: Select a range of cells and press Alt + = to insert the SUM function, which adds up the values in the selected cells. F2: Edit the active cell Example: Double-click on a cell or select a cell and press F2 to enter edit mode, which allows you to edit the cell contents. F4: Repeat the last action Example: Press F4 to repeat the last action taken in the worksheet. F5: Go to a specific cell Example: Press F5 to open the “Go To” dialog box, which allows you to go to a specific cell or named range.

  12. 50 shortcut keys of MS Excel F7: Open the spell checker Example: Press F7 to open the spell checker, which checks the spelling of text in the worksheet. F9: Calculate the active worksheet Example: Press F9 to calculate the active worksheet, which updates any formulas or functions that are dependent on cell values. F11: Create a chart from the selected data Example: Select a range of cells containing data and press F11 to create a chart based on the selected data.

  13. 50 shortcut keys of MS Excel Shift + F3: Insert a function Example: Press Shift + F3 to open the “Insert Function” dialog box, which allows you to select and insert a function into a cell. Shift + F5: Go to the last edited cell Example: Press Shift + F5 to go to the last edited cell in the worksheet. Shift + F11: Insert a new worksheet Example: Press Shift + F11 to insert a new worksheet into the workbook. Shift + F12: Save the workbook Example: Press Shift + F12 to save the workbook with its current file name.

  14. 50 shortcut keys of MS Excel Ctrl + Shift + F3: Create names from row and column labels Example: Select a range of cells containing row and column labels and press Ctrl + Shift + F3 to create names for the labels. Ctrl + Alt + V: Paste special Example: Copy a range of cells and press Ctrl + Alt + V to open the “Paste Special” dialog box, which allows you to choose how to paste the copied cells. Ctrl + Shift + L: Toggle the filter Example: Select a range of cells containing data and press Ctrl + Shift + L to toggle the filter, which allows you to filter and sort the data based on specific criteria. Ctrl + 1: Open the “Format Cells” dialog box Example: Select a range of cells and press Ctrl + 1 to open the “Format Cells” dialog box, which allows you to format the cells in various ways.

  15. 50 shortcut keys of MS Excel Ctrl + Shift + $: Apply the currency format Example: Select a range of cells containing numeric data and press Ctrl + Shift + $ to apply the currency format, which displays numbers with a currency symbol and decimal places. Ctrl + Shift + #: Apply the date format Example: Select a range of cells containing date data and press Ctrl + Shift + # to apply the date format, which displays dates in the default format for your region.

  16. Conclusion In this ppt, we have discussed 50 Shortcut keys of MS Excel. I hope you have understood easily. Shortcut keys are a very important aspect of using Microsoft Excel efficiently and effectively. By memorizing and utilizing the various shortcuts available, you can save time and effort in performing common tasks, and become a more proficient and productive Excel user. The shortcut keys listed above provide just a small sampling of many shortcuts available, and by exploring and experimenting with different combinations, you can find even more ways to streamline your Excel workflow. To get help with Microsoft Excel, you can contact our experts who can help you with Excel.

More Related