Microsoft Excel articles
An Excel chart can be inserted into a Word document. In addition, any edits done to the Excel Spreadsheet can automatically appear in the Chart in Word. Who knew! The beauty of this is any changes made in Excel will be in sync in the Word […]
Embedding an Excel Chart into a Word Document Read More »
A lot of folks seem surprised when they enter a date in Excel and it is not displayed in the manner it was keyed in. Unfortunately those same folks try to remedy this by keying in an apostrophe before the date. That will make the
How to Add the Day of the Week to a Date in Excel Read More »
If you have ever had a drawing object in your worksheet and wanted to flip it either horizontally or vertically and didn’t know how, this article is for you! Follow the steps below to learn how: Click on the object you would like to flip
How to Flip a Drawing Object in Excel Read More »
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
How to Set the Width of Row Labels in Excel 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.
How to Position Excel Graphics Evenly 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
Here’s a Neat Excel Trick for Pasting Formulas Read More »
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
Easily Remove Hyperlinks in Excel Read More »
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
How to Highlight Duplicate Values in Excel Read More »
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
How to Draw Borders in your Excel Worksheet Read More »
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 »
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 »
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 »
