Multiple users working on the same excel sheet

1. Go to Tools>Share Workbook>Editing tab
2. Click Allow changes by more than one user at the same time checkbox if needed and click OK
3. Save the workbook if prompted
4. Use File>Save As to save the workbook to be shared to a network location to which both users have access 
   

Reference: Muthukumar (http://nadarmuthukumar.blogspot.in) Hope you liked this and let me know your thoughts on post through your comments :)

Read More

Rotate Columns to Rows (or vice versa)

Sometime you must be in a need of rotating or converting your columns to rows like below or vice versa

Moving all the data one by one would be a tedious and time consuming work. To save you time and headache you can use special paste command to quickly transpose a column of data to row of data, or vice versa.

Move data between rows and columns 

1. Copy the data in one or more columns or rows.
2. Right Click on a cell where you want to paste your data, and then click Paste Special.
3. In the Paste Special dialog box, select Transpose, and then click OK.

You'll find the Transpose check box in the lower-right corner of the dialog box:

Note:
If you don't see the Paste Special command, make sure you right-click the first destination cell. You'll also find the command on the Edit menu. If you still don't see the command, make sure you're using Excel 2000 or later.

Reference: Muthukumar (http://nadarmuthukumar.blogspot.in), Microsoft Office

Read More