Hints and Tips
Excel
 Transposing columns and rows
 If you have ever had data in a column and then decided that it would look or work much better in a row (or vice versa) this can be achieved without having to retype it. Instead:
1. Copy the data and then click into the first cell in which you want to paste it (not a cell in the selection – you can always use a different sheet).
Excel 2003 Excel 2007
2. From the Edit menu, select Paste Special. 2. Click on the Paste dropdown menu (in the Clipboard group on the Home tab of the ribbon)
3. Tick the Transpose box in the dialogue box. 3. Select Transpose.
4. Your rows are now columns and your columns have become rows.
   
Word
  
Using the Organizer to copy styles between documents/templates
 If you have created a Style in a document and you subsequently find it would be beneficial in a template, you can use Word’s Organizer to copy it from the document it was created in, to the template of your choice.
Word 2003 Word 2007
1. Open the Tools menu and click Templates and Add-ins. Click the Microsoft Office Button and then Word Options. In the Add-ins category, click the drop-down list next to Manage at the bottom of the dialogue box. Select Word Add-ins and click Go.
2. 2. At the bottom left of the dialogue box, click the Organizer button.
3. In the Organizer dialogue box, the currently open document is on the left.
4. On the right, the Normal (global template) is open.
You can also copy items from the template by clicking them in the list on the right and clicking Copy. Click the Close File button, and then Open File on either side, to navigate to any document or template as required. In Word 2003, you can use this same feature with AutoText entries, Macros and custom toolbars too.
5. Select the item on the left to copy to the template, and click Copy in between the two lists.
You can also copy items from the template by clicking them in the list on the right and clicking Copy. Click the Close File button, and then Open File on either side, to navigate to any document or template as required. In Word 2003, you can use this same feature with AutoText entries, Macros and custom toolbars too.