To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

An Excel email address list should contain nothing but the addresses themselves. Yet if the spreadsheet received its data from an external form, the column may contain irrelevant text.

You can Cut or Copy Paste Columns and Rows in Excel spreadsheet - and keep the formulas and formatting using this step-by-step guide.

Forms created in Microsoft Word can be used to compile data on groups such as clients, purveyors and prospects, and later extract and import the data to an Excel worksheet.

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.

Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.