Most Useful Excel Shortcuts in Excel

Some of the most used Excel Shortcuts are here. Each shortcut of Excel can also have an alternative shortcut at times. But the best and most relevant method is updated here.

Tue Mar 29, 2022

Open the Paste Special Window

Upon copying the data, use this shortcut.

To Add a New Conditional Formatting Rule

Select the range of cells or just a cell before using the shortcut

Convert a number to Decimals

Shortcut to convert a numerical value into a Decimal Value format in Excel

Convert a number to Time

Shortcut to convert a numerical value into a Date value format in Excel

Convert a number to Date

Shortcut to convert a numerical value into a Date value format in Excel

Convert a number to Currency

Shortcut to convert a numerical value into currency format in Excel.

Convert a Number to Percent

Shortcut to convert a whole number to percent in Excel

Create Custom Cell Style

Shortcut to create a custom cell style

Highlight Duplicates

Shortcut to highlight duplicates in Excel.

Remove Duplicates

Shortcut to remove duplicates in Excel

To Insert a Bullet point in a cell

Shortcut to insert a bullet point within a cell in Excel

Custom Formatting Window

Shortcut to enable the custom formatting window

To fill a cell with color

Shortcut to fill a cell with color in Excel

To Increase Font Size

Shortcut To increase the font size in Excel

To Decrease Font Size

Shortcut To decrease the font size in Excel

To Hide a column or multiple columns

Shortcut to Select the column(s) that needs to be hidden and apply this shortcut

To Hide a row or multiple rows

Shortcut to Select the row that needs to be hidden and apply this shortcut

To Unhide a Column or multiple Columns

Shortcut to Select the columns that hides the Columns and then apply this shortcut

To Unhide a row or multiple rows

Shortcut to Select the rows that hides the rows and then apply this shortcut

Open Developer Environment or VBA Environment

You can be in any excel sheet and you can Press the shortcut to get to the Developer environment

Open Immediate Editor in VBA Environment

Immediate Editor enables you to check if the code will run well or not. Kind of giving you an test place to check you code.

Launch your Graphy

100K+ creators trust Graphy to teach online

YourExcelGuy 2024 Privacy policy Terms of use Contact us Refund policy