Learn Excel from Bill Jelen with this daily 2 minute video podcast.
More tricks with the Paste Options menu, this time with Live Preview. Episode 1086 shows you how.
Labels: 2010, Paste Special
posted by Bill at 9:00 AM
A preview of new features coming in Excel 2010: Episode 1066 shows you the Paste Options shortcuts in Excel 2010.
Labels: 2010, Paste Special
posted by Bill at 9:00 AM
Gary sends in a clever solution for Episode 977 which uses the Skip Blanks option of the Paste Special dialog. Watch for how Gary can "reverse" the filtered and hidden rows during the steps shown in Episode 981.
Labels: Filter, Paste Special
posted by Bill at 9:00 AM
Another dual podcast as Bill Jelen and Mike Gel Girvin show you multiple ways to reduce a range by 35%. Shot in Seattle, Washington. Episode 966 shows you how.
Labels: formulas, Paste Special
posted by Bill at 9:00 AM
Seven ways to paste values in Excel. While I talk about many ways to convert formulas to values, Don from Orrville has come up with a method shorter than the other 6 methods I usually discuss. So...drumroll please... Episode 877 with method #7 for doing Paste Values!!!
Labels: Paste Special
posted by Bill at 9:00 AM
Tim asked a question about writing a formula that he could copy across a row which would automatically grab successive values from down a column. (Basically doing a Transpose that is always updating). In Episode 835, I will show you my formula method and also discuss Kathy's easier suggestion that will work in some cases.
Labels: formula, Paste Special
posted by Bill at 9:00 AM
A question from a seminar... how can you use the consolidate command to subtract one data set from another data set? Episode 787 shows you the workaround.
Labels: consolidate, Data, Paste Special, subtract
posted by Bill at 9:00 AM
Say that you need to copy column widths from one range to another range. The Paste Special dialog now offers the opportunity to paste column widths from one range to another range. Episode 698 will show you how.
Labels: Column Widths, Paste Special
posted by Bill at 9:00 AM
Mike from Kansas City asks if there is a way to take words from many adjacent cells and merge them into a single cell. Episode 578 shows many approaches to this problem.
Labels: Concatenation, Paste Special
posted by Bill at 9:00 AM
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.
Labels: Concatenation, keyboard shortcuts, Paste Special, shortcuts
posted by Bill at 9:00 AM
Your company system produces a data export where all of the numbers in a column appear as negative instead of positive. Episode 355 will show you a trick with Paste Special Multiply to correct this problem.
Labels: Number Format, Paste Special
posted by Bill at 9:00 AM
