ms excel sort cut key | computer sort cut key | laptop sort cut key #TheVasudev

Windows shortcuts on the left, Mac shortcuts on the right.
See also: 30 Excel Shortcuts in 12 minutes and Excel shortcuts on the Mac.

File

Create new workbook
CtrlN
тМШN
Open workbook
CtrlO
тМШO
Save workbook
CtrlS
тМШS
Save as
F12
тМШтЗзS
Print file
CtrlP
тМШP
Open print preview window
CtrlF2
Close current workbook
CtrlW
тМШW
Close Excel
AltF4
тМШQ

Ribbon

Expand or collapse ribbon
CtrlF1
тМШтМеR
Activate access keys
Alt
Move to next ribbon control
Tab
Tab
Activate or open selected control
Space
Space
Confirm control change
Enter
Return
Get help on selected control
F1

General

Open options
AltFT
тМШ,
Open help
F1
тМШ/
Undo last action
CtrlZ
тМШZ
Redo last action
CtrlY
тМШY
Repeat last action
F4
тМШY
Copy selected cells
CtrlC
тМШC
Cut selected cells
CtrlX
тМШX
Paste content from clipboard
CtrlV
тМШV
Display the Paste Special dialog box
CtrlAltV
тМШтМГV
Display find and replace
CtrlF
тМШF
Display find and replace, replace selected
CtrlH
тМГH
Find next match
ShiftF4
тМШG
Find previous match
CtrlShiftF4
тМШтЗзG
Create embedded chart
AltF1
FnтМеF1
Create chart in new worksheet
F11
FnF11

Tables and Filters

Insert table
CtrlT
тМГT
Toggle Autofilter
CtrlShiftL
тМШтЗзF
Activate filter
AltтЖУ
тМетЖУ
Select table row
ShiftSpace
тЗзSpace
Select table column
CtrlSpace
тМГSpace
Select table
CtrlA
тМШA
Clear slicer filter
AltC
тМеC
Toggle table total row
CtrlShiftT
тМШтЗзT

Drag and Drop

Drag and cut
drag
drag
Drag and copy
Ctrldrag
тМеdrag
Drag and insert
Shiftdrag
тЗзdrag
Drag and insert copy
CtrlShiftdrag
тМетЗзdrag
Drag to worksheet
Altdrag
тМШdrag
Drag to duplicate worksheet
Ctrldrag
тМеdrag

Navigation

Move one cell right
тЖТ
тЖТ
Move one cell left
тЖР
тЖР
Move one cell up
тЖС
тЖС
Move one cell down
тЖУ
тЖУ
Move one screen right
AltPgDn
FnтМетЖУ
Move one screen left
AltPgUp
FnтМетЖС
Move one screen up
PgUp
FnтЖС
Move one screen down
PgDn
FnтЖУ
Move to right edge of data region
CtrlтЖТ
тМГтЖТ
Move to left edge of data region
CtrlтЖР
тМГтЖР
Move to top edge of data region
CtrlтЖС
тМГтЖС
Move to bottom edge of data region
CtrlтЖУ
тМГтЖУ
Move to beginning of row
Home
FnтЖР
Move to last cell in worksheet
CtrlEnd
FnтМГтЖТ
Move to first cell in worksheet
CtrlHome
FnтМГтЖР
Turn End mode on
End
FnтЖТ
Go back to hyperlink
CtrlGEnter
тМГGReturn

Selection

Select entire row
ShiftSpace
тЗзSpace
Select entire column
CtrlSpace
тМГSpace
Select entire worksheet
CtrlA
тМШA
Add adjacent cells to selection
ShiftClick
тЗзClick
Add non-adjacent cells to selection
CtrlClick
тМШClick
Same selection in next column
тМеTab
Same selection in previous column
тМетЗзTab
Move right between non-adjacent selections
CtrlAltтЖТ
тМГтМетЖТ
Move left between non-adjacent selections
CtrlAltтЖР
тМГтМетЖР
Toggle add to selection mode
ShiftF8
FnтЗзF8
Cancel selection
Esc
Esc

Active Cell

