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.
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).
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).
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.
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.
Do try these out once. They are amazing and very handy to use everyday.
If you have found this useful, leave a comment below!