Posts Tagged ‘ Microsoft Office ’

Microsoft Office help function is your friend!

The Microsoft Office help buttons have helped me so much at work that I should get it a present or something. I think I’m well versed in the basic to intermediate skills, but it helped me with advanced things I never knew Excel, Word, PowerPoint, or Access could help with.

This came up in my last job because my boss asked me to do an assignment where she wanted to transpose information from a column to a row, but she didn’t know how to do it and assumed I didn’t know how to do it either. So she said if I figure it out great, but don’t worry about it. Well, I clicked on my handy dandy Microsoft Excel button and typed in that situation. It popped out exact instructions on how to do it. My boss was impressed! Thanks Microsoft Excel help button!

Here’s what I found. Couldn’t get the graphics to load , but if you type “transpose data from columns to rows” it should come up:

If data is entered in columns or rows, but you want to rearrange that data into rows or columns instead, you can quickly transpose the data from one to the other.

  1. On the worksheet, do the following:
  • To rearrange data from columns to rows, select the cells in the columns that contain the data.
  • To rearrange data from rows to columns, select the cells in the rows that contain the data.
  1. On the Home tab, in the Clipboard group, click Copy .

Keyboard shortcut To copy the selected data, you can also press CTRL+C.

Note You can only use the Copy command to rearrange the data. To complete this procedure successfully, do not use the Cut command.

  1. On the worksheet, select the first cell of the destination rows or columns into which you want to rearrange the copied data.

Note Copy areas (copy area: The cells that you copy when you want to paste data into another location. After you copy cells, a moving border appears around them to indicate that they’ve been copied.) and paste areas (paste area: The target destination for data that’s been cut or copied by using the Office Clipboard.) cannot overlap. Make sure that you select a cell in a paste area that falls outside of the area from which you copied the data.

  1. On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Transpose.
  2. After the data is transposed successfully, you can delete the data in the copy area.

Tip If the cells that you transpose contain formulas, the formulas are transposed and cell references to data in transposed cells are automatically adjusted. To make sure that formulas continue to refer correctly to data in nontransposed cells, use absolute references in the formulas before you transpose them.

 

Advertisements