What are some unique things you can do with Microsoft Excel which people often don't know?

Rajesh Pathak

Here are some of the not-so-common simple to use excel tips:

Double click the format painter to format multiple cells in one go.
Double click any ribbon tab to expand or collapse the ribbon.
Use group and ungroup feature when you don’t want to hide your columns or rows.
Use control and asterisk (*) to select a range instead of using mouse and arrows.
Drag the cells to move your data instead of using copy/cut and paste.
Use Alt Enter in a cell to create a new row within the open cell
Use Alt Q to use Microsoft Search to quickly locate Excel tools