How do I tell how many pages I have created in my spreadsheet

  • Thread starter Thread starter jsnatas
  • Start date Start date
J

jsnatas

How do I tell how many pages I have created in my spreadsheet? Where does it
say how many pages there are?
 
No that (in my case) ONLY shows 2 pages and I am at grid line 1533 so I know
there has to be more than just 2 pages
 
Are you saying that you have entered data from row 1 to 1533?

If i put x in A1 and x in A1533 my print preview shows 30 pages

--


Regards,


Peo Sjoblom
 
Yes I have entered data from row 1 to row 1533 and I guess I am not
understanding put an X in A1, how? where? and an X in A1533 how? where?
because when I highlighted from A1 to A1533 I still get only 2 pages under
print preview.
 
My assumption is you have a defined print area. Go to File, Print Area,
Clear. Then do a print preview. What do you get?
 
YAY!!!! Ok thanks that was the problem, dunno why I didn't think about that
one....what do I get ??? 114 pages.......have a great day and thanks
again!!!! :-)
 
The x has nothing to do with it, it was just an example
I used. I just meant if I put some text/numbers in AS1 and some text/numbers
in
A1533 my print preview shows as 30 pages.

Selecting a range doesn't matter, it all depends on that you have
real physical data in these rows which you seem to have.

Make sure you don't have anything set under file>page setup
like fit to 1 page(s) wide by 1 or adjust to 10% of normal size
or finally that you have a print area that is only 2 pages



--


Regards,


Peo Sjoblom
 
Thanks for the feedback, and don't forget to mark the question as answered
(if able :).
 
How do I do that, mark it as answered not finding anything other than marking
yes to your post answering my question
 
Nope, that worked. It was weird, until just now, wasn't showing answered. :)

anyway, I've done that before, it's why I thought of it immediately, lol
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function in Excel to count and list number of entries of text valuesin a row. 2
Create a icon. 3
Excel Excel spreadsheets opening at top instead of bottom. 4
Create Excel Lab test results 1
How do I print a one page spreadsheet multiple time, each with i. 3
How do I update links from .xls sheets to .xlms sheets 2
#N/A In Cells 7
Excel Spreadsheets keep moving 0

Back
Top