Nope.

But you could put your data in column B to whatever and use a formula like this:

In A3:
=if(b3="","",a2+1)
drag down for a few (lots of) rows.

And put 1 in A2 (and headers in row 1)


Then select your range A:whatever.
Data|filter|autofilter

Filter by non-blanks in column A when you want to print.

Data|Filter|Show all
when you want to see everything.


shewahya wrote:

I am trying to do a sign in sheet and would like horizontally at the top
name, address etc, and name is in A1, address is in B1 etc. for example. Is
there a way to make it so the numbering will reflect how many people sign in
without adding a column with numbering? Thanks in advance. Teresa

--

Dave Peterson