Excel Trick for Texts

I just learned a neat new trick in Excel from an Excel guru Leila Gharani. It’s the Fill Justify and the embedded YouTube video describing it is embedded below. It’s such a neat trick that you can use when you write up notes or instructions in excel.

Generally, when I write instructions or a checklist, I will write down my thoughts/instructions as far out as I need and then I’ll go in and fix the row so that the text fits into the screen (or however wide I need) and the remaining text rolls onto the next row, very similar to what she shows in the video. I could use the alt-Enter but it really doesn’t do the trick that I need. Alt-Enter seems mainly for introducing multiple lines within a cell.

But Fill Justify looks like it will do what I need. Where has this been all my working life?

Similar Posts

Finding hard coded numbers
|

Finding Cells Overwritten with Numbers

Aaarrrggghhh!!! She overwrote the formulas with hard coded numbers and now the math is not working. She has left for a position that has better growth potential and I am happy for her. So I took back the automated reporting that she was handling. She was actually doing it very well, but I must remember…

Puzzle

Worked on a Unique Puzzle: Matching Names When There Are Different but Close Spellings

First – it is so hard to get anything done. I’m still trying to update my “About” page so my blogging has slowed down. But, because it is taking so long to do (difficulty with coming up with decent pictures and decent phrasings), I decided I would do a quickie blog. This past week, I’ve…

Graphic design with words exponential curve fitting
|

Curve Fitting Exponentials

In my last post I learned you can’t always use the trend line formula created by the scatter plot chart. For the scenarios where the job taken over by robots doubled every 1.5 or 2 years, I wanted to get a formula to enable me to calculate jobs taken over every year and not every…

Abstract background with words Power BI
|

Using Power BI with Quickbase

There are two new tools that I’m working with at work: Microsoft’s Power BI and Quickbase. One of the thing we’re thinking of is loading more data from our vendor into Quickbase so we can combine that data with other data, maybe marketing, and then push those data into a visualization tool – in this…

What to do when your macro no longer works

What to Do When Your Macro No Longer Works

My usual macro that I use to collect Excel files into a summary report failed me on Monday. But someone else could use the macro which told me that the problem was with my machine, not the macro.This post will be short since it is late but I do want to point out some steps…

I Need to Learn Statistics
|

I Need to Learn Statistics

The week before last week I had been going through a book on Excel simulations but then I got sick and work became busier, so I had to put the book aside.  The last set of simulations that I had been going through were centered on statistics. In going through these simulations, there were some…