Ultimate Running List of All Helpful Microsoft Word/Excel Shortcuts & Formulas

The one thing all of us wish we had more of is time. Technology has helped us perform tasks that used to hours in minutes. But we all know that when we have to troubleshoot, it can take days.

Here is a list of all the helpful Microsoft Word/Excel shortcut that can help you save time here and there. I will continue to update this list as I think of shortcuts and formulas.

Microsoft Word

Ctrl+Alt+M = Add comment box


Microsoft Excel

Ctrl+Shift + "+" = Insert row or column/ Shift cells left or right
Shift + F2 = Insert a comment in a cell
Alt + R + D = Deletes comment in a cell
Ctrl + 1 = Open up the 'Format Cells' box

Formulas

To automatically calculate the day of the week.
Enter a date reference in cell A2
Enter =TEXT(WEEKDAY(A2), "ddd") into the cell in which you want the day to appear.

Labels: , ,