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 เคจเคนीं  เค•เคฐ เคธเค•เคคे เคนैं। 0
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