Excel shortcuts keys

A-Z of excel shortcuts to multiply your productivity in reports

Do you know about excel shortcuts?

Almost everyone knows about the excel shortcuts, but few of us use them.

Humans are the master of procrastination. We always try to be in our comfort zone, but we don’t know that our success lies out of our comfort zone.

We know that we can increase our productivity by learning these short keys; however, we love to move the mouse cursor on every corner of the screen.

Big data is the next thing in digital marketing. And if you have calculated that most of the time we spend to analyze the data on business intelligence platforms, social campaigns, estimation and post campaign reports.

Luckily, we have Microsoft excel,  one of the best tool available in the market to analyze your data to the deepest level of understanding. However, if you want to multiply your productivity and to get work done in best possible time, then you have to memorize these excel shortcut keys.

It’s a bit difficult memorize all of them but at least you can keep practicing those keys that are frequently used in your routine.
Ctrl+A: Excel shortcuts use to select the entire sheet

 Ctrl+A

If you want to copy or cut the entire sheet, so no need to move your arrow from top to bottom. You can simply press Ctrl+A and the entire sheet will be selected.

Ctrl+B: Excel shortcuts use to bold or unbold the sentence in an excel sheet

Ctrl+B

If you want to highlight the selected cell by making it bold, Ctrl+B is the right option for you. You can bold or unbold the text by this excel shortcut key.

Ctrl+C: Excel shortcuts use to copy the content in excel

Ctrl+C

Want to copy the content in same sheet or other? Ctrl+C does that for you.

Ctrl+D: Excel shortcuts use to fill down

Ctrl+D

Do you want to copy the content of the selected cell in the following cell? Simply select and copy the cell and drag your mouse down, and press Ctrl+D and all the content of the selected cell will be copied in the following cell.

Ctrl+F to person use in excel shortcuts to open the dialogue box

Ctrl+F

Want to replace the text? Press Ctrl+F and it will open the dialogue box and then you can find the desired word and replace it.

Ctrl+G: Excel shortcuts use to open the dialogue box

Ctrl+G

It opens the dialogue box. You can do the same function with F5 as well.

Ctrl+H: Excel shortcuts use to replace the content

Ctrl+H

Want to replace the content of your sheet with something else? Press Ctrl+H and it will open the find and replace dialogue box.

Ctrl+I: Excel shortcuts use to make the word Italic

Ctrl+I

Want to highlight or notify the content? Press Ctrl+I and it will apply or remove the italic formatting.

Ctrl+K: Excel shortcuts use to insert or to remove the hyperlink

Ctrl+K

Do you want to insert a hyperlink or modify the existing link, Ctrl+K doest that for you.

 

Ctrl+N: Excel shortcuts use to create new sheet

Ctrl+N

It creates the new blank sheet within the same workbook.

Ctrl+O: Excel shortcuts use to open a new document

Ctrl+O

Want to open a new document? Ctrl + O doest that for you.

Ctrl+P: Excel shortcuts use to print the document

Ctrl+P

It’s a shortcut key for document printing.

Ctrl+R: Excel shortcuts use to fill right

Ctrl+R

This is the similar function to Ctrl+D, the only difference is it works only right and left, while Ctrl+D works with the following cell.

Ctrl+S: Excel shortcuts use to save the work in a workbook

Ctrl+S

It saves your work that you have done on the site.

Ctrl+T function in excel shortcutsCtrl+T

Want to create the table? Ctrl+T will open the create table dialogue box.

Ctrl+U: Excel shortcuts use to underline or remove the underline

 Ctrl+U

This key applies or removes the underline formatting.

Ctrl+V: Excel shortcuts use to paste the copied the item

Ctrl+V

Want to paste something on the sheet? do it with Ctrl+V

Ctrl+W: Excel shortcuts use to close the workbook

Ctrl+W

It closes your selected work window.

Ctrl+X:Excel shortcuts use to cut the content

Ctrl+x

Cut any content from your sheet and paste anywhere you want.

Ctrl+Y function in excel shortcuts

Ctrl+Y

It repeats the last command (depends on the possibility of the function)

Ctrl+Z: Excel shortcuts use to undo the work

Ctrl+Z

Mistakenly did something, luckily excel has the key Ctrl+Z to undo what you have done.

Leave a Reply