You will save a lot of time on a daily basis by using the Enter key in these 4 ways.

You may think, what is more to learn in using the Enter key in Excel? Read further to know what are the 4 ways and what they can do for you.

Enter (Normal)

When you type anything and press Enter, or even without typing you just press Enter,
– It takes you to the next cell in the next row (1 step down).

Enter (Normal)

Enter (Normal)

Shift + Enter

Normally, when you want to type something, and then go 1 cell up, you end up doing this,

Type – Enter – Up arrow – Up arrow. Rather use Shift +Enter

Thus, when you type anything and press Shift + Enter, or even without typing you just press Shift + Enter,
– It takes you to the next cell in the previous row (1 step Up).

Shift + Enter

Shift + Enter

Alt + Enter

You maybe using the feature Wrap Text in Excel.

– But using Alt + Enter, you can write in the next line, in the same cell.

This will help in a way that you can decide when you want to next line to start (in the same cell). Wrap doesn’t allow¬†that, it wraps the text automatically based on the width of the column.

Thus, when you type something and press Alt + Enter, you will go to the next line in the same cell. Then once you are done typing, press normal Enter. The entire Row’s height will increase automatically.

Alt + Enter

Alt + Enter

Ctrl + Enter

Let’s say you want to type something and then make it Bold. Normally we do this,

Type РEnter РUp arrow РCtrl + B (bold). Rather use Ctrl + Enter and then directly Ctrl + B.

Thus, Ctrl + Enter allows you to stay in the same cell after typing something.

Ctrl + Enter

Ctrl + Enter

Do try these out once. They are amazing and very handy to use everyday.

If you have found this useful, leave a comment below!

Keep Excel-ing!