Reformat Worksheet

[Kizza]

I'd like to rearrange my door schedule so that the doors list sequencially but there doesn't appear to be an option to do this - am I missing it?

The list appears to be in the order I placed them, which is not how I want the schedule to read.

[James Russell]

Kieron,

See my attached before and after screenshots.

With the database header row (Row 4 for me) selected you can drag the icon for Sort Ascending from the titlebar and attach it to Column B with the Mark sorting in them.

Should do the trick, as long as the data is number based, I've had a few errors with numbers in text fields in the past.

Hope that helps.

J

[Kizza]

Perfect, Thanks!

I was clicking on the ascending icon but didn't drag it.

Is there a way of resizing the worksheet when you want to edit it?

The worksheet is 8pt to suit my sheet, when I edit it it's tiny!

[James Russell]

Yep,

Under the little drop-down arrow in the top right hand corner select Zoom>x% to scale up or down. Shouldn't effect the actual size on the page.

Cheers,

J

Edited June 27, 2013 by James Russell

[Kizza]

Thanks again, much appreciated.