Sometimes you just have gigantor Excel worksheets – there’s no getting around it! Now if, in your gigantor worksheet you also have graphs based on your data, you may find that at some point when you are scrolling through your worksheet that redrawing of your […]
I get so many complaints from Word users regarding the use of CTRL + F in Word 2010. The good news is that it has always been within your power to make it work as it did in earlier versions! In Word 2010, CTRL +
By default Word can – and does – impose certain changes to your text. One example is that Word will add borders to the paragraphs in your document based on what you key in. Let’s say, for example, you key in three underlines on a
Once you have inserted a comment in your word document using the Comment feature, and you decide you would like to duplicate it, there are methods that I am sure you are aware of to do just that! But, just in case, I will refresh
How to Move, Copy, or Delete Comments in a Word Document Read More »
Any time that you have two or more graphics in an Excel worksheet, you want to be certain that they are distanced equally from each other because it is more pleasing to the reader’s eye. This can be easily accomplished with a few easy steps.
Word makes it fairly simply to change the formatting of your line numbers. I am always telling my clients to learn to use Styles because it makes your Word life so much easier and this is a perfect example of that ease. Display the Home
Frequently in the business and academia world we have several different sections in long Word documents. It can be very frustrating when editing a document though when you want to jump to a page in a different section. So, how do you use the Go
Use GoTo to Jump to a Page within a Section of your Document Read More »
Many Excel worksheets have columns and rows of identical formulas that have different formatting throughout. Now, when you edit a formula and want to copy it down your column or across your row, but don’t want to over-ride the formatting of the other cells, you
What could be easier than using Paste Special to remove your hyperlinks? Here’s how: In a blank cell in your worksheet, key in the number 1. Select the cell and click CTRL + C to copy the cell contents to your Clipboard. Depress your CTRL
In many instances you may have documents that need extra spacing between your paragraphs, if for no other reason than not wanting to hit the old Enter key as if you were using a typewriter! Believe it or not, those folks exist and still hit
How to Add Space Before or After your Paragraphs Read More »
Ever had a need to rotate the text in your Word document so it is at a 90 degree angle to your headers and footers? I will admit that this is not necessary very often, but if you ever need this trick keep this tip
In past versions of Excel, there was a several-step process using a COUNTIF formula in Conditional Formatting to highlight duplicate values in your data. Starting with Excel 2007, however, finding and highlighting your duplicate values suddenly became a lot easier to manage. Follow the steps
When you use the different tools that come with Word to add page numbers to your documents, they are inserted using fields. Now a lot of folks are intimidated by fields but they should not be as one of the great things about fields is
Usually one would add borders around a cell or range of cells in their worksheet by selecting the cell or range and using the Border tab of the Format Cells dialog box. BUT, there is a nice little shortcut that saves you time and keystrokes
