Hidden Excel: Spreadsheet Compare

Capture2

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

  1. Find and launch the app by clicking Start then typing ‘Spreadsheet Compare’.
  2. Click Compare Files. The Compare Files dialog appears.
    Capture
  3. Click the folder icon to select the older and newer files, then click OK.

Cheers

quincy

Related Posts

  1. Hidden Excel: Find Date Differences with DATEDIF
  2. Excel Text Functions 1 of 4: =LEFT() and =RIGHT()
  3. Using Histogram for Data Analysis

Editing an Email Subject line in Outlook

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.

2-1-2018 3-52-15 PM

To Edit the Outlook Subject line

  1. Open the message.
  2. Click the chevron (▿) at the far right of the message header. The header will expand down.
  3. Click your insertion point on the subject line and edit the text.
  4. 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.

edit subject

Modify your view settings to edit subject lines from the Message list.

  1. Click View and select View Settings. The Advanced View Settings dialog appears.
  2. Click Other Settings button. The Other Settings dialog appears.
  3. Check the Allow in-cell editing.
  4. OK. OK.

Click the subject line you want to change, and edit directly in the Message List.

Cheers!
ʎɔuınb

Additional Reading:

apples to: Outlook 2016, Office 365