We spend a lot of time in Excel navigating between various ribbon tabs and clicking buttons. Wouldn’t it be better if you can combine all the frequently used features in to one ribbon? Something like this:
Watch below video to learn how to create, edit & share custom ribbons in Excel.
Read companion article on how to create custom ribbons in Excel to know more.
Create custom ribbons in Excel to save time – how to video
You can watch this video on our YouTube Channel too.
More tips on Excel productivity
- Switch between ribbon tabs with scroll button on your mouse
- Adding your own macros to Excel ribbon
- CP024 – Customize Excel to boost your productivity
- 25 productivity tips & tricks for analysts
Do you use custom ribbons? Share your ribbon screenshots in the comments
My top 3 customizations when it comes to Excel are,
- Add frequently used features to Quick Access Toolbar (QAT)
- Pin frequent locations to File menu
- Create personal macros and add them to ribbon (or QAT)
What about you? Do you use custom ribbons? If so, please share a screenshot of your ribbon in the comments. To share your ribbon screenshot, follow below steps:
- Open Excel and activate your custom ribbon
- Press Print Screen
- Open MS Paint (or any other image editor) and press CTRL+V to paste the screenshot
- Crop it so only your ribbon is showing
- Save the file as myribbon.png (or any other name with .PNG extension)
- Upload the image to a free image hosting service like imgur or tinypic or flickr
- Post the URL in the comments for this post, along with what a brief explanation of your ribbon does.
11 Responses to “Use Alt+Enter to get multiple lines in a cell [spreadcheats]”
@Chandoo:
One more useful trick.......
In a column you have no. of data in rows and need to copy in the next row from the previous row, no need to go for the previous rows but entering Alt + down arrow, you will get the list of data, (in asending order), entered in the previous rows...
This is another great tip. I use this all the time to make sense of some *very* long formulas. As soon as the formula is debugged I remove the break.
Great tip Chandoo!
I use this feature often and it has even gotten the, "how did you do that" response.
Thanks!
@Ketan: Alt+down arrow is an awesome tip. I never knew it and now I am using it everyday.
@Jorge, Tony: Agree... 🙂
[...] Day 1: Insert Line Breaks in a Cell [...]
how can we merge a two sheet.
excellent idea. Chandoo you are genious
Hi chandoo,
I have used ctrl+enter to break the cell. But I did not get the result.
Please tell me how can i break the cell in multiple lines.
Hi, Ranveer,
Its not Ctrl+enter to break the cell, use Alt+Enter to make it happen.
hi Chandoo....
how we can use Alt+Enter in multiple rows at the same time please reply hurry i have lot of work and have no time and i m stuck in this. 🙁
Alt+J worked once 🙁
So I found another more reliable way:
=SUBSTITUTE(A2,CHAR(13),"")
Where A2 is the cell that contains the line breaks which the code for it is CHAR(13). It will replace it with whatever inside the ""