Working with an Excel workbook that contains confidential information such as financial data, personal details, or trade secrets? Here's how you can protect the data in your Excel file from prying ...

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