M.S Excel shortcut key in computer

M.S Excel shortcut key in computer:-Hello friends welcome to yourstudynotes.com Today’s post is excel shortcut key, hope you like this post, stay on our website

Ctrl +B Bold
Ctrl +I italic
Ctrl +U underline
Ctrl +Z Undo
Ctrl +Y Redo
Ctrl +C Copy
Ctrl +X Cut
Ctrl +v Paste
Esc Cancle a cell entry
Backspace Delete the character to the left of the insertion point, or delete the selection
Delete Delete the character to the right of the insertion point, or delete the selection
Ctrl +N Create a new blank work
Ctrl +O Open file
Alt + F4 Close Excel
Ctrl + S Save the active file
F12 Save as the active file
Ctrl+ P Print file
F10/alt turn key tips on or off
F1 Display tha excel help task pane
F7 Display the spelling dialog box
Shift + F7 Display tha thesaurus dialog box
Alt +F8 Display the macro dialog box
Alt + F11 Open the visual basic editor to create macros
F2 Edit cell
Ctrl+shift+7 Apply outline border from cell or selection
Ctrl+Shift+_(Underscore) Remove outline border from cell or selection
Alt+HB, O Bottom border
Alt+HB, P Top Border
Alt+ HB, R Right border
Alt+ HB, L Left border
Alt+ HB, A All Border
Alt+HB, N No Border
Ctrl+5 Apply the strike through formatting
Ctrl+ Shift+~ Apply the general number format
ctrl+Shift+1 Apply the number format with two decimal place, thousand separator and minus sign(-) for negative value
Ctrl+Shift+2 Apply the time format with the hour and minute and indicate AM and PM
Ctrl+Shift+3 Apply the date format with the day, month and year
Ctrl+Shift+4 Apply the currency format with two decimal places
Ctrl+Shift+5 Apply the percentage format with no decimal places
Ctrl+Shift+6 Apply the scientific number format with two decimal places
Alt+H, AL Align left
Alt+H, AR Align Right
Alt+H, AC Align Center
Alt+H, AT Align Top
Alt+H, AM Align middle
Alt+H- AB Align Bottom
Alt+H, W Wrap or unwrap text
Alt+H, H Highlight cell (change cell background color)
Alt+H, FC Font color
Alt+H, FS Font size
Alt+H, MM Merge cells – Merge
Alt+H, MU Merge cells – unmerge
Alt+H, MC Merge cells – Merge and center
Alt+H, MA Merge cells – Merge Across
Ctrl+ Delete Delete text to the end of the line
Ctrl+;(Semicolon) Insert current date
Ctrl+ shift+:(colon) Insert current time
Ctrl+’ Duplicate value from cell above into current cell
Shift+ Space Select the entire row
Ctrl+ space Select the entire column
Ctrl + 0 (zero) Hide the selected columns (Since excel 2010)
Ctrl+ K Insert the hyperlink
Ctrl +9 Hide the selected rows
Ctrl + shift + 9 Hide the selected columns (since Excel 2010)