What??? You have never heard of Percantation 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 Percantation sounds very complex and a bit scary, it really is not.
This 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 you want to copy. On your Home tab (or the Standard
How often have you tried to do something that you thought should be relatively simple only to find that what you are doing just isn’t working? Yes, I am well aware. It is has happened to me more often than I am comfortable sharing! To that end, today I am going to share some Excel
Flowers are blooming and isn’t it grand to be outside again! One set of grandchildren have finished school for the year and the other set will be finished at the end of next week. That means more time with their grandmother! I am a happy camper! I hope things are going well for you in
Bullets and numbers both 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 these skills can come in very handy, especially when
Did you know that you are able to change the default settings for new documents by making changes to the Normal template that new documents are based on? Well, the good news is that you can modify your Normal template to change its default formatting and/or content so that any new document that you create
Have you ever wanted or needed to create a new formatting rule in Excel and didn’t know how? Well it is super easy and I am going to show you how to do it. Relax, it is quick and easy! Follow the steps below to learn how: Select the range of cells, the table, or
So, do you know how to add a hyperlink in VBA to a certain word such that every time that certain word sows up in your document it has the hyperlink in it? Yeah, I cannot tell a lie – I did not know how to do it either. Luckily a very intelligent woman named
One of my subscribers contacted me recently asking for help with an issue he was having. It seems as if he has a document that contains a list of pages and numbers that precedes each paragraph. He would like to change the font color for both the word “Page” and the number, without actually changing
Easter is over and most of my plants are blooming and flourishing. This is one my favorite seasons with so many beautiful flowers and trees and everything looks so brand new. It gives me hope that eventually everything will be alright again. It is good to be outside again and able to meet with friends
