Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sorting

ResolvedVersion 2003

Brian has attended:
Excel Intermediate course

Sorting

When sorting can a page break affect the data being sorted, ie before page break is sorted, after page break stays in same position??

RE: sorting

Brian

Sorting should not affect the page breaks in the spreadsheet as sorting does not alter the number of rows in the sheet.

If this is a problem please send me the excel file. My email is newson@stl-training.co.uk

Thanks

Newson

Thu 5 Aug 2010: Automatically marked as resolved.

Excel tip:

Finding your worksheets quickly

The arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.