AutoText is a great feature that has been included in Word since its earliest versions and it is one that really comes in handy. just about everyone I know uses AutoText and uses it frequently as I do. As you all know I love to […]
As you know, when you create a chart in Excel, a chart legend is automatically created right along with your chart depending upon which type of chart you are creating. It doesn’t have to be that way. You have a choice. Follow the steps below
There is a really cool way you can use the validation feature in Excel and that is to create a single-use drop-down list. Your list will allow users to select the cell and then select from a list of pre-defined values for that cell. Once
How to Create a Single Use Drop-down List in Excel 2010 Read More »
You have just created a form and it is based on a table format so that all the entries are aligned. You have included form fields in both text and numeric format and have set a field length for each, which prevents the person using
How to Prohibit Use of The Enter Key in a Word 2010 Form Read More »
As you know, you can create forms using Word and in those forms users can enter data. Once those users have entered their information in your form, they usually save the form as a Word document, but if you would like to use the entered
If you have a very large worksheet containing rows and rows of data it would be a lot easier for you if you were able to freeze both the top and bottom rows of your worksheet. Unfortunately, there is no way to do this in
Once you have created a table in your document, you may want to spiff it up a bit by changing the borders. Luckily, it is not all that difficult to do in Word and there are several methods you can choose from to accomplish this,
Sometimes you inherit a document from someone else and it is necessary to remove text boxes that have been placed in it. If there is just one, that is a snap to remove. But suppose your document is very large, like a work manual and
A client wrote to me recently with this problem: She had a worksheet with about six thousand rows (yes, those do exist!). At the very top of her worksheet there is a graph based on her data with the data starting at row 50. The
The new settings in Office 2013 take you to the File | Save As menu when you click the Save button. This occurs in most Office 2013 applications – the Save and Save As buttons are exactly the same when you are working with a
I work on a lot of legal documents for clients and I love using this tip when I do. But, you can use this tip regardless of what kind of documents you work on. Legal Assistants and Paralegals always complain to me that they create
Whether you use version 2003, 2007, 2010, or 2013, if you use Word as your e-mail editor, it is very easy to change signatures on your Outlook messages. And if you have more than one e-mail account, you can create a signature for each account
You all know the Formula Bar resides at the top of your Excel window, immediately below the Ribbon area or the Formatting toolbar depending on which version of Excel you own the license to. There are two parts of the Formula Bar: On the left-hand
How to Control the Formula Bar Display in Excel 2010 Read More »
There is a tool in Excel that allows you to very quickly and easily change the color of a selected cell. That would be the Fill color tool, which can be found on the Formatting toolbar or the Home tab of your Ribbon and has
