Accidentally grabbing and dragging the fill handle? Find yourself staring at a piece of data you didn't place in the cell and have no idea how it got there? Here's an idea to try...
MS Office: Finding the Close All Command
Tired of closing each Word document separately? Learn where to find the Close All command in the newest versions of Microsoft Office.
MS Excel: Sum It Up Super Quick
Often I find myself writing a sum formula in MS Excel. It's not difficult and with Excel's Formula AutoComplete it really is simple to do, but today I have a technique that can improve our efficiency when it comes to this particular formula.
MS Excel: The Quick Way to Turn Formula AutoComplete On or Off
Learn to turn Excel's Formula AutoComplete feature on or off without going all the way into the programs options.
MS Excel: Align it Top, Bottom or Middle
Need to smooth things out in a too-tall row on an Excel worksheet? Give this alignment trick a try...
MS Excel: The F6 Key – Worksheet, Ribbon, Zoom, Worksheet, Ribbon, Zoom
Reach virtually any command in MS Excel with this incredibly quick keyboard shortcut!
MS Excel: When You Need a Calculator But Don’t Feel Like Writing a Formula
It happens to all of us - we're working on a spread sheet and we find that we need to calculate something but we just want to quickly get the information we need without all the formula writing nonsense. Thank goodness there's a calculator!
MS Excel: Extending Your Sequential Pattern
Most Excel users know that if you have data in a cell you can use the fill handle to increase the selected cell range down a column or across a row. Well, what if that range is more than one? April explores.
MS Excel 2010: See Your Trends With Spark
With the release of Excel 2010 we have another quick, easy-to-use and powerful tool to take a graphic look at the trend found in a set of data... Sparklines.
MS Excel: Cells to a Table – No Mouse Required
By now we've all found the Format as Table button on the Home tab of the Ribbon will take a range of selected cells in turn them into an easily and beautifully formatted table, but did you know there's an easier way?