Look Who it Was Random video

Excel - Word Formatting: How to Avoid Frustration & Keep Your Document Consistent - Episode 468

202 views · Published 18 May 2009 · 4:02 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Word Formatting: How to Avoid Frustration & Keep Your Document Consistent

Welcome to another episode of the Learn Excel Podcast. I'm Bill Jelen and I'm here in Seattle for the MVP summit, where I have the pleasure of interviewing Antroy, the world's foremost expert in Microsoft Word. She may be laughing, but it's true. Her book "DREAMBOAT ON WORD" is a must-read for anyone looking to master the ins and outs of Word. You can find it on Amazon or at MrExcel.

In this episode, we're discussing a common frustration in Word - formatting. Have you ever spent time carefully formatting a paragraph, only to have it all change with just one small edit? Ant is here to explain why that happens and how to avoid it.

First, we'll use the =rand() function to generate some sample text. Then, we'll turn on the show/hide button to reveal the paragraph markers and other non-printable characters. These markers hold the key to understanding formatting in Word.

Ant explains that paragraph formatting is stored in the paragraph marker, and deleting or editing it can affect the entire paragraph's formatting. This is where styles come in - they allow you to apply consistent formatting to your document without worrying about individual paragraph markers.

But what about character formatting? Ant shows us how to differentiate between character and paragraph formatting using the little button next to the style name. This is crucial in understanding why certain formatting changes affect the entire paragraph, while others do not.

So next time you're working in Word, remember to pay attention to those paragraph markers and use styles to keep your formatting consistent. And don't forget to check out Ant's book "DREAMBOAT ON WORD" for even more tips and tricks. Thanks for watching and stay tuned for more Excel and Word tips from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


I realize this is the Learn Excel podcast, but we have a Word tip today from Anne Troy  aka Dreamboat, author of Dreamboat On Word. Have you ever changed a character in Word and had the format of the entire paragraph change? Our guest podcast host, Anne Troy will show you why that happens in Episode 468.

Table of Contents:
(00:00) Introduction to the Learn Excel Podcast 
(00:22) Special guest: Antroy, expert in Microsoft Word 
(00:42) The frustration of formatting changes in Word 
(01:00) Using the =rand() function to generate sample text 
(01:30) The importance of the paragraph marker symbol 
(02:03) How selecting the paragraph marker can affect formatting 
(02:43) The role of paragraph formatting in styles 
(03:23) Understanding character and paragraph formatting 
(03:36) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Antroy's book DREAMBOAT ON WORD
Bold text in Word
Character formatting vs paragraph formatting in Word
Deleting formatting in Word
Famous people at MVP summit
Formatting changes in Word
Learn Excel Podcast
Microsoft Word formatting
Non-printable characters in Word
Paragraph markers and formatting
Styles in Word
Word tip from MrExcel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152422/

More from this channel