Cell to Show "Continued" only if > Page 1

S

Steve Klenner

Any way to create a cell formula that will show "Continued" ONLY if its
appearing on a page greater than page 1? There is only a single worksheet
with multiple pages.

I'd prefer NOT to use Header/Footer

Steve

--
 
J

JulieD

Hi Steve

you could do this with row numbers

for example, if you're getting 30 rows to a sheet then you could have a
formula in a column like
=IF(MOD(ROW(),31)=0,"continued","")

which will only put the word "continued" on rows 31, 62, 93 etc
 
Top