Top 100 Excel Shortcut Keys

By | January 12, 2020

Top 100 Excel Shortcut Keys

MS Excel Shortcut Very Helping in office, accounting and data entry works. Some Shortcut Key is followings. See top 100 Excel Shortcut Keys-

F2: Edit the selected cell.

F5 – Go to a specific cell.

F7 – Spell check of the selected text and / or document.

F11 – Create chart

Ctrl + Shift +; – Enter current time zone.

Ctrl +; – Enter the current date

Alt + Shift + F1: Insert into new worksheets.

Shift + F3: Opens the Excel formula window.

Shift + F5: open the search box

Ctrl + A: Select the entire contents of a worksheet.

Ctrl + B: selection highlighted in bold.

Ctrl + I – Italicize the highlighted selection.

Ctrl + C: copy the selected text.

Ctrl + V – Paste

Ctrl + D – Fill

Ctrl + K – Insert link

Ctrl + F: opens the search and replace options.

Ctrl + G: Open the access options.

Ctrl + H: opens the search and replace options.

Ctrl + U – Underline highlighted selection.

Ctrl + Y – Underline the selected text.

Ctrl + 5 – Strike selection highlighted.

Ctrl + O – Open options.

Ctrl + N: Open a new document.

Ctrl + P – Open print dialog box.

Ctrl + S – Save.

Ctrl + Z – Undo the last action.

Ctrl + F9 – Minimizes the current window.

Ctrl + F10 – Maximize the current selected windows.

Ctrl + F6: switch between open books / windows.

Ctrl + Page Up and Page Down: move between Excel sheets in the same document.

Ctrl + Tab: move two or more open Excel file

Alt + = – Create the formula to add all the previous cells.

Ctrl +: Insert the value of the previous cell in the current cell.

Ctrl + Shift +! – Comma format number.

Ctrl + Shift + $ – Format number in currency format.

Ctrl + Shift + # – Number format in date format.

Ctrl + Shift +% – Format number of percentage marks.

Ctrl + Shift + ^ – Format number in scientific Mark.

Ctrl + Shift + @ – Number format in time format.

Ctrl + (right arrow): Go to the next section of text.

Ctrl + Space: select the entire column.

Shift + space: select the entire row.

Ctrl + W – Close the document.

Excel Shortcut Keys

MS Word Shortcut Keys

 

Top 100 Excel Shortcut Keys and Outlook shortcut keys

Alt + S: Send the email.

Ctrl + C: copy the selected text.

Ctrl + X – Cut the selected text.

Ctrl + P – Open print dialog box.

Ctrl + K: full name / email written in the address bar.

Ctrl + B: selection highlighted in bold.

Ctrl + I – Italicize the highlighted selection.

Ctrl + U – Underline highlighted selection.

Ctrl + R: reply to an email.

Ctrl + F: resend an email.

Ctrl + N: Create a new email.

Ctrl + Shift + A – Create a new appointment for your calendar.

Ctrl + Shift + O: Open the output tray.

Ctrl + Shift + I: Open the inbox.

Ctrl + Shift + K: Add a new taskbar.

Ctrl + Shift + C – Create a new contacts.

Ctrl + Shift + J: Create a new journal entry.

Related Link

UPS Full Form

GDP Full Form

 Festivalsms

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *