Microsoft Office articles
Any time that you have two or more graphics in an Excel worksheet, you want to be certain that they are distanced equally from each other because it is more pleasing to the reader’s eye. This can be easily accomplished with a few easy steps. […]
Auto Correct Text – Auto Correct Inserts – Quick Parts If you are anything like me, there are just some words you just cannot spell correctly no matter how hard you try. Now, I am not talking about the few of you that somehow know
Word makes it fairly simply to change the formatting of your line numbers. I am always telling my clients to learn to use Styles because it makes your Word life so much easier and this is a perfect example of that ease. Display the Home
Frequently in the business and academia world we have several different sections in long Word documents. It can be very frustrating when editing a document though when you want to jump to a page in a different section. So, how do you use the Go
Use GoTo to Jump to a Page within a Section of your Document Read More »
Many Excel worksheets have columns and rows of identical formulas that have different formatting throughout. Now, when you edit a formula and want to copy it down your column or across your row, but don’t want to over-ride the formatting of the other cells, you
What could be easier than using Paste Special to remove your hyperlinks? Here’s how: In a blank cell in your worksheet, key in the number 1. Select the cell and click CTRL + C to copy the cell contents to your Clipboard. Depress your CTRL
In many instances you may have documents that need extra spacing between your paragraphs, if for no other reason than not wanting to hit the old Enter key as if you were using a typewriter! Believe it or not, those folks exist and still hit
How to Add Space Before or After your Paragraphs Read More »
Ever had a need to rotate the text in your Word document so it is at a 90 degree angle to your headers and footers? I will admit that this is not necessary very often, but if you ever need this trick keep this tip
In past versions of Excel, there was a several-step process using a COUNTIF formula in Conditional Formatting to highlight duplicate values in your data. Starting with Excel 2007, however, finding and highlighting your duplicate values suddenly became a lot easier to manage. Follow the steps
When you use the different tools that come with Word to add page numbers to your documents, they are inserted using fields. Now a lot of folks are intimidated by fields but they should not be as one of the great things about fields is
Usually one would add borders around a cell or range of cells in their worksheet by selecting the cell or range and using the Border tab of the Format Cells dialog box. BUT, there is a nice little shortcut that saves you time and keystrokes
Excel, by default, will allow you to edit your cell information in either the Formula bar or in the cell itself. You simply select your cell and click F2 or double click on your cell. However you may wish to disable the editing feature in
Transposing (i.e., swapping columns, rows, etc.) is an old trick in Excel and I am happy to report that it is still available to you in Excel 2013! As you will see in my screenshot below, I have a worksheet in Excel that is vertical
If you employ Styles in your Word 2010 document (and I hope you do!), and have your document organized with headings defined by Word, you can use the Outline view to move through your document. For example, suppose you have a rather large document and
How to Use Outline View to Navigate a Word 2010 Document Read More »
