When you work with small worksheets they sometimes look out of kilter when you print them. The reason for this is that Excel prints worksheet data from the upper left-hand corner. To make your worksheet more pleasing to the eye, you can center your data […]
Center Printed Excel 2010 Worksheets Read More »
If like me, you use defined styles in your documents, you may be surprised to learn that there is a very robust search in Word that will allow you to find defined styles within your document. Follow the steps below to learn how: On the
How to Find Your Styles in Word 2010 Read More »
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
How to Print AutoText Entries in Word 2010 Read More »
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
How to Turn the Excel Chart Legend On or Off Read More »
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
How to Export Word 2010 form data as text Read More »
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
How to Freeze Excel 2010 Top and Bottom Rows Read More »
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,
How to Add Borders to Word 2010 Tables Read More »
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
How to Remove All Text Boxes Word 2010 Read More »
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
How to Set Row Label Width in Excel 2010 Read More »
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
How to Bypass Backstage View in Office 2013 Read More »
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
Make Dates in Word Documents Update Themselves Read More »
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
Outlook 2013 – Signatures Read More »