Select active cell only
ShiftBackspace
тЗзDelete
Show the active cell on worksheet
CtrlBackspace
тМШDelete
Move active cell clockwise in selection
Ctrl.
тМГ.
Move active cell down in selection
Enter
Return
Move active cell up in selection
ShiftEnter
тЗзReturn
Move active cell right in a selection
Tab
Tab
Move active cell left in a selection
ShiftTab
тЗзTab

Extend Selection

Extend selection by one cell right
ShiftтЖТ
тЗзтЖТ
Extend selection by one cell left
ShiftтЖР
тЗзтЖР
Extend selection by one cell up
ShiftтЖС
тЗзтЖС
Extend selection by one cell down
ShiftтЖУ
тЗзтЖУ
Extend the selection to the last cell right
CtrlShiftтЖТ
тМГтЗзтЖТ
Extend the selection to the last cell left
CtrlShiftтЖР
тМГтЗзтЖР
Extend the selection to the last cell up
CtrlShiftтЖС
тМГтЗзтЖС
Extend the selection to the last cell down
CtrlShiftтЖУ
тМГтЗзтЖУ
Extend selection up one screen
ShiftPgUp
FnтЗзтЖС
Extend selection down one screen
ShiftPgDn
FnтЗзтЖУ
Extend selection right one screen
AltShiftPgDn
FnтЗзтМетЖУ
Extend selection left one screen
AltShiftPgUp
FnтЗзтМетЖС
Extend selection to start of row
ShiftHome
FnтЗзтЖР
Extend selection to first cell in worksheet
CtrlShiftHome
FnтМГтЗзтЖР
Extend selection to last cell in worksheet
CtrlShiftEnd
FnтМГтЗзтЖТ
Toggle extend selection mode
F8
FnF8

Select Special

Display 'Go To' dialog box
CtrlG
тМГG
Select cells with comments
CtrlShiftO
FnтМГтЗзO
Select current region around active cell
CtrlShift*
тЗзтМГSpace
Select current region
CtrlA
тМШA
Select current array
Ctrl/
тМГ/
Select row differences
Ctrl\
тМГ\
Select column differences
CtrlShift|
тМГтЗз|
Select direct precedents
Ctrl[
тМГ[
Select all precedents
CtrlShift{
тМГтЗз{
Select direct dependents
Ctrl]
тМГ]
Select all dependents
CtrlShift}
тМГтЗз}
Select visible cells only
Alt;
тМШтЗзZ

Cell edit mode

Edit the active cell
F2
тМГU
Insert or edit comment
ShiftF2
FnтЗзF2
Cancel entry
Esc
Esc
Select one character right
ShiftтЖТ
тЗзтЖТ
Select one character left
ShiftтЖР
тЗзтЖР
Move one word right
CtrlтЖТ
тМГтЖТ
Move one word left
CtrlтЖР
тМГтЖР
Select one word right
CtrlShiftтЖТ
тМГтЗзтЖТ
Select one word left
CtrlShiftтЖР
тМГтЗзтЖР
Select to beginning of cell
ShiftHome
FnтЗзтЖР
Select to end of cell
ShiftEnd
FnтЗзтЖТ
Delete to end of line
CtrlDelete
тМГDelete
Delete character to the left of cursor
Backspace
Delete
Delete character to the right of cursor
Delete
FnDelete
Start a new line in the same cell
AltEnter
тМГтМеReturn

Entering data

Enter and move down
Enter
Return
Enter and move up
ShiftEnter
тЗзReturn
Enter and move right
Tab
Tab
Enter and move left
ShiftTab
тЗзTab
Complete entry and stay in same cell
CtrlEnter
тМГReturn
Enter same data in multiple cells
CtrlEnter
тМГReturn
Insert current date
Ctrl;
тМГ;
Insert current time
CtrlShift:
тМШ;
Fill down from cell above
CtrlD
тМГD
Fill right from cell left
CtrlR
тМГR
Copy formula from cell above
Ctrl'
тМГ'
Copy value from cell above
CtrlShift"
тМГтЗз"
Add hyperlink
CtrlK
тМШK
Display AutoComplete list
AltтЖУ
тМетЖУ
Flash fill
CtrlE

Formatting

