On some occasions, your Word table can contain formulas that are too long for the smaller cells in your table and that prevents them from being displayed completely when you look at your field codes rather than the results of your field codes. Word does […]
How to Easily View Formulas in Excel Cells Read More »
There are some occasions when you would like to prevent your colleagues from making changes to your cells or perhaps you do not want them to have the capability of seeing your formulas in the Formula bar. Fortunately, Excel will allow you to do this
How to Protect an Excel 2010 Worksheet Read More »
Say you have multiple custom buttons on your Quick Access Toolbar (QAT) in Word, in a custom ribbon group. AND your buttons are assigned to macros? Suppose you want to change the ToolTip associated with the macro button on your QAT?? It’s very easy to
How to Change Macro Button ToolTips in Word Read More »
I cannot tell you how many times I have received a phone call from an irate client, cursing Word and the person who created it because they “have tried everything under the sun” to correct some formatting and it just doesn’t work! Below are some
How to Resolve Word 2010 Formatting Errors Read More »
PowerPoint 2010 gives you the option of creating your own master slides, meaning you can add or change elements and formatting within your presentations. A slide master is a special slide that you put to work behind the scenes in PowerPoint that specifies how slides
How to Create A New Slide Master in PowerPoint 2010 Read More »
Excel has always been a great piece of software but Excel 2010 has even more great features and one of them is the ability to use a right-click cell menu to filter a table based on the active cell’s value, font color or fill color.
How to Quickly Filter Data by color in Excel 2010 Read More »
A very cool shortcut you can use in Excel 2007 allows you to copy data from the cell above the current cell. Follow the steps below to learn how: Click Ctrl + “ (quotation mark) Say you enter the number 456 in cell A6. If
How to Quickly Enter Similar Data in an Excel 2007 Worksheet Read More »
Word allows us to create a border around our paragraphs if we choose to. If you like, you can apply borders to all four sides of your paragraphs. You can even go all out and have a different border for each side of your paragraph.
How to Set Distance Between Text and Borders in Word 2007 Read More »
You may know that you can enter multiple lines within a single cell by simply clicking Alt + Enter at the end of each line, which starts a new line for you. With a little work you can use that tidbit to create a
How to Create a Single Cell Bulleted List in Excel Read More »
When you launch Outlook, it will display Outlook Today or straight to a different location, which may or may not be the view you prefer. Opening Outlook to your window of choice can save you a couple of mouse clicks and land you exactly where
How to Change the Default Window that Opens in Outlook 2010 Read More »
I have had many clients in the past who railed about Outlook searches being too slow, but that was before version 2007. With the 2007 iteration of Outlook there were dramatic changes regarding the search capability. This was the dawn of Instant Search in Outlook.
Search Tips for Outlook Read More »
When you click that key combination in Word 2010 it no longer opens up the Find and Replace dialog box. Instead a pane will appear on the left-hand side of your screen that will allow you to search. Personally, I feel as if I have
How to Restore CTRL+F in Word 2010 Read More »
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 »
