टिप्स & ट्रिक्स

Excel Key-शार्टकट -की

Excel-शार्टकट -की

KEY  Action
Ctrl + O Open  File
Ctrl + C Copy
Ctrl + X Cut
Ctrl + V Paste
Ctrl + Z Undo
Ctrl + A Select All
Ctrl + Y Redo
Ctrl + F Find
Ctrl + D Font
Ctrl + Shift +P Font Size Select
Shift+ F3 Change Case
Ctrl + B Bold
Ctrl + I Italic
Ctrl + E Center  Para
Ctrl + L Left  Para
Ctrl + R Right  Para
Ctrl +Shift + H Hidden
Ctrl + Alt + (1 To 9) Select  Tab
Alt + Ctrl +1 Apply Heading 1
Alt + Ctrl +2 Apply Heading 2
Ctrl + Shift + L Apply Bullet
Alkt + Ctrl + H Highlight
Shift + F3 Change Case
Ctrl + Shift + Tab Previous Tab
Ctrl + P Print
Ctrl + F2 Print Preview
Ctrl +S Save Page
Ctrl +Shift + D Bookmark all Tabs
Ctrl + + Zoom  In
Ctrl + – Zoom Out
Ctrl + Shift +F5 Bookmark
Ctrl + Z Undo
Alt + Shift + Backspace Redo
Ctrl + F6 Next  Window
Alt + Shift +F Merge Field
Ctrl + Shift + Q Symbol  Font
Ctrl + H Replace
Alt + Shift + A Show  All Headings
Alt + Shift + 1 Show Headings 1
Alt + Shift + 2 Show Headings 2
Alt + Clear(Num 5) Select  Table
F3 Find Again
Ctrl + A Select all contents of the page.
Ctrl + M Indent the paragraph.
Ctrl + N Opens new, blank document window.
Ctrl + D Open the font preferences window.
Ctrl + J Aligns the selected text or line to justify the screen.
Ctrl + K Insert a hyperlink.
Ctrl + Shift + L Quickly create a bullet point.
Ctrl + Shift + F Change the font.
Ctrl + Shift + > Increase selected font +1pts up to 12pt and then increase font +2pts.
Ctrl + ] Increase selected font +1pts.
Ctrl + Shift + < Decrease selected font -1pts if 12pt or lower; if above 12, decreases font by +2pt.
Ctrl + [ Decrease selected font -1pts.
Ctrl + / + c Insert a cent sign (¢).
Ctrl + Shift + L Quickly create a bullet point.
Ctrl + Shift + * View or hide non printing characters.
Ctrl + <left arrow> Moves one word to the left.
Ctrl + <right arrow> Moves one word to the right.
Ctrl + <up arrow> Moves to the beginning of the line or paragraph.
Ctrl + <down arrow> Moves to the end of the paragraph.
Ctrl + Del Deletes word to right of cursor.
Ctrl + Backspace Deletes word to left of cursor.
Ctrl + End Moves the cursor to the end of the document.
Ctrl + Home Moves the cursor to the beginning of the document.
Ctrl + Spacebar Reset highlighted text to the default font.
Ctrl + 1 Single-space lines.
Ctrl + 2 Double-space lines.
Ctrl + 5 1.5-line spacing.
Ctrl + Alt + 1 Changes text to heading 1.
Ctrl + Alt + 2 Changes text to heading 2.
Ctrl + Alt + 3 Changes text to heading 3.
Ctrl + F1 Open the Task Pane.
F4 Repeat the last action performed (Word 2000+)
F5 Open the Find, Replace, and Go To window in Microsoft Word.
F7 Spellcheck and grammar check selected text or document.
F12 Save As.
Shift + F3 Change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word.
Shift + F7 Runs a Thesaurus check on the selected word.
Shift + F12 Save the open document. Just like Ctrl + S.
Shift + Enter Create a soft break instead of a new paragraph.
Shift + Insert Paste.
Shift + Alt + D Insert the current date.
Shift + Alt + T Insert the current time.
Alt + Ctrl + U Update Auto Format
F1 Help
Alt + F4 Exit
Ctrl + F4 Close Tab
F2 Edit the selected cell.
F3 After a name has been created, F3 will paste names.
F4 Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.
F5 Go to a specific cell. For example, C6.
F7 Spell check selected text or document.
F11 Create chart from selected data.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + F1 Insert New Worksheet.
Alt + Enter While typing text in a cell, pressing Alt + Enter will move to the next line, allowing for multiple lines of text in one cell.
Shift + F3 Open the Excel formula window.
Shift + F5 Bring up search box.
Ctrl + 1 Open the Format Cells window.
Ctrl + A Select all contents of the worksheet.
Ctrl + B Bold highlighted selection.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + S Save the open worksheet.
Ctrl + U Underline highlighted selection.
Ctrl + 1 Change the format of selected cells.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + P Bring up the print dialog box to begin the printing process.
Ctrl + Z Undo last action.
Ctrl + F3 Open Excel Name Manager.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks or windows.
Ctrl + Page up Move between work sheets in the same document.
Ctrl + Page down Move between work sheets in the same document.
Ctrl + Tab Move between Two or more open Excel files.
Alt + = Create a formula to sum all of the above cells.
Ctrl + ‘ Insert the value of the above cell into the cell currently selected.
Ctrl + Shift + 1 Format number in comma format.
Ctrl + Shift + 4 Format number in currency format.
Ctrl + Shift + 3 Format number in date format.
Ctrl + Shift + 5 Format number in percentage format.
Ctrl + Shift + 6 Format number in scientific format.
Ctrl + Shift + 2 Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Space Select entire column.
Shift + Space Select entire row.
Ctrl + – Delete the selected column or row.
Ctrl + Shift + = Insert a new column or row.
Ctrl + Home Move to cell A1.

images x

About the author


नमस्कार दोस्तों, आप सभी का chiplevels.com में स्वागत है। यहाँ पर आपको Computer / Laptop Hardware के chiplevel स्तर तक के नोट्स मिलेंगे। जो लोग Computer / Laptop Hardware का course नहीं कर पाते है, वे हमारे ब्लॉग से Basic जानकारी प्राप्त कर सकते है।
अधिक जानकारी के लिए यहाँ क्लिक करें |

Add Comment

Click here to post a comment