Excel, by default, will allow you to edit your cell information in either the Formula bar or in the cell itself. You simply select your cell and click F2 or double click on your cell. However you may wish to disable the editing feature in […]
How to disable in-cell editing in Excel Read More »
Transposing (i.e., swapping columns, rows, etc.) is an old trick in Excel and I am happy to report that it is still available to you in Excel 2013! As you will see in my screenshot below, I have a worksheet in Excel that is vertical
The Transpose Feature in Excel 2013 Read More »
If you employ Styles in your Word 2010 document (and I hope you do!), and have your document organized with headings defined by Word, you can use the Outline view to move through your document. For example, suppose you have a rather large document and
How to Use Outline View to Navigate a Word 2010 Document Read More »
Even though you have already defined a style in your Word 2010 document, you can still change it at any time you like. Follow the steps below to learn how: Display the Home tab of your Ribbon. In the Styles group, click the small arrow
How to Change Word 2010 Styles Read More »
There are two types of page breaks that can appear in your worksheet in Excel 2010. Those would be Manual and Automatic. As you know, you insert page breaks manually by clicking on the Breaks tool in the Page Layout tab in the Page Setup
How to Control Display of Page Breaks in Excel 2010 Read More »
If you are familiar with using desktop publishing software, you already know that it is very useful to create text boxes and have your text flow automatically from one text box to the next. Why would you do this? Well, suppose you have a newsletter!
Flow Text Through your Word 2013 Documents With Linked Text Boxes Read More »
You can create myriad different embellishments to the text in your Word documents. One of the embellishments is vertical lines either at the left, right, or both sides of your documents or words, etc. There are a couple of ways in which you can accomplish
How to Add Vertical Lines to the Sides of a Word Document Read More »
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 »
