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 ...
TWCN Tech News

Add, Change, Remove Author from Author Property in Office document

Whenever you create a new document, by default, Office sets the username based on the username settings that appear in the Word Options dialog box, as well as the PowerPoint and Excel dialog boxes. In ...