I have changed (in Page Setup) the orientation of my document from Portrait
to Landscape but Page Break Preview and the document itself does not show the
landscape format. When I print a page, the page setup changes show.
How do I see the document in landscape format so I can set column widths,
etc.?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...lic.excel.misc
This might seem a strange type of Excel question.
Some "Clever" person decided to create a site plan using MS Excel. It has been done quite well tbh. The problem with Excel is that I am unable to set a custom page size as this plan sits nicely on a paper size I made ealier through using Word. Guess what there is a custom page size selection on Word but not Excel. Is there a walkaround for this ?
The only other way I can do this, is to print off 2 a4 landcape print out but the printer goes to the next page and leaves a nasty seperation.
The copy of Excel i have is 2003 sp3
Have a excel document with multiple tabs that was created by an end user and
when the user prints the entire document to an HP Laserjet 4 printer it
prints fine.
When the end user sends the excel document to her manager and he prints the
document, the printer is asking him to load a A9 paper. It will not print
the spreadsheet until you load that paper.
The end user that created the document sends the document to severl other
people that have various printers. Some of them can print the document fine
while others can not.
Trying to figure out, why the document can print on some printers while
others it is asking your to insert a differnt page size other than letter.
Any help you can give me would be greatly appreciated.
How do you set up the size of the page (ie paper and margins) in excel 2007
If its not moving i can't see it !
I want to add a reference to a cell value in the header of an excel 4 page.setup macro. I've been trying to re-work a macro that John Green posted.
I've been trying variations on:
Dim head
Dim psetup
Dim sProductivityWeek As String
sProductivityWeek = cStr(Range("WeekOf"))
head = """&LPRODUCTIVITY WEEK OF """ & sProductivityWeek
psetup = "PAGE.SETUP(" & head & ", etc.
Application.ExecuteExcel4Macro psetup
Thanks
Richard
Hello.
I am trying to adjust the margins and orientation on an Excel 2007 file, but for some reason I cannot adjust Margins or Orientation - they're greyed-out.
How can I fix this?
See Screenshot below:
http://i150.photobucket.com/albums/s...dpicture-4.png
I am using Excel 2002, whenever I share my workbook through the company's network with another colleague, the page setup is all messed up such as print range and row to repeat at the top of the page. Does anybody know how to fix this problem?
Changing the scaling to a percentage does not change the page; but rather the
zoom factor of the windows display! (I am trying to print an 11"x17"
worksheet on a 22"x34" page, which works on our other workstations) This only
seems to be on my computer, and I've added SP2 and updates to make sure that
I have the latest of everything. I've looked through Options to try and find
a setting that may be causing this, but am having no luck. Thanks!
I've created an Excel spreadsheet with a header. The spreadsheet prints on 5
pages.
I want the header to print on pg 1 but not pgs 2-5. Is this possible?
Currently the header is a custom header and prints on every page. I'd prefer
fot he header to print on pg 1 only.....
Hello,
I have one Excel file that has been in use for quite a while. Now, everytime I go to the page preview and push the SETUP button, the whole workbook closes.
Upon re-opening the file, the document recovery is on the left hand side. So it seems Excel realized that there was a problem, even though no error message was ever displayed.
Does anyone have any ideas?
Thanks a lot,
Kai
