Excel tricks: How to convert a column to a row

Suppose you have a column of data and want to arrange it in a row rather than having it in a column, you can do so using the ‘paste special’ feature in Microsoft Excel.

  1. Copy the cells of the column you want to convert to a row.
  2. Right-click the first cell of the row you want to move the data to.
  3. Click ‘Paste special’ from the context menu
  4. Select ‘Transpose’ (at the lower right of the dialog box) and then ‘OK’

You’re done.

How to create active and inactives tabs in Axure

This short tutorial tells you how to create non-interactive active and inactive tabs in the Axure prototyping application. If you are interested in a tutorial that teaches you how to create interactive tabs, then drop a comment and let me know.
  1. Drag a rectangle from the widgets pane to the stage/ wireframe pane.
  2. Drag a second rectangle from the widgets pane to the wireframe pane.
  3. Right-click the second rectangle, select ‘Edit button shape’ and then ‘Rounded Top’ from the context menu.
  4. The rectangle will now appear as the image below.
  5. Snap-align the bottom edge of the ‘Rounded Top’ rectangle to the top edge of the rectangle below.
  6. Resize the second rectangle to the size of a tab.
  7. Copy and paste the tab (or click the tab, hold ‘Ctrl’ on the keyboard, and drag the tab) you just created and align it horizontally to the right of the first tab.
  8. Right-click the duplicated tab and select ‘Order’ and then ‘Send Backward (or use the shortcut ctrl+[) till the second tab goes behind the first rectangle.
  9. You’re done. You should now have one active and one inactive tab as appears in the image below.

If you want create a vertical tabbed menu, then choose ‘Rounded Left’ in place of ‘Rounded Top’ in step 3.