Pinterest Pixel

Excel´s Fill Justify Tool

John Michaloudis
Excel´s Fill Justify Tool.
An interesting tool within Excel is the Fill Justify.  It allows you to select text from several rows and merge them in to one cell.
Excel´s Fill Justify Tool | MyExcelOnline Excel´s Fill Justify Tool | MyExcelOnline

So if you have data that gets downloaded in to separate rows and want to join them up in to one sentence, then the Excel´s Fill Justify option is your savior.

See the short gif below to see how easy it is to implement.

Download workbookFill-Justify.xlsx

This is our text:

Excel´s Fill Justify Tool

STEP 1: Adjust your column width so all the text could fit in one cell

Excel´s Fill Justify Tool

 

STEP 2: Select the cells that you want to combine together. Go to Home > Fill > Justify

Excel´s Fill Justify Tool

With just that, everything is now combined into one single cell!

Excel´s Fill Justify Tool

 

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Find Blank Cells In Excel With A Color

Steps To Follow

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...