Click here to increase or decrease font size: A  A  A  A







Home Biography Published Works Blog Message Board Newsletter Guestbook Contact

Archive for the 'Office' Category



Friday, April 2nd, 2010
Rodent Program Managers – Update

This week the rodent program managers have become Nutria:

nutriapic

When I stopped to talk to them on Thursday, they told me that one of the development leads had confessed to both the capybara and nutria monikers and they think another PM had started it off with the squirrels tag but they’re not sure who labeled them hamsters.

Have to see what happens next week!

Friday, March 2nd, 2007
Excel – How to flip data axes (Transpose)

Another interesting question from a friend – If you have a Microsoft Excel spreadsheet and you realize your data should have it’s axes reversed (the data currently arranged vertically should be arranged horizontally), are you stuck retyping it or doing ugly cut & paste work for a long time?

Nope

The easiest way I’ve found to accomplish this switch is to make use of Excel’s own paste functionality.

  • Select all your data
  • Right click and choose “Copy”
  • Go to a new page in the spreadsheet and right click on the cell you want as the upper left cell
  • Select “Paste Special” from the context menu that popped up when you right clicked
  • Select “Transpose”
  • You’ll note that your data is now on the opposite axis from its original position.