Saturday, February 6, 2016

Create a Drop Down List in Excel

Create a drop down list in Excel - In this video, I will show you how to create a drop-down list in Microsoft Excel. 
To make data entry easier, or to limit entries to certain items that you define, you can create a 
drop-down list of valid entries that is compiled from cells elsewhere in your workbook.
When you create a drop-down list for a cell, it displays an arrow in that cell. To enter information in that cell, click the arrow, and then select the entry that you want.

Tuesday, February 2, 2016

Shortcuts for Typing Accent Marks in Microsoft Word

All you need to do is press Ctrl and the accent symbol you want over the word. Release the key combination and type the letter to be accented, and there it is.

For example, if you want to type an é, press Ctrl (` is the key just left of the 1 key), and then release the keys. Type the letter e and it will show up with the dash above it. If you need an ñ, hold down Ctrl Shift ` (this is because the ~ is above the `, so you will need to use the Shift key, as well). Release that key combination and type the letter n. No more searching through symbols!