• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Who Needs Word When Excel Has Got Fill Justify Text

You are here: Home / Excel / Who Needs Word When Excel Has Got Fill Justify Text
Who Needs Word When Excel Has Got Fill Justify Text
February 12, 2014 by Mynda Treacy

They say the true Excel fan has uninstalled Word from their PC, and removed the F1 key from their keyboard (accidentally pressing F1 opens β€˜Help’ which slows you down).

After all, who needs Word when you have everything you need to write a letter right there in Excel?

A must know tool for us Excel Die Hards is the Fill Justify tool which enables us to rearrange text across columns and rows automatically.

You can see in the animated image below that it’s quick to change the number of rows or columns the text occupies by simply selecting the text and the number of columns you want it to span by applying the Fill Justify tool:

Excel Fill Justify Text animation

If you manage to read the text in the animated image above you should know that I am joking πŸ™‚ Excel can't.... um,... there must be something it can't do that Word can....um...oh, there is one thing; it can't do Mail Merge!

You’ll find Fill Justify on the Home tab of the ribbon in the Editing group:

Excel Fill Justify text menu

And if you use it all the time you can add it to your Quick Access Toolbar so it's always just a click away.

Tips:

  1. Excel will automatically select the number of rows required. If you select too many rows Excel will just fill what it needs, and if you select too few it will give you a warning, which is handy if you have data underneath your text.
  2. Excel only includes the rows of text that are selected.
  3. The text can be in one row or multiple rows.
  4. You can repeat the process again and again until you have it just the way you want.
  5. The text is in the first selected column, it is not merged across cells.

Limitations

Ok, maybe uninstalling Word is a bit hasty πŸ™‚ …. If you have more than 255 characters in a single cell, Excel will truncate the characters down to the first 255, or the last complete word under 255.

You can check how many characters in a cell using the LEN function. For example if you have a sentence in cell A1 you can use this formula: =LEN(A1) to return the number of characters.

If you've got more than 255 in one cell then you'll need to split it up into multiple cells before using Fill Justify.

Who Needs Word When Excel Has Got Fill Justify Text

More Excel Posts

tips for working in multiple excel files

Hacks for Working in Multiple Excel Files

Awesome tips for navigating, arranging and working in multiple Excel files. Guaranteed to streamline your workflow and increase productivity.
chatgpt for excel

ChatGPT for Excel

Using ChatGPT for Excel can be hit and miss. Learn the best uses for ChatGPT to make your Excel life easier and what to avoid using it for.
excel templates

Where to Find Free Excel Templates

Where to find free Excel templates and how to create your own Excel templates. Using templates saves time and effort.
Easily Remove Password Protection from Excel Files

Easily Remove Excel Password Protection

How to remove Excel password protection when you’ve forgotten the password. Works for sheets, workbooks and read only files.
Import data from a picture to Excel

Import Data from a Picture to Excel

Import data from a picture to Excel. Works with pictures from a file or the clipboard and loads it to the spreadsheet.
excel online

5 Excel Online Features Better than Desktop

5 Excel Online Features Better than Desktop including searchable data validation, track changes, single line ribbon and more.

10 Common Excel Mistakes to Avoid

10 common Excel mistakes to avoid, including merge cells, external links, formatting entire rows/columns and more.
new Excel features

Cool New Features in Excel for Microsoft 365

Cool New Features in Excel for Microsoft 365 including the navigation pane, smooth scroling, unhide multiple sheets and more.
dynamic dependent data validation

Dynamic Dependent Data Validation

Dynamic Dependent Data Validation with dynamic array formulas like FILTER make it quick and easy to set up.
QAT

Excel Quick Access Toolbar

The Excel Quick Access Toolbar is not only a handy for your mouse, but it also enables some super easy keyboard shortcuts.


Category: Excel
Previous Post:Convert Numbers (Currency) to Words With Excel VBAConvert Numbers (Currency) to Words With Excel VBA
Next Post:6 Ways to Fix Dates Formatted as Text in Excel6 Ways to Fix Dates Formatted as Text in Excel

Reader Interactions

Comments

  1. Bryan Metz

    February 15, 2014 at 12:07 am

    Whooooooah. I don’t tend to have long text passages in my spreadsheets, but there have definitely been times when this would have been useful to know about!

    Also, you said “oh, there is one thing; it can’t do Mail Merge!”. Technically you are correct, but it’d be a whole lot easier to add a little VBA to a form linked to a table through lookups than to do all the manipulation in Word!

    Reply
    • Mynda Treacy

      February 16, 2014 at 1:51 pm

      πŸ™‚ I agree VBA would probably be better than the built in Mail Merge in Word.

      Mynda.

      Reply
  2. Bengt Danebring

    February 14, 2014 at 9:34 pm

    A very good tip Mynda. I have put it on my blogg http://www.datamentor.se
    Feel free to use my tips, although it’s in Swedish.

    /Bengt

    Reply
    • Mynda Treacy

      February 14, 2014 at 9:38 pm

      Thanks, Bengt πŸ™‚

      Reply
  3. Jon Acampora

    February 14, 2014 at 3:03 am

    Awesome tip! I don’t think I have ever used that one either.

    I use OneNote for all my note taking, and have pretty much ditched Word as well. OneNote integrates nicely with Outlook and is great for keeping your projects organized.

    The other Word feature missing from Excel is bullet lists. That reminds me that I have a technique for this and should write an article on it.

    Thanks again!

    Reply
    • Mynda Treacy

      February 14, 2014 at 8:51 am

      Cheers, Jon.

      I never got into OneNote. Probably should because it sounds useful with all the integration. Old habits die hard though.

      I’m looking forward to your bullet lists technique πŸ™‚

      Mynda.

      Reply
    • MF

      February 14, 2014 at 12:45 pm

      Hi Jon,
      It would be nice if there is Bullet list in Excel. Looking forward to your article.
      Cheers,

      Reply
  4. Pablo

    February 14, 2014 at 2:24 am

    Hi Mynda,
    Excellent tip, after so many years of using Excel I never knew it has such a handy function. Too bad is limited to 255 characters, but the extra work is nothing compared to what I used to do manually before knowing the Fill Justify.
    Keep up the good work, I always wait excited for your next newsletter.
    Thanks,
    Pablo

    Reply
    • Mynda Treacy

      February 14, 2014 at 8:49 am

      Hi Pablo,

      I agree, the 255 limit is a small price to pay for such a versatile tool.

      Glad you liked it.

      Mynda.

      Reply
  5. MF

    February 13, 2014 at 5:22 pm

    Hi Mynda,
    I knew that trick, just that I barely used it in the past and almost forget it. Thanks for reminding. πŸ™‚
    Nevertheless, I think it cannot Justify to uninstall Word…
    Frankly, I strongly encourage people not to use Excel as Word, as Excel is not intending for writing. Don’t you think so?
    Cheers,

    Reply
    • Mynda Treacy

      February 14, 2014 at 8:47 am

      Hi MF,

      Glad I reminded you of this technique. There are so many cool tricks like this in Excel that it’s difficult to remember them all.

      Of course I don’t recommend people uninstall Word…which is why I said ‘I was joking’. I use Word nearly every day too, in fact I write my blog posts/tuturorials and many other training materials in it.

      But I’ll always like Excel the best πŸ™‚ ….won’t you?

      Cheers,

      Mynda.

      Reply
      • MF

        February 14, 2014 at 12:41 pm

        Hi Mynda,
        Of course I know you were joking. ;p
        I agree with you that I like Excel the best!
        Cheers,

        Reply
        • Mynda Treacy

          February 14, 2014 at 12:43 pm

          Phew! You had me worried there for a minute πŸ˜‰

          Reply
  6. pmsocho

    February 13, 2014 at 6:52 am

    Awesome trick!
    Thanks!

    Reply
    • Mynda Treacy

      February 14, 2014 at 8:44 am

      Cheers, pmsocho πŸ™‚

      Reply
  7. Wanda

    February 12, 2014 at 10:09 pm

    This is TOO amazing! I wish I would have know this months ago! This would have saved me hours of time redoing sentences that are too long and get cut off when the page is printed. You can spot a die-hard Excel fan when something THIS simple excites us. LOL

    I “so” look forward to your weekly newsletter – you just never know what nugget of information will be shared.

    Reply
    • Mynda Treacy

      February 12, 2014 at 10:11 pm

      πŸ™‚ Thanks, Wanda. You definitely qualify as an Excel Die Hard!

      Mynda.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.