Format (almost) anything
Ctrl1
тМШ1
Display Format Cells with Font tab selected
CtrlShiftF
тМГтЗзF
Apply or remove bold formatting
CtrlB
тМШB
Apply or remove italic formatting
CtrlI
тМШI
Apply or remove underscoring
CtrlU
тМШU
Apply or remove strikethrough formatting
Ctrl5
тМШтЗзX
Add or remove the shadow font style
 
тМШтЗзW
Add or remove the outline font style
 
тМШтЗзD
Align center
AltHAC
тМШE
Align left
AltHAL
тМШL
Align right
AltHAR
тМШR
Indent
AltH6
тМГтМеTab
Remove indent
AltH5
тМГтМетЗзTab
Increase font size one step
AltHFG
тМШтЗз>
Decrease font size one step
AltHFK
тМШтЗз<

Number Formatting

Apply general format
CtrlShift~
тМГтЗз~
Apply currency format
CtrlShift$
тМГтЗз$
Apply percentage format
CtrlShift%
тМГтЗз%
Apply scientific format
CtrlShift^
тМГтЗз^
Apply date format
CtrlShift#
тМГтЗз#
Apply time format
CtrlShift@
тМГтЗз@
Apply number format
CtrlShift!
тМГтЗз!

Borders

Add border outline
CtrlShift&
тМШтМе0
Add or remove border right
AltR
тМШтМетЖТ
Add or remove border left
AltL
тМШтМетЖР
Add or remove border top
AltT
тМШтМетЖС
Add or remove border bottom
AltB
тМШтМетЖУ
Add or remove border upward diagonal
AltD
Add or remove border horizontal interior
AltH
Add or remove border vertical interior
AltV
Remove borders
CtrlShift_
тМШтМе_

Formulas

Toggle absolute and relative references
F4
тМШT
Open the Insert Function Dialog Box
ShiftF3
FnтЗзF3
Autosum selected cells
Alt=
тМШтЗзT
Toggle formulas on and off
Ctrl`
тМГ`
Insert function arguments
CtrlShiftA
тМГтЗзA
Enter array formula
CtrlShiftEnter
тМГтЗзReturn
Calculate worksheets
F9
FnF9
Calculate active worksheet
ShiftF9
FnтЗзF9
Force calculate all worksheets
CtrlAltF9
Evaluate part of a formula
F9
FnF9
Expand or collapse the formula bar
CtrlShiftU
тМГтЗзU
Display function arguments dialog box
CtrlA
тМГA
Define name
CtrlF3
FnтМГF3
Define name using row and column labels
CtrlShiftF3
FnтМГтЗзF3
Paste name into formula
F3
Accept function with autocomplete
Tab
тЖУTab

Grid Operations

Display Insert Dialog box
CtrlShift+
тМШтЗз+
Insert rows
CtrlShift+
тМШтЗз+
Insert columns
CtrlShift+
тМШтЗз+
Display Delete dialog box
Ctrl-
тМШ-
Delete rows
Ctrl-
тМШ-
Delete columns
Ctrl-
тМШ-
Delete cells
Ctrl-
тМШ-
Delete contents of selected cells
Delete
FnDelete
Hide columns
Ctrl0
тМГ0
Hide rows
Ctrl9
тМГ9
Unhide rows
CtrlShift9
тМГтЗз9
Unhide columns
CtrlShift0
тМГтЗз0
Group rows or columns
AltShiftтЖТ
тМШтЗзK
Ungroup rows or columns
AltShiftтЖР
тМШтЗзJ
Open Group Dialog Box
AltShiftтЖТ
тМШтЗзK
Open Ungroup Dialog Box
AltShiftтЖР
тМШтЗзJ
Hide or show outline symbols
Ctrl8
тМГ8
Zoom in
CtrlAlt+
тМетМШ+
Zoom out
CtrlAlt-
тМетМШ-

Pivot Tables

Select entire pivot table
CtrlA
тМШA
Toggle pivot table field checkbox
Space
Space
Group pivot table items
AltShiftтЖТ
тМШтЗзK
Ungroup pivot table items
AltShiftтЖР
тМШтЗзJ
Hide pivot table item
Ctrl-
Ctrl-
Create pivot chart on same worksheet
AltF1
Create pivot chart on new worksheet
F11
FnF11
Open pivot table wizard
AltDP
тМШтМеP

