Sorting page numbers

  • Thread starter Thread starter Mike C
  • Start date Start date
M

Mike C

Is there a simple way of sorting pages back into numeric
order after building a large spread sheet so they appear
in ascending order on the monitor.
Without renumbering that is

Thanks

Mike
 
Hi Mike,
Your question is not clear to me, so here are three interpretations
even if it is a stretch compared to even what you indicated.

If you sorted the rows into a different order and want to restore
them you can restore the order if you previous numbered your
rows by placing a 1 on a new column (helper column) and
used the fill-handle to place 2 into next cell, and 3 into next, etc.

If you mean reordering the sheet tabs themselves into alphabetical
order. http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

This one is even further out. If you want to show the row number
you currently have then you can use the formula
=ROW()
or if you don't want it to match Excel's row number but that of the
data, something like =ROW()-1

What is unclear is what you mean by pages because you don't
see pages until the worksheet(s) is printed. Also by what you mean
by spread sheet (whether workbook, or worksheet).

If you are referring to the printing of pages coming out in reverse
order, some print drivers (not Excel) provide for printing in
reverse order, or odd then even pages, or Duplex (two-sided) printing.
 
Hi Mike,
Thanks for the feedback, it is always helpful to know which
kind of answer you were really looking for.

Incorrect terms can make for confusing questions.
Next question is should we pester Chip Pearson to add
definitions of "worksheet", "workbook", "spreadsheet", and "page"
to his http://www.cpearson.com/excel/posting.htm or should we
pester some of the people that have FAQ web pages for Excel.

Excel FAQs list of FAQ by John Walkenbach. .
http://www.j-walk.com/ss/excel/faqs/index.htm
Answers to Frequently Asked Questions about Microsoft Excel
Debra Dalgleish's site, contributions gathered by Harald Staff
http://www.contextures.com/xlfaqApp.html (see item #5)
 
Back
Top