This tip is really useful for Excel dashboards or anywhere that space is of a premium on a worksheet or, where your data set is just too large to comfortably display. Let's look at using a scroll...
Tag: Excel Tips
This is one of my favorite Excel tips..... Ever get a data download and one or more of your columns of data is downloaded or exported a text?. All you need to do to quickly convert the column of...
It is really easy to move a whole Excel data table to a new location on the same worksheet or even a new location on a different worksheet in the same workbook or an entirely different workbook. I...
Ever need to find out which value in your data set occurs most frequently? Yes I have as well more often than I thought I wold when I learned this Excel tip. Well here is a really easy way to do...
Excel Tip -Escape The Dancing Ants Around A Cell With One Tap
This is a small tip but a good one......Yes I called them dancing ants in the title of this tip but I am actually talking about the marquee that is around copied cells. If you want to quickly get...
If you need to share your train of thought or logic in your excel formulas or need a reminder to yourself of the formula purpose then you can add comments directly to the formula itself. After...