Workbook

Insert new worksheet
ShiftF11
fnтЗзF11
Go to next worksheet
CtrlPgDn
FnтМГтЖУ
Go to previous worksheet
CtrlPgUp
FnтМГтЖС
Move to next pane
F6
FnF6
Move to previous pane
ShiftF6
FnтЗзF6
Go to next workbook
CtrlTab
тМГTab
Go to previous workbook
CtrlShiftTab
тМГтЗзTab
Minimize current workbook window
CtrlF9
тМШM
Maximize current workbook window
CtrlF10
fnтМГF10
Select adjacent worksheets
ShiftClick
тЗзClick
Select non-adjacent worksheets
CtrlClick
тМШClick
Toggle scroll lock
ScrLk
FnтЗзF14
Toggle full screen
CtrlShiftF1
тМГтМШF

Dialog boxes

Move to next control
Tab
Tab
Move to previous control
ShiftTab
тЗзTab
Move to next tab
CtrlTab
тМГTab
Move to previous tab
CtrlShiftTab
тМГтЗзTab
Accept and apply
Enter
Return
Check and uncheck box
Space
Space
Cancel and close the dialog box
Esc
Esc

Other

Open Spelling dialog box
F7
FnF7
Open Thesaurus dialog box
ShiftF7
FnтЗзF7
Open Macro dialog box
AltF8
FnтМеF8
Open VBA Editor
AltF11
FnтМеF11
Duplicate object
CtrlD
тМШD
Snap to grid
Alt
тМШ
Hide or show objects
Ctrl6
тМГ6
Display Modify Cell Style dialog box
Alt'
тМШтЗзL
Display right-click menu
ShiftF10
FnтЗзF10
Delete comment
ShiftF10D
fnShiftF10
Display control menu
AltSpace
?

Can we ask you a favor? Can you please share this page if it's useful to you? Thanks!

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Comments

Post a Comment

Give us feedback

Popular posts from this blog

Noc paper request to present company #noc #nocpaper #companychange #qatarnews #thevasudev

  N o need of noc paper  but need to inform to present company befor 1 month minimum  so be request by post office so you has a proof. Respectfully Sir / Madam,      Most respectfully, I am writing this letter to request you for the provision of NOC. I am to apply for a vacant post in (Company/Institute name). The requirement for the application is the NOC from the current employer. (Describe in your own words).  As this post is most relevant to my qualification, so I want to apply for this post. (Explain the actual cause and situation) Kindly issue me the NOC, so that I can complete the application by the due date. (describe your requirements). I shall be very thankful to you for this act of kindness. Yours Sincerely, Your name... Present Job Designation... Company/Institute Name..
Read more

blog par paise kese kamayei | how can income on blog

