Learn Excel Episode 394: Copy Values
Today's tip comes from Dave in Columbus, Indiana. Dave was at my Power Excel seminar last week and passed along a better way to invoke the Paste Special Values command. In the process of showing Dave's trick, I also talk about joining text using the concatenation operator, changing text from upper case to proper case, copying a formula by double-clicking the fill handle, using Ctrl+z to undo. Episode 394 shows you how.