| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't open a created spreadsheet. Why ? | Excel Discussion (Misc queries) | |||
| Help, my macro always opens up spreadsheet it was created in | Excel Worksheet Functions | |||
| Calling for pages before they are created. | Excel Discussion (Misc queries) | |||
| How do I remove a list created in a spreadsheet | Excel Worksheet Functions | |||
| How do I delete 2000 pages created by Excel from my one page doc. | Excel Worksheet Functions | |||
Linear Mode
