Two simple Windows tips: show windows in full screen and convert Excel rows to columns

Two simple Windows tips that I confess didn't know previously: in Windows XP and Vista, you can double-click the windows' title bar to maximize the window. This trick is of course well-known and has existed I think since Windows 3.0, but what was new to me is that if you hold down Ctrl while double-clicking the title bar, you can fully maximize the window. This would be the same as pressing F11 on Windows basic shell windows and Internet Explorer. To return to the normal view, simply press F11.

Another tip is regarding Excel. If you have cells in Excel, say, in a row (top-down) but want them in columns instead, use the Edit/Paste Special/Transpose command. Yes, I've used Paste Special a lot ("Unformatted" is my most-needed option), but I've never noticed the Transpose option. Try it, works like a charm!

I learned about these tricks from the Microsoft AtHome and Office sites here and here.