MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I Use Excel to Type Letters Instead of Microsoft Word

March 17, 2018 - by Bill Jelen

I Use Excel to Type Letters Instead of Microsoft Word

The old joke is that Microsoft Word is some freeware for people who can't figure out how to type their letters in Excel. My confession for today: I often will type letters or at least paragraphs of text in Excel. One obscure command will help make your letters look good in Excel.

I will use Excel for everything. Right now, I am typing this web page in Excel. When I am done, a macro will format it as clean HTML. For the last 30 years, I will often type a letter in Excel.

While I am not really suggesting that you type letters in Excel, you often have to put a paragraph of text below a report. The edges of each line might look ragged.

Make the text fit from A through H
Make the text fit from A through H

Provided none of the cells contain more than 255 characters, you can easily word wrap those sentences to fit any number of columns.

continue reading »

More Reading

Pivot Table Timelines Forget What Year it Is

Pivot Table Timelines Forget What Year it Is »

March 16, 2018 - by Bill Jelen

Today's bug in Excel was discovered by Mynda Treacy and involves the timeline slicer in Excel. Mynda was working on videos for one of her awesome courses and found a pivot table where the timeline slicer kept adding new years.

Merge Worksheets Using Consolidate

Merge Worksheets Using Consolidate »

March 15, 2018 - by Bill Jelen

Excel offers a Consolidate command on the Data tab. This ancient command lets you consolidate data from multiple worksheets or workbooks, even if the data is a different shape.

read more news »

Featured Products

VBA & Macros for Microsoft Excel 2016

VBA & Macros for Microsoft Excel 2016 »

Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful.

Supercharge Power BI

Supercharge Power BI »

If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.

M is for (DATA) MONKEY

M is for (DATA) MONKEY »

Despite the moniker "data monkey", we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.

Power Pivot and Power BI

Power Pivot and Power BI »

Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

Excel 2016 in Depth

Excel 2016 in Depth »

Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016.

Learn to Write DAX

Learn to Write DAX »

Data analysis expressions (DAX) is the formula language of PowerPivot and Power BI. Simply reading a book is normally not enough to help Excel users learn DAX skills – you need to complete exercises and get plenty of practice to make the transition.

see more products »