Hello all!
Please see the attached .xls file, I need to get rid of the extra blank pages where there is only the vertical page break... when I go on print preview I get 4 pages but I just need the 2 pages where there is the actual data... I know it appears trivial but I didn't manage to find a solution.
Please help!
ok.
Click the View Menu then select "Page Break Preview"
Select a any cell in any column from K onwards (just a cell) then type anything in that cell.
It will bring out the "breaks" then just adjust it for only 2 pages.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you! I tried that but not sure if it works, I clicked the View Menu and selected "Page Break Preview" , I wrote a letter in the first cell of column K and it brought up the "breaks" , but from there I'm not sure how to adjust for only 2 pages... please see the attached screenshot of what i have
thanks again!
Alex
your almost there.
position your mouse to the thick blue border then drag them to the proper position.. left, right and buttom.
i done it in your sample file. look below.
test.xlsx
great thank you! I managed to drab the thick blue border into the right position and now the printing area is correct.
However if I go in page layout I still get an extra page, please see the screenshot. Maybe it doesn't bother but i'd like to get rid of that blank page... so now the page break view is fine but the page layout view carries the extra page
thanks in advance!
You are currently positioned in Column M. So that Page is also activated.
Click anywhere in the setup page area say click - >Cell A1.
oppsss of course, yes solved, thank you!
Your very much welcome.
Btw, some tips since you're new in the forum.
You can mark your thread as "SOLVED".
For the meantime I'll do it for you.
How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks