Questions about sort and page break

[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!

 

[Frank Kabel]

Hi
first sort the last columns (e.g. columns 4-6) and then sort the first
3 columns.

 

[Julie P.]

Hi
first sort the last columns (e.g. columns 4-6) and then sort the first
3 columns.

Thanks so much Frank!

Julie

 

[Dave Peterson]

and you can select all the cells (ctrl-a, twice in xl2003) and then
Insert|reset all page breaks