Kizza Posted June 27, 2013 Share Posted June 27, 2013 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. Quote Link to comment
James Russell Posted June 27, 2013 Share Posted June 27, 2013 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 Quote Link to comment
Kizza Posted June 27, 2013 Author Share Posted June 27, 2013 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! Quote Link to comment
James Russell Posted June 27, 2013 Share Posted June 27, 2013 (edited) 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 Quote Link to comment
Kizza Posted June 27, 2013 Author Share Posted June 27, 2013 Thanks again, much appreciated. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.