ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I tell how many pages I have created in my spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/208096-how-do-i-tell-how-many-pages-i-have-created-my-spreadsheet.html)

jsnatas

How do I tell how many pages I have created in my spreadsheet
 
How do I tell how many pages I have created in my spreadsheet? Where does it
say how many pages there are?

Peo Sjoblom[_2_]

How do I tell how many pages I have created in my spreadsheet
 
Print preview would be one way

--


Regards,


Peo Sjoblom

"jsnatas" wrote in message
...
How do I tell how many pages I have created in my spreadsheet? Where does
it
say how many pages there are?




Sheeloo[_3_]

How do I tell how many pages I have created in my spreadsheet
 
One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet? Where does it
say how many pages there are?


jsnatas

How do I tell how many pages I have created in my spreadsheet
 
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

"Sheeloo" wrote:

One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet? Where does it
say how many pages there are?


Peo Sjoblom[_2_]

How do I tell how many pages I have created in my spreadsheet
 
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

"jsnatas" wrote in message
...
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

"Sheeloo" wrote:

One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet? Where
does it
say how many pages there are?




jsnatas

How do I tell how many pages I have created in my spreadsheet
 
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.

"Peo Sjoblom" wrote:

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

"jsnatas" wrote in message
...
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

"Sheeloo" wrote:

One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet? Where
does it
say how many pages there are?





John C[_2_]

How do I tell how many pages I have created in my spreadsheet
 
My assumption is you have a defined print area. Go to File, Print Area,
Clear. Then do a print preview. What do you get?
--
** John C **


"jsnatas" wrote:

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.

"Peo Sjoblom" wrote:

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

"jsnatas" wrote in message
...
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

"Sheeloo" wrote:

One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet? Where
does it
say how many pages there are?





jsnatas

How do I tell how many pages I have created in my spreadsheet
 
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!!!! :-)

"John C" wrote:

My assumption is you have a defined print area. Go to File, Print Area,
Clear. Then do a print preview. What do you get?
--
** John C **


"jsnatas" wrote:

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.

"Peo Sjoblom" wrote:

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

"jsnatas" wrote in message
...
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

"Sheeloo" wrote:

One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet? Where
does it
say how many pages there are?




Peo Sjoblom[_2_]

How do I tell how many pages I have created in my spreadsheet
 
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 filepage 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

"jsnatas" wrote in message
...
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.

"Peo Sjoblom" wrote:

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

"jsnatas" wrote in message
...
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

"Sheeloo" wrote:

One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet?
Where
does it
say how many pages there are?







John C[_2_]

How do I tell how many pages I have created in my spreadsheet
 
Thanks for the feedback, and don't forget to mark the question as answered
(if able :).
--
** John C **


"jsnatas" wrote:

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!!!! :-)

"John C" wrote:

My assumption is you have a defined print area. Go to File, Print Area,
Clear. Then do a print preview. What do you get?
--
** John C **


"jsnatas" wrote:

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.

"Peo Sjoblom" wrote:

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

"jsnatas" wrote in message
...
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

"Sheeloo" wrote:

One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet? Where
does it
say how many pages there are?




jsnatas

How do I tell how many pages I have created in my spreadsheet
 
How do I do that, mark it as answered not finding anything other than marking
yes to your post answering my question

"John C" wrote:

Thanks for the feedback, and don't forget to mark the question as answered
(if able :).
--
** John C **


"jsnatas" wrote:

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!!!! :-)

"John C" wrote:

My assumption is you have a defined print area. Go to File, Print Area,
Clear. Then do a print preview. What do you get?
--
** John C **


"jsnatas" wrote:

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.

"Peo Sjoblom" wrote:

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

"jsnatas" wrote in message
...
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

"Sheeloo" wrote:

One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet? Where
does it
say how many pages there are?




John C[_2_]

How do I tell how many pages I have created in my spreadsheet
 
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
--
** John C **


"jsnatas" wrote:

How do I do that, mark it as answered not finding anything other than marking
yes to your post answering my question

"John C" wrote:

Thanks for the feedback, and don't forget to mark the question as answered
(if able :).
--
** John C **


"jsnatas" wrote:

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!!!! :-)

"John C" wrote:

My assumption is you have a defined print area. Go to File, Print Area,
Clear. Then do a print preview. What do you get?
--
** John C **


"jsnatas" wrote:

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.

"Peo Sjoblom" wrote:

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

"jsnatas" wrote in message
...
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

"Sheeloo" wrote:

One option is to do Print Preview...

"jsnatas" wrote:

How do I tell how many pages I have created in my spreadsheet? Where
does it
say how many pages there are?





All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com