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

How to Copy Format Changes From One Table to Another in an Excel Spreadsheet. Microsoft Excel lets you format tables, adding borders and colors, and lets you format the text in them, editing font ...

If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.