How often have you tried to do something that you thought should be relatively simple only to find that what you are doing simply isn’t working? Yes, I am well aware. It has happened to me more often than I am comfortable sharing! To that […]
This is so easy that you will wonder why you have not used it all along. I am certain that you will use it all the time now that you have learned how easy it is! Select the cell that has the conditional formatting that
Recently I came across an article about how to find and replace unwanted spaces and/or Tabs before a paragraph. I found this interesting because many, many people have no idea how powerful that Pilcrow (paragraph mark) is. If you copy the Pilcrow at the end
How To Find, Replace Spaces/Tabs Before A Pilcrow Read More »
A subscriber contacted me recently and asked if they could replace an all-caps abbreviation/acronym (ie., NAACP) with another word without all caps. They said every time they used Find and Replace it was all caps and wanted to know if there was any magic fix
One of my clients called me in a complete tizzy about a month ago. It seems they needed to find out how to unlink cross-referenced fields as well as automatic caption numbering. Now the real reason they were in a tizzy was their superior at
Flash Fill can be used in Microsoft 365, Excel 2021, and Mac Excel 2019 What is Flash Fill? Well, I am glad you asked. Flash Fill is very helpful and it will allow you to fill your data when it senses a pattern in Excel.
To edit a file and make it your own so that you can use it again later, you must first save it as a template. Follow the steps below to learn how: Go to the File menu and select Save As. Give your template a
You can change your language, date and time format, and time zone in Outlook settings. Go to Language and time settings (Settings View all Outlook settings | General | Language and time). Select the language, date format, time format, and time zone you would like
I know this is old news to some folks, but there are newbies out there who do not know how to do this and so I will now enlighten them. So, once you decide what sort of break is appropriate for your document, save your
In an earlier post, I explained how to create page breaks in Word. This time I will explain how to create section breaks. Ok, you know there are page breaks and there is another category of breaks as well, called section breaks. So in addition
This is a follow-up to a previous post on this subject. And I think you will find it interesting but you have to have read the previous post so that it will make sense to you. This will be the third method to achieve your
How To Remove Manually Applied Character Formatting II Read More »
On a Facebook chat room, I saw someone inquiring if there was any way to highlight all text with additional formatting applied (i.e., formatting that is not part of the Word style for that text). Well, yes, there is more than one method of making
How To Remove Manually Applied Character Formatting Read More »
One way to quickly set your left or first-line indent is to simply use your Tab key. One of the AutoCorrect features in Word is to automatically set a left or first-line indent for you when you press your Tab key at the start of
How To Set Left, First-Line Indents With Tabs In Word Read More »
When you have many paragraphs and you need to adjust the indentation all at once the quickest and easiest way to do that is probably to use your increase or decrease indent buttons. Follow the steps below to learn how: Select all paragraphs. Use your
How To Use Indent Increase, Decrease Buttons In Word Read More »
