Quick Formatting Using Excel’s Format Painter
Formatting an entire spreadsheet to look just the way you desire can take longer than you’d expect. Clicking back and forth between the formatting options, usually repetitively, can possibly move the completion time of your project back. Excel does provide a quick way to copy a cell’s formatting and paste it to another cell or range of cells. Enter the Format Painter.
Read More
Find (and Delete) External Links
I’ve talked with many people that express frustration about having external links in their spreadsheet, but not being able to find them. If this has affected you, you’ve most likely noticed the warning Excel provides asking if you want to update external links when opening your spreadsheet. There are a few ways to locate these links and remove them if desired.
Read More
Adding Subscripts and Superscripts to a Cell
Ever wanted to add a subscript or a superscript to the contents of a cell? Excel provides a method to do just that, although it might not be intuitive to do so.
Read More
How to Stop Excel from Flickering during Macros
If you’ve ever written or recorded a macro in Excel, you’ve no doubt noticed that it shows everything on the screen you tell it to do. Depending on the code, Excel will show different cell locations or even different worksheets being selected during run time. Below I’m going to show you a line of VBA code that will not only eliminate those actions from being seen on the screen, but it will most likely increase the speed with which your macro runs.
Read More
Using Text to Columns to Separate Data
This post can be seen as a follow up to an earlier post, Separate Full Name into First & Last Name. Excel provides a very easy to use tool to separate delimited data into multiple columns. All that delimited data means is that your data is separated into different sections by a character(s), usually a tab, comma, percentage sign, etc. The same can be done with a macro or group of formulas, but it really is easy and convenient to use this built-in feature.
Read More

