How To Draw A Table In Word
In a previous post, I told you how to insert a table in Word. Now that you have that down pat, I will tell you how to draw a table in Word. Yes, it is possible to manually draw your table in Word. Me? I […]
Microsoft Office
Microsoft Office articles
Microsoft Copilot Not What I Expected
What Is Copilot Microsoft has released Copilot on both Dev and Beta Insider channels. Usually when a preview is released, I am reluctant to write an article about it because it might not make it to the final version of Windows. But once Microsoft releases
How To Convert Text To Table In Word
Table tools can make lists far easier to customize and reorganize. Let’s say you would like to convert your contact list into a table. Let’s also assume that your list contains names – first, middle, and last. It also contains the city, state, region, and
How To Use Quick Tables In Word
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
How To Add Words To Dictionary Using Keyboard
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
How To Stop Automatic Data Formatting In Excel
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
More On Automatic Formatting In 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
How To Change List Indents In Word
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
6 Excel Tips For The Web
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
How To Copy Conditional Format To Cells
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
How To Find, Replace Spaces/Tabs Before A Pilcrow
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 »
How To Use Find, Replace Without Capitalization
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
How To Unlink Cross-Referenced Fields In Word
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
How To Use Flash Fill In Excel
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.