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
- [Ctrl]
- ' (the apostrophe character)
- e
|
Keyboard Shortcut |
Example |
| [Ctrl]+' | é |
| [Ctrl]+` (apostrophe with tilde) | À |
| [Ctrl]+[Shift]+~ | ñ |
| [Ctrl]+[Shift]+^ | î |
| [Ctrl]+[Shift]+: | ë |
About Susan Harkins
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
Full Bio
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
