15 advanced shortcuts in Excel for better productivity

rawpixel-645294-unsplash

EXCEL

Quick Sum of Data – Alt + =

Fill Selected Range (Current Cell Data) – Select Range + Ctrl + Enter

Paste Values – Alt + E + S + V + Enter

Paste Formatting – Alt + E + S + T + Enter

Transpose Paste Values – Alt + E + S + V + E + Enter

Group Rows/Columns – Alt + Shift + Right Arrow + R or C + Enter

Group Rows/Columns – Alt + Shift + Left Arrow + R or C + Enter

Collapse Group Rows/Columns – Alt + A + H

Expand Group Rows/Columns – Alt + A + J

Add Rows/Columns – Ctrl + (+) + R or C + Enter

Remove Rows/Columns – Ctrl + (-) + R or C + Enter

Select Current Data Range – Ctrl + *

Create Filter for Data Range – Highlight Cells + Ctrl + Shift + L

Remove Filter – Highlight Filtered Cells + Ctrl + Shift + L

Select Visible Values (Only) – Alt + ;

This site uses Akismet to reduce spam. Learn how your comment data is processed.