Skip to main content

New Article

How to SUM by matching partial text in Excel

Shortcut Keys with CTRL

Basic Excel Shortcut Key:



CTRL+A
Select all in a worksheet

CTRL+B
Font bold

CTRL+C
Copy all selected cells

CTRL+D
Copy the value or formula to down

CTRL+E
Series entry auto fill

CTRL+F
Find

CTRL+G
Go To

CTRL+H
Replace

CTRL+I
Font italic

CTRL+K
Inser a Hyperlink in current cell

CTRL+L
Create a table based on current cell selection data table

CTRL+N
Take new workbook

CTRL+O
Open a old workbook

CTRL+P
Print

CTRL+S
Save

CTRL+T
Create a table based on current cell selection data table (Same as CTRL+L)

CTRL+U
Font underline

CTRL+V
Paste all

CTRL+W
Close the current workbook

CTRL+X
Cut

CTRL+Y
Redo

CTRL+Z
Undo

Comments