Today’s Date in a Cell

Need to quickly put today’s date in a cell? There are two ways depending on the desired result.

1) =TODAY() will update the date in the cell every time the file is opened. If today is March 12, 2014, that is what the cell will read. However, when the file is opened again in three days, it will read “March 15, 2014” because the function will update the contents of the cell.

2) Ctrl + ; will insert today’s date as text into a cell. This is helpful for documents that track when things were completed, as the date will not change when the document is re-opened at a later time.

Change all to Title Case

I’ve covered the quick and dirty way to change all text to UPPERCASE or lowercase in Excel by using Word and the shift + F3 trick, but that will not work for Title Case.

Say you have a list (or column) in Excel that looks like this:

To kiLL a MockinGBird
RoMeo and julieT
The GReat gatsBY
the CATCHer in the RYE

To make the first letter of every word in a cell uppercase (Title Case), use the PROPER function.

  1. In a blank column, type =PROPER(A1) where “A1” is the first cell of the list you are trying to change.
  2. Fill that formula down to the bottom of the list.
  3. Then, you can copy the now properly formatted list and “paste as values” into a new column OR over your original data.

Proper Case Function

Other Useful Text Case Functions in Excel

  • =UPPER(A1) – changes all text in a cell to UPPERCASE
  • =LOWER(A1) – changes all text in a cell to lowercase

Change all to UPPERCASE (or lowercase) – the quick and dirty way

Changing text case in Excel can be accomplished in many ways. For this quick and dirty tip, I actually recommend using a feature of Word. There’s probably a Very Good Reason why Microsoft included this handy shortcut in Word and not in Excel, but I have no idea what that Very Good Reason might be.

Say you have a list (or column) in Excel that looks like this:

To kiLL a MockinGBird
RoMeo and julieT
The GReat gatsBY
the CATCHer in the RYE

While you might be tempted to just retype each item in all uppercase or all lowercase, that would be a nightmare for longer lists!

Instead, open an empty Word document.

  1. Copy (ctrl + c) your list from Excel and paste it (ctrl + v) into Word.
    Hint: You can paste it as a table if that will help keep layout or formatting.
  2. In Word, select all (ctrl + a), and press shift + F3 on your keyboard.
  3. Keep pressing shift + F3 until your list is all in the case you want it in.
  4. Copy (ctrl + c) and paste (ctrl + v) the list back into Excel, and you’re done!
ORIGINAL SHIFT + F3 once SHIFT + F3 twice SHIFT + F3 thrice
To kiLL a MockinGBird TO KILL A MOCKINGBIRD to kill a mockingbird To kill a mockingbird
RoMeo and julieT ROMEO AND JULIET romeo and juliet Romeo and juliet
The GReat gatsBY THE GREAT GATSBY the great gatsby The great gatsby
the CATCHer in the RYE THE CATCHER IN THE RYE the catcher in the rye The catcher in the rye