This hidden gem, (available with Office Professional 2013, 2016, and Office 365 ProPlus) makes it easy to compare two workbooks, interactively. You can see how values, formulas, and formatting differ – line by line, and cell by cell, highlighting just the type of differences you specify.
To Use Spreadsheet Compare
- Find and launch the app by clicking Start then typing ‘Spreadsheet Compare’.
- Click Compare Files. The Compare Files dialog appears.
- Click the folder icon to select the older and newer files, then click OK.
- Hidden Excel: Find Date Differences with DATEDIF
- Excel Text Functions 1 of 4: =LEFT() and =RIGHT()
- Using Histogram for Data Analysis
WithEmail, a good subject line is essential for good filing, however not every sender considers that when composing their email. If you received an email that needs a more descriptive subject, follow these steps to edit the Subject line.
To Edit the Outlook Subject line
- Open the message.
- Click the chevron (▿) at the far right of the message header. The header will expand down.
- Click your insertion point on the subject line and edit the text.
- Close the message, selecting Yes, when prompted to save (alternatively, press CTRL+S to save edits prior to close).
Want to edit the subject lines a little quicker? Change your Outlook View Settings to edit subjects lines directly from the Message List.
Modify your view settings to edit subject lines from the Message list.
- Click View and select View Settings. The Advanced View Settings dialog appears.
- Click Other Settings button. The Other Settings dialog appears.
- Check the Allow in-cell editing.
- OK. OK.
Click the subject line you want to change, and edit directly in the Message List.
apples to: Outlook 2016, Office 365