Helpful Tips Blog
All Tips
How do I split my screen vertically in Excel?
If you have a spreadsheet packed with data, navigating it can become quite unwieldy, especially if you want to compare data from several different sections. Splitting your screen—whether vertically or horizontally—is a great way to streamline your workflow. To split...
How do you only allow certain values input or entered in Excel?
You can use the Data Validation feature, which enables you to add rules for what’s acceptable in certain cells. Excel makes it quite easy to specify validation criteria. You can apply the following validation options: any value whole number decimal list date time text...
How do I use the IF() function in Excel? Why would I use it?
You use an IF statement to ask Excel to test a condition and to return one value if the condition is met, and another value if the condition is not met. Another way of saying it is that Excel makes a statement, and performs one calculation if the statement is true,...
How do I create an index with hyperlinks to the appropriate section in MS Word?
It sounds like you want a table of contents. At least that’s the easiest way. Make sure that you’ve applied styles to your section headings, like in the following figure. Do the same for the other section headings. You can use the F4 key on each header to apply the...
How do you use SUM() in VBA?
Here’s an example where you know the exact range you want to sum, as in the following illustration. To add Sum functions for columns F and G use the following code: Sub SumExample1() Range("F15").Value = WorksheetFunction.Sum(Range("F2:F14")) Range("G15").Value =...
How do I remove horizontal tabs from Word documents with VBA?
Try adding the code below to your Visual Basic Editor. It should remove all tabs. Sub RemoveTabs() With ActiveDocument With .Range With .Find .Forward = True .Wrap = wdFindContinue .Text = "^t" .Replacement.Text = "" .Execute Replace:=wdReplaceAll End With End With...
Using Extend Selection Mode in Word
Extend Selection Mode is a keyboard method of anchoring the cursor before you select text. Pressing F8 turns it on and and pressing any arrow keys at that point will select text from the anchor point in that direction. In the following illustration the anchor point is...
Conditional Statistics in Excel
If you're an Excel user, you've probably used the SUM function. It's fairly simple. The following formula returns the sum of all values in the range of cells in Column A from rows 4 through 1799: =Sum(A4:A1799) Sometimes you need to sort your data before you can get...
What is the use of the subtotal function in Microsoft Excel, and how can I use it?
The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. According to Microsoft, it is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on...
How can I create a data entry form in Excel?
You might find using a data entry form easier than entering information in a columnar format. Excel has an awesome feature called data entry forms. In order to be able to use data entry forms, make sure that your worksheet is set up with column headings. Excel uses...
How do I insert an image into another image using Microsoft Word?
You can do this by using the Text Wrap options (even though there’s no text). Insert the first image. Now insert the second image. With the second image selected, choose Wrap Text from the Image Format tab and select In Front of Text. Now drag the second image onto...
Understanding and Using Hyphens and Dashes in Word
What's the Difference? Confused about when to use a hyphen or a dash? Not sure what the difference is between an em-dash and an en-dash? Which do you use? This article should help. Hyphens A hyphen is used to join two or more words to form a compound word. ...