How-To Geek on MSN

The 4 Excel find and replace tricks I use to save hours

Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
How-To Geek on MSN

I use these 7 Excel shortcuts to find and fix spreadsheet errors in seconds

Instead of selecting all errors, press F5 > Alt+S > C > Enter to highlight all constants—numbers, text, and symbols that aren ...
Houston Chronicle

How to Convert True-False to Check Boxes in Excel

Microsoft Excel's form controls can turn the Boolean options of a true-false choice into a clickable data-entry option. If you create spreadsheets to record business information about sales, personnel ...
Ars Technica

Excel question: Out of memory on a VLOOKUP function. How do I work around it?

I am running into the dreaded "Excel cannot complete this task with available resources" dialog box in Excel while trying to fill a column with a simple VLOOKUP equation. I have one column with ...