Microsoft Excel’s sheet view collaboration feature is not new, but now it supports hiding rows and columns and applying groups.

Inhibiting the view of the header rows and the formula bar will tone down the “this is an Excel sheet, wander around and do whatever you like” mindset and keep users in the working area.

Click the top "View" tab and click "Normal" from the Workbook Views group to return to Normal view. Click the appropriate sheet name at the bottom-left of Excel 2007 to return to a specific sheet.

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

This cheat sheet gets you up to speed on the features that have been introduced or changed in Microsoft 365’s Excel for Windows desktop client over the past few years. (If you’re looking for ...

Exporting Excel worksheets as a plain-text comma-separated values (CSV) file is often preferred because this format is widely compatible with most spreadsheet software, makes data transferring ...

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need. Clicking the "Insert Worksheet ...