Next Office challenge: Can you create a link with transposed data?

In this week's Office challenge, I share my favorite shortcut for entering accented characters. You can test your Excel skills with an Excel transposing challenge.

In the recent blog, Quickly transpose Excel 2010 data using Paste, I showed you how to use the Paste command to transpose data. For better or worse, this method doesn't create a link between the source and transposed data. How would you transpose data and create a link between the source and transposed range, so that updating values in one range updated the respective values in the other?

TechRepublic's Microsoft Office Suite newsletter, delivered every Wednesday, is designed to help your users get the most from Word, Excel, and Access. Automatically sign up today!
Last week we asked you to… List one keyboard shortcut for entering an accented character. Using the Insert menu and tab is certainly easy, but there's more than one way. You might find another way more efficient. For instance, to insert é, you can press [Ctrl] + ' + e before you can find t é in the Symbol dialog box! In actual keystrokes, that's

  1. [Ctrl]
  2. ' (the apostrophe character)
  3. e
No menus. No tabs. In a nutshell, you type a key combo and then type the character you want to accent. The following table should help you memorize these keystroke shortcuts. You don't have to worry about accenting a character incorrectly—if the accent isn't valid, Word will ignore the shortcut.

Keyboard Shortcut


[Ctrl]+' é
[Ctrl]+` (apostrophe with tilde) À
[Ctrl]+[Shift]+~ ñ
[Ctrl]+[Shift]+^ î
[Ctrl]+[Shift]+: ë
Your responses to last week's challenge were helpful as always. Spitfire_Sysop was the first to mention the ASCII table and using the [Alt] key with the numeric keypad. That method's been around for a long time and supports many special symbols. SirWizard was the first to mention my favorite technique, the one I just described. Thanks for all the great responses—it was another great challenge!