What??? You have never heard of percontation and its use in Microsoft Office? Well, you are definitely not alone. I too had never heard of it but then I saw an article that someone had posted and became educated in that regard. Although percontation sounds […]
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
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 »
