Sorting Deleted Items by Date Deleted, Not Date Received

by Pam Conway, CLO and VP of Operations @ Intellezy

Recently, while working in my home office, my cat, Edgar, hopped up on my desk and promptly parked himself on my keyboard. Before I could dislodge him, his furry behind managed to delete a huge swath of messages in my Outlook Inbox. These weren’t all new messages, I quickly realized. Many were a few weeks old, left in my inbox as reminders to follow up. When I hurried over to my Deleted Items folder and remembered that it lists all messages in the order they were received, not the order in which they were deleted, I understood the magnitude of Edgar’s actions. I would need to recall the exact subject lines of each message deleted and then scroll through the deleted items folder in the hopes of finding them further back in the chronology. The problem? I couldn’t recall the specifics of a single message, only that I was missing at least a dozen or more.

What to do?! Well, luckily, I remembered my ability to customize the field headings in any folder and I was able to add a column that allowed me to sort the contents of my deleted items folder by when it was modified, which equated to the date it was deleted. Here’s how I did it:

1. In the deleted items folder, click the View tab and then click View Settings.

2. Next, click the Columns button.

3. Click the dropdown arrow for the Select available columns from list.

4. Select Date/Time fields.

5. Select Modified from the list and then click the Add button. The Modified column heading will be added to the list of column headings on the left. It will appear in the last position, which equates to the far right of the list of columns in the folder.

6. Use the Move Up button if you want the Modified column to appear in a different location.

7. Click OK in each of the two dialog boxes to return to the deleted items folder.

8. You will now see a Modified column header. Click the header to sort by this field. All recently deleted messages will now appear at the top of your deleted items!

28 Keyboard Shortcuts You Should Know 

Today, more than ever, efficiency is the name of the game in every role and workplace. We are all trying to do more work in less time. Keyboard shortcuts can be an integral part of attaining that goal. Once you become familiar with keyboard shortcuts, they can become second-nature and save you time on an ongoing basis. 

The following shortcuts are available for use across all/most Microsoft Office applications. Below is a list of the most common and useful shortcuts. Remember, practice makes perfect! 

Ctrl + a  Select all document contents 
Ctrl + b  Turn “bold” on or off 
Ctrl + c  Copy the selected information 
Ctrl + d  Duplicate a selected graphic image 
Ctrl + i  Turn “italics” on or off 
Ctrl + n  Create a new document 
Ctrl + o  Open an existing file 
Ctrl + p  Print a document 
Ctrl + s  Save a document 
Ctrl + u  Turn “underline” on or off 
Ctrl + v  Paste selection at insertion point 
Ctrl + w  Close current document/window 
Ctrl + x  Cut selected information 
Ctrl + y  Redo what was undone 
Ctrl + z  Undo last change 
Ctrl + F1  Expand/Collapse ribbon 
Ctrl + Enter  Insert page break 
Ctrl + Home  Go to the very start of the document 
Ctrl + End  Go to the very end of the document 
Ctrl + Page Up  Go to the top of the page 
Ctrl + Page Down  Go to the end of the page 
Home  Go to the start of a line 
End  Go to the end of the line 
F1  Help 
F4  Repeat last command (make absolute in Excel) 
F5  Open the find and replace dialog box 
F12  Save as 
Shift + Any Arrow Key  Select text in that direction 

As of this writing: If you are planning to take the certification test please note that you cannot use keyboard shortcuts on the exam(s). 

 By John Dukarski-French 

Flash Fill Keyboard Shortcut

Flash Fill Keyboard Shortcut 

Flash Fill is one of the most popular new features in Excel 2013/2016. It will fill in cells for you automatically based on a pattern. So if you have first names in column A, and last names in column B, you can quickly fill column C with first and last names, or last names and then first names with a comma in between. Just supply the pattern for Excel, and it will do the rest. 

And there is a handy shortcut key for Flash Fill. Simply highlight the cells containing the pattern as well as the empty cells you would like filled, and then press Ctrl + E. It’s that easy! Excel will fill in the cells with Flash Fill. 

 To learn even more about Flash Fill and see it in action, click here: 

 You can find thousands more short-segment videos like this one at Start your free trial today.