Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sorting

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Sorting

Resolved · Low Priority · Version 2007

Reply Wed 19 Jan 2011, 16:02Delegate Tracy said...

Tracy has attended:
Excel Introduction course
Excel Intermediate course

Sorting

Can I sort a document for another user but for me to work on the orignal and update both at the same time?

For upcoming training course dates see: Pricing & availability

Reply Mon 24 Jan 2011, 16:24Trainer Anthony said...

RE: Sorting

Hi Tracey, thanks for your query. This is possible but it involves creating a second file for the other user to work on, which is linked back to yours. If you copy the data then using the drop down beneath Paste in a new file, Paste As Link, the result will be two dynamically connected files, which your user can sort while you update.

Hope this helps,

Anthony

Mon 31 Jan 2011: Automatically marked as resolved.

Excel articles

· Tools From Advanced Excel Courses: Goal Seek and Solver
· Radio Buttons And Check Boxes In Excel
· From novice to expert users - Microsoft Excel fits all
· How To Use Filtering In Excel 2010
· Make More of your Money with Excel 2007

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips