In this post you can learn 15 microsoft excle shortcuts.This shortcuts based on microsoft excle 2016.. Excle 2016 user will be immediately useful.
The list is based on Excel 2016, but most will also work on Excel 2013. When that’s not the case we’ve noted it.
- Ctrl + PgDn: Switch between worksheet tabs, moving left to right.
- Ctrl + PgUp: Switch between worksheet tabs, moving right to left.
- F12: Display the “Save As” dialog.
- Ctrl + Shift + $: (Excel 2016) Current cell formatted as currency, with two decimal places and negative numbers in parentheses.
- Ctrl + Shift + %: (Excel 2016) Current cell formatted as percentage with no decimal places.
- Ctrl + Shift + #: (Excel 2016) Current cell formatted as date with day, month, year.
- Ctrl + Shift + “:”: Insert current time.
- Ctrl + Shift + “;”: Insert current date.
- F4: Repeats the last command or action, if possible.
- Shift + Arrow key: Extends your current cell selection by one addition cell in the direction specified.
- Ctrl + F1: Display or hide the Ribbon.
- Alt + Shift + F1: Insert a new worksheet tab.
- Ctrl + F4: Close the current workbook.
- Ctrl + D: Launches the Fill Down command for the selected cells below. Fill Down copies contents and format of the topmost cell in the column.
No comments:
Post a Comment