Microsoft Office articles
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 »
Even though you have already defined a style in your Word 2010 document, you can still change it at any time you like. Follow the steps below to learn how: Display the Home tab of your Ribbon. In the Styles group, click the small arrow
There are two types of page breaks that can appear in your worksheet in Excel 2010. Those would be Manual and Automatic. As you know, you insert page breaks manually by clicking on the Breaks tool in the Page Layout tab in the Page Setup
How to Control Display of Page Breaks in Excel 2010 Read More »
If you are familiar with using desktop publishing software, you already know that it is very useful to create text boxes and have your text flow automatically from one text box to the next. Why would you do this? Well, suppose you have a newsletter!
Flow Text Through your Word 2013 Documents With Linked Text Boxes Read More »
You can create myriad different embellishments to the text in your Word documents. One of the embellishments is vertical lines either at the left, right, or both sides of your documents or words, etc. There are a couple of ways in which you can accomplish
How to Add Vertical Lines to the Sides of a Word Document Read More »
On some occasions, your Word table can contain formulas that are too long for the smaller cells in your table and that prevents them from being displayed completely when you look at your field codes rather than the results of your field codes. Word does
