Questions about sort and page break

  • Thread starter Thread starter Julie P.
  • Start date Start date
J

Julie P.

Hi, I have two questions about Microsoft Excel:

1) How do I sort more than 3 columns? Under "Data" > "Sort", it allows you
to do only 3 columns.

2) How do I get rid of the page break lines in my spreadsheet?

Thanks!
 
Hi
first sort the last columns (e.g. columns 4-6) and then sort the first
3 columns.
 
and you can select all the cells (ctrl-a, twice in xl2003) and then
Insert|reset all page breaks
 
Back
Top