by Laura | Sep 2, 2019 | Microsoft Word Tips
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...
by Laura | Aug 6, 2019 | Microsoft Word Tips
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...
by Laura | Aug 2, 2019 | Microsoft Excel Tips
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...
by Laura | Aug 1, 2019 | Microsoft Excel Tips
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...
by Laura | Jul 31, 2019 | Microsoft Excel Tips
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...
