Microsoft Office articles
There are many ways to create custom tables in Word but a lot of folks just want the quickest and easiest method and thankfully we have that. It is called Quick Tables. And what is more, it really is quick and easy! Quick Tables are …
As I have said many times, “Nobody knows everything about Microsoft Office.” And yet, I am always amazed at the things that I do not know! I don’t know why but I am! Thankfully there are folks out there way smarter than me in this …
Someone wrote to me recently complaining that “Excel keeps changing my numbers to dates!” Obviously, they wanted to know why and if they could fix it and fix it permanently. I have to be honest so full disclosure here – I do not use Excel …
It seems I did not do enough research on the above subject. All I addressed was importing issues. Now I will tell you how to avoid data formatting that is now imported. Apparently, the problem arises once you decide to go a different path than …
Bullets and numbers are indented 0.25″ from your left margin in a list. The next text is then indented 0/50″ from the left margin. This is the default setting, but you can change the position of these indents in a list. Not only that, but …
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 …
