Helpful Tips Blog
All Tips
How do you create a custom function in Microsoft Excel?
As of Excel 2016 there are 467 functions, but the designers couldn’t possibly anticipate every user's calculation needs. So Excel provides you with the ability to create your own custom functions. Custom functions use the Visual Basic for Applications (VBA)...
How can I insert a drop-down list in a page in Microsoft Word?
If you'd like to add a drop-down box, you need to use the Developer tab. If that’s not visible, modify the Ribbon so that it is enabled. On the Developer tab the Controls section includes form elements. The Drop-Down List control is highlighted in the image below. ...
How do you import a CSV file into a Word document?
You can open a CSV file like any other Word document since it is a text file. If all the information is text information it's relatively easy. But if it contains numeric values you might have to work a little. The following information came from a spreadsheet...
Can I copy and save an Image Out of Microsoft Word?
Actually, you can. Right-click on the image and select Save as picture... I tried it with two different image formats, jpg and png, and then inserted the saved images into a separate document. In both cases, Word recognized the image type when it was saving them. ...
How do I put a border on only the top and bottom of an image in Microsoft Word?
Probably the easiest way to do this in versions of Word later than 2007 is to create a table with one cell and fit the image into the table. Check the width of the image on the Picture Tools Format tab. Click on the image, and then on the Insert tab, select Table and...
How can I include only part of an image caption in a table of figures in Microsoft Word?
You can use something called a Style Separator, which is a special form of a hidden paragraph mark. According to Microsoft, this is what the Style Separator is used for: The style separator is a newly introduced feature since Word 2002 and Word 2003. Style separator...
Can I disable spell/grammar checking on a custom style in Word?
Sure, you can do this for a style. I'll set up the style with the name 'Code' by defining a quick style here. After selecting the text and right-clicking, choose Styles and Save Selection as a New Quick Style.... When the Create New Style from Formatting box...
How Can You Sort Data In Excel?
Arranging your data alphabetically, from smallest to largest numerically, or using other criteria can help you find the information you're looking for more quickly. Select a cell in the column you want to sort and on the Data tab, in the Sort & Filter group,...
How can you instruct Excel to give a cell a particular fill color if a certain criterion is met?
You can do this with conditional formatting. Conditional formatting applies one or more rules to any cells you want. An example of a rule might be If the value is greater than 5000, color the cell yellow. By applying this rule to the cells in a worksheet, you'll be...
How can I reduce Excel file size?
When you create a new Excel file, it has a used range that includes only cell A1. But as you build your file it grows to include the cell in the lowest right corner of the spreadsheet. (You can find out what Excel thinks is the lowest right corner of your...
How to remove table in MS Word while retaining the text inside of it?
To convert a table to text, select the table and on the Table Layout tab on the ribbon click on Convert to Text. Depending on how your table is set up, choose how to separate the text. Because this table information is in columns, the option for Tabs is selected....
How do I fix commas without a following space?
In the following example, there are several commas that are missing spaces before the next word. You can do a Find and Replace to fix this. Copy the following wildcard string and paste it into the Find What section. (,)([! ]) Copy the following string and paste it...