You could learn here about MS excel basis and some advance sort keys.
Formatting sort keys.
CTRL+1 Format Box
ALT+E+S+T Copy Format
ALT+H+0 Increase Decimal
ALT+H+9 Decrees Decimal
CTRL+SHIFT+7 Boxing
ALT+O+C+A Fit Column Width
ALT+H+O+R Change Sheet Tab Name
ALT+W+F (Un)Split Panes
ALT+W+S (Un)Freeze Panes
SHIFT+CTRL+# Date format
SHIFT+CTRL+S $ Dollar format
SHIT+CTRL+% % Percentage format
ALT+"=" Sum function
With CTRL Shortcuts.
CTRL+A Select All
CTRL+B Bold (only selected cell or range)
CTRL+C Copy(only selected cell or range)
CTRL+D Fill down(Select non blank cell or range)
CTRL+E Flash Fill
CTRL+F Find
CTRL+G Go To Special
CTRL+H Replace
CTRL+I Italic
CTRL+K Insert Hyperlink
CTRL+L Create Table
CTRL+N New Workbook
CTRL+O Open existing workbook from your computer
CTRL+P Print
CTRL+R Fill Right
CTRL+S Save workbook
CTRL+T Create Table
CTRL+U Under Line
CTRL+V Paste
CTRL+W Close workbook
CTRL+X Cut
CTRL+Y Redo
CTRL+Z Undo
Function Key Shortcuts.
F1 Go to excel help penal
F2 Edit cell
F3 Show all Name rage list(once you create name range)
F5 Go To Special
F6 Move on Excel status bar
F7 Check spellings
F8 Extend selection
F9 Calculation
F10 Ribbon Negation
F11 Insert chart sheet
F12 Save as workbook
Columns & Row Shortcuts.
CTRL+9 Hide row
SHIFT+CTRL+9 Unhide row
CTRL+0 Hide column
SHIFT+CTRL+0 Unhide column
SHIFT+Space-bar Highlight row ( Select entire row)
SHIFT+Space-bar Highlight column ( Select entire column)
CTRL+"+"(Sign) Show insert popup window when you select only one cell
CTRL+"+"(Sign) Insert entire row or column when you select entire row or column
CTRL+Arrow keys Fast select last non-blank cell
CTRL+SHIFT+Arrow keys Fast select last non-blank cell with range selection
CTRL+PAGE UP Switch worksheet active sheet to backward
CTRL+PAGE DOWN Switch worksheet active sheet to forward
CTRL+HOME Select active sheet A1 cell
CTRL+END Select last cell of used range of active sheet
CTRL+INSET Copy current selection
SHIFT+DELETE Cut current selection
ALT+E+L Delete active worksheet
ENTER Move down
SHIFT+ENTER Move up
CTRL+ENTER Fill the same in current selection range ( Note:- Once select a range and than press F2 and type something and than use ctrl+enter)
Formatting sort keys.
CTRL+1 Format Box
ALT+E+S+T Copy Format
ALT+H+0 Increase Decimal
ALT+H+9 Decrees Decimal
CTRL+SHIFT+7 Boxing
ALT+O+C+A Fit Column Width
ALT+H+O+R Change Sheet Tab Name
ALT+W+F (Un)Split Panes
ALT+W+S (Un)Freeze Panes
SHIFT+CTRL+# Date format
SHIFT+CTRL+S $ Dollar format
SHIT+CTRL+% % Percentage format
ALT+"=" Sum function
With CTRL Shortcuts.
CTRL+A Select All
CTRL+B Bold (only selected cell or range)
CTRL+C Copy(only selected cell or range)
CTRL+D Fill down(Select non blank cell or range)
CTRL+E Flash Fill
CTRL+F Find
CTRL+G Go To Special
CTRL+H Replace
CTRL+I Italic
CTRL+K Insert Hyperlink
CTRL+L Create Table
CTRL+N New Workbook
CTRL+O Open existing workbook from your computer
CTRL+P Print
CTRL+R Fill Right
CTRL+S Save workbook
CTRL+T Create Table
CTRL+U Under Line
CTRL+V Paste
CTRL+W Close workbook
CTRL+X Cut
CTRL+Y Redo
CTRL+Z Undo
Function Key Shortcuts.
F1 Go to excel help penal
F2 Edit cell
F3 Show all Name rage list(once you create name range)
F5 Go To Special
F6 Move on Excel status bar
F7 Check spellings
F8 Extend selection
F9 Calculation
F10 Ribbon Negation
F11 Insert chart sheet
F12 Save as workbook
Columns & Row Shortcuts.
CTRL+9 Hide row
SHIFT+CTRL+9 Unhide row
CTRL+0 Hide column
SHIFT+CTRL+0 Unhide column
SHIFT+Space-bar Highlight row ( Select entire row)
SHIFT+Space-bar Highlight column ( Select entire column)
CTRL+"+"(Sign) Show insert popup window when you select only one cell
CTRL+"+"(Sign) Insert entire row or column when you select entire row or column
CTRL+Arrow keys Fast select last non-blank cell
CTRL+SHIFT+Arrow keys Fast select last non-blank cell with range selection
CTRL+PAGE UP Switch worksheet active sheet to backward
CTRL+PAGE DOWN Switch worksheet active sheet to forward
CTRL+HOME Select active sheet A1 cell
CTRL+END Select last cell of used range of active sheet
CTRL+INSET Copy current selection
SHIFT+DELETE Cut current selection
ALT+E+L Delete active worksheet
ENTER Move down
SHIFT+ENTER Move up
CTRL+ENTER Fill the same in current selection range ( Note:- Once select a range and than press F2 and type something and than use ctrl+enter)
Very useful sort keys
ReplyDelete