500 Excel Shortcut Keys 2019 Full Details
CTRL+A=Select All
CTRL+C=Copy
CTRL+X=Cut
CTRL+V=Paste
CTRL+F=Find
CTRL+H=Replace
CTRL+B=Bold
CTRL+I=Italic
CTRL+U=Underline
CTRL+6=Alternates between hiding objects, displaying objects & displaying placeholders
CTRL+8=Displays or hides the outlines symbol
CTRL+9=Hides the selected rows
CTRL+0=Hides the selected columns
CTRL+SHIFT+&=Applies the outline border to the selected cells
CTRL+SHIFT+~=Applies the General number format
CTRL+SHIFT+$=Applies the Currency format with two decimal places(negative numbers in parentheses)
CTRL+SHIFT+%=Applies the percentage format with no decimal places
F1:
ALT+F1 creates a chart of the data in the in the current range.
ALT+SHIFT+F2 insert a new worksheet.
F2:
Shift+F2 adds or edits a cell comment
CTRL+C=Copy
CTRL+X=Cut
CTRL+V=Paste
CTRL+F=Find
CTRL+H=Replace
CTRL+B=Bold
CTRL+I=Italic
CTRL+U=Underline
CTRL+6=Alternates between hiding objects, displaying objects & displaying placeholders
CTRL+8=Displays or hides the outlines symbol
CTRL+9=Hides the selected rows
CTRL+0=Hides the selected columns
CTRL+SHIFT+&=Applies the outline border to the selected cells
CTRL+SHIFT+~=Applies the General number format
CTRL+SHIFT+$=Applies the Currency format with two decimal places(negative numbers in parentheses)
CTRL+SHIFT+%=Applies the percentage format with no decimal places
F1:
ALT+F1 creates a chart of the data in the in the current range.
ALT+SHIFT+F2 insert a new worksheet.
F2:
Shift+F2 adds or edits a cell comment


Comments
Post a Comment