Yes? Yes! When you click that key combination it no longer opens up the Find & Replace dialog box. What happens since version 2010 is that a pane will appear on the left-hand side of your screen that will allow you to search. Personally, […]
Lots of businesses have data tables set up in worksheets but this tip is not just for businesses. Say you have a large business and have set up a data table of your clients. In the first column you have the name of your clients
There are lots of instances where you would like to delete every second, third, fifth, etc. rows in your worksheet. One instance that readily comes to mind is when you use data from another source. Luckily this is not a difficult task! Follow the steps
Comments in MS Word is a great tool that allows you and your colleagues to to share thoughts and ideas while collaborating on a document. So, it would follow, that it would be nice if you could just copy one of those comments and paste
MS Word has great table features and tools. You can create and modify tables and place data in them. You can even have Word automatically adjust the dimensions of the cells in your table. There are times, however, when you may want to freeze the
I am sure there have been instances when you have wanted to rotate a page of text in your document 90 degrees. There are a couple of methods for doing this within MS Word. You can insert a text box and rotate your text within
Have you ever had a need to use conditional formatting in a row in your worksheet? Suppose you need to highlight all the values in your row that exceed a certain number. I had a client call me regarding this issue not too long ago.
Sometimes after you have finished a list in your document you decide that you would like to change the font characteristics of a bullet or number in your list. But wait, you do not want to change the text in your list! Can you accomplish
A client recently sent me a query, wanting to know if she could somehow omit the hyphenated words when performing a word count in her document. I am sure she is referencing compound words in her document (i.e., son-in-law, built-in). Actually there is no built-in
Ignore Hyphens When Peforming a Word Count in MS Word Read More »
I have had many clients in the past who ranted about Outlook searches being too slow, but that was before version 2007. With the 2007 iteration of Outlook there were dramatic changes regarding the search capability. This was the dawn of Instant Search in Outlook.
Did you know that you can add diagonal borders to the cells in your Excel worksheet? Well you can! You can put border on the right, left, top, and bottom of your cells. If you select a range of cells, you can even add those
Did you know Word has a formatting option that will allow you to show text as uppercase when it isn’t? Well it surely does! You can apply the all caps formatting very easily. Follow the steps below to learn how: Click Ctrl + D to
As you know, you can use the Find and Replace tool in MS Word to look for and find just about anything in your documents. But why do it the long way??? Besides, that pesky dialog box very often gets in the way! Anyone who
I cannot tell you how many times I have received a document from a client who cannot correct the problems that he/she has encountered in it. For this reason, I instruct all my students to have the Show/Hide feature enabled in MS word. I would