Image
5 Tricks: Blog Se Paise Kaise Kamaye Step By Step Complete Guide   Share Blog Se Paise Kaise Kamaye:  Hello FriendтАЩs рдЖрдЬ рдХреЗ рдЗрд╕ Article рдореЗрдВ рд╣рдо рдЖрдкрдХреЛ рдмрддрд╛рдиреЗ рд╡рд╛рд▓реЗ рд╣реИрдВ рдХрд┐ рдЖрдк рдЕрдкрдиреЗ Blog Se Paise Kaise Kamaye рдЬрд┐рд╕рд╕реЗ рдЖрдк рдЕрдкрдиреЗ Blog рд╕реЗ рдЬреНрдпрд╛рджрд╛ рд╕реЗ рдЬреНрдпрд╛рджрд╛ Earning рдХрд░ рд╕рдХрддреЗ рд╣реИрдВред Blog Se Paise Kaise Kamaye рдЖрдЬ рдЬреНрдпрд╛рджрд╛рддрд░ New Bloggers рд╕рд┐рд░реНрдл рдпрд╣ рд╣реА рд╕реЛрдЪрддреЗ рд╣реИрдВ рдХрд┐ рд╡рд╣ рдРрд╕рд╛ рдХреНрдпрд╛ рдХрд░реЗрдВ рдЬрд┐рд╕рд╕реЗ рд╡рд╣ рдЕрдкрдиреЗ Blog рд╕реЗ рдЬреНрдпрд╛рджрд╛ рд╕реЗ рдЬреНрдпрд╛рджрд╛ Earning рдХрд░ рд╕рдХреЗрдВ рддреЛ рдЕрдЧрд░ рдЖрдк рднреА рдРрд╕рд╛ рд╣реА рд╕реЛрдЪ рд░рд╣реЗ рд╣реИрдВ рддреЛ рдЖрдЬ Blog Se Paise Kaise Kamaye Post рдореЗрдВ рд╣рдо рдЖрдкрдХреЛ 5 Tricks рдХреЗ рдмрд╛рд░реЗ рдореЗрдВ рдмрддрд╛рдиреЗ рдЬрд╛ рд░рд╣реЗ рд╣реИрдВ, рдЬрд┐рдирдХрд╛ рдЗрд╕реНрддрд┐рдорд╛рд▓ рдХрд░рдХреЗ рдЖрдк рдЕрдкрдиреЗ Blog рд╕реЗ рдЬреНрдпрд╛рджрд╛ Earning рдХрд░ рд╕рдХрддреЗ рд╣реИрдВред рд▓реЗрдХрд┐рди рдРрд╕рд╛ рдХрд░рдиреЗ рдХреЗ рд▓рд┐рдП рдЖрдкрдХреЗ Blog рдореЗрдВ рдХреБрдЫ Qualities рдХрд╛ рд╣реЛрдирд╛ рдмрд╣реБрдд рд╣реА рдЬреНрдпрд╛рджрд╛ рдЬрд░реБрд░реА рд╣реИ, рдЕрдЧрд░ рдпрд╣ Qualities рдЖрдкрдХреЗ Blog рдореЗрдВ рдирд╣реАрдВ рд╣реИ рддреЛ рдЖрдк рдкрд╣рд▓реЗ рдЗрдиреНрд╣реЗ Improve рдХрд░рдиреЗ рдкрд░ Focus рдХрд░реЗрдВ рдФрд░ рдлрд┐рд░ рдЗрди рд╕рднреА рддрд░реАрдХреЛрдВ рдХрд╛ рдЗрд╕реНрддрд┐рдорд╛рд▓ рдХрд░реЗрдВред Qualities for your Blog Normally рдПрдХ Blog рдореЗрдВ рдмрд╣реБрдд рд╕рд╛рд░реА Qualities рд╣реЛрдиреА рдЪрд╛рд╣рд┐рдП рд▓реЗрдХрд┐рди рд╣рдо рдпрд╣рд╛рдБ рдЖрдкрдХреЛ рд╕рд┐рд░реНрдл рдХреБрдЫ Important рдЪреАрдЬреЛрдВ рдХреЗ рдмрд╛рд░реЗ рдореЗрдВ рд╣реА рдмрд╛рдд рдХрд░реЗрдВрдЧреЗ рдЬрд┐рдирдХреЗ рдмрд┐рдирд╛ рдЖрдк рдЕрдкрдиреЗ Blog рд╕реЗ Earning рди...
Read more

copy all sort cut key in windows/laptop 2020 all sorts cut key 2020 | laptop sort cut key

Image
  How to Remember Cut, Copy & Paste Keyboard Shortcuts First, select the text or image you wish to cut or copy (it will look similar to this: selected text.) ... Press the "Control" key. ... While continuing to hold down the Control key, press either X, C, or V at the same time to perform the following: ctrl +c Copy any files ctrl + x Cut any file for paste ctrl +v Paste ctrl + win Open my computer ctrl + R Command Prompts ctrl + A All select ctrl + B Bold ctrl + D Deselect Ctrl + E Canter alignment ctrl + F Find go to ctrl + G Go to home ctrl + H Replace ctrl + I Italics ctrl + J Justified ctrl + k Hyperlink ctrl + L Left alignment ctrl + M Minimize ctrl + N New ctrl + O Open ctrl + P Print ctrl + Q Close ctrl + R Run ctrl + S Save ctrl + T Text ctrl + U Underline ctrl + V Paste ctrl + W Close ctrl + X Cut ctrl + Y Repeat ctrl + Z Undo
Read more