Pinterest Pixel

Excel´s Fill Justify Tool

Excel´s Fill Justify Tool An interesting tool within Excel is the Fill Justify.  It allows you to... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Excel´s Fill Justify Tool | MyExcelOnline Excel´s Fill Justify Tool | MyExcelOnline

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.

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
Excel´s Fill Justify Tool | MyExcelOnline Excel´s Fill Justify Tool | MyExcelOnline
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  Use Excel Goal Seek To Find The Formula Result You Want

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...