LEARN WITH FUN या शैक्षणिक ब्लॉग मध्ये आपले सहर्ष स्वागत.


Excel Short Key

Excel short key


📀F2 Edit the selected cell

📀F5 Go to a specific cell

📀 F7 Spell check selected text and/or document

📀 F11 Create chart

📀 Ctrl + Shift + ; Enter the current time

📀Ctrl + ; Enter the current date

📀 Alt + Shift + F1 Insert new worksheet

📀Shift + F3 Open the Excel® formula window

📀Shift + F5 Bring up search box

📀Ctrl + A Select all contents of worksheet

📀Ctrl + B Bold highlighted selection

📀Ctrl + I Italicize highlighted selection

📀Ctrl + C Copy selected text

📀Ctrl + V Paste

📀Ctrl + D Fill

📀Ctrl + K Insert link

📀Ctrl + F Open find and replace options

📀Ctrl + G Open go-to options

📀Ctrl + H Open find and replace options

📀Ctrl + U Underline highlighted selection

📀Ctrl + Y Underline selected text

📀Ctrl + 5 Strikethrough highlighted selection

📀 Ctrl + O Open options

📀Ctrl + N Open new document

📀Ctrl + P Open print dialog box

📀Ctrl + S Save

📀Ctrl + Z Undo last action

📀Ctrl + F9 Minimize current window

📀 Ctrl + F10 Maximize currently selected window

📀Ctrl + F6 Switch between open workbooks/windows

📀Ctrl + Page up & Page Down Move between Excel® worksheets in the same document

📀Ctrl + Tab Move between two or more open Excel® files


📀Alt + = Create formula to sum all of above cells Ctrl + ‘ Insert value of above cell into current

📀cell Ctrl + Shift + ! Format number in comma format

📀Ctrl + Shift + $ Format number in currency format

📀 Ctrl + Shift + # Format number in date format

📀Ctrl + Shift + % Format number in percentage format

📀Ctrl + Shift + ^ Format number in scientific format

📀Ctrl + Shift + @ Format number in time format

📀Ctrl + g Move to next section of text

📀Ctrl + Space Select entire column

📀 Shift + Space Select entire row

📀Ctrl + W Close document

No comments:

Post a Comment