Page Layout View

re: Page Layout View

Luis Du Solier G — Thu, 06 Apr 2006 06:28:24 GMT

Oh!, Thats nice!

re: Page Layout View

Sam — Thu, 06 Apr 2006 07:45:44 GMT

Nice work on the Page Layout.

Will we have rows to repeat at bottom...

I any way use Excel to do everything.... including writting letters.... more reasons to continue doing so...

Is there a grid view.... row height and clolumn heigt made = 0.5 Cm so that the page looks like a graph paper....

re: Page Layout View

Tim — Thu, 06 Apr 2006 15:57:38 GMT

How does this compare to the similar feature in Excel for the Mac? I have been telling one of my Mac using friends about some of the changes coming to Office 2007, and when I mentioned the page layout view, he was shocked that it wasn't already available. He has apparently been using this mode as his default in Excel for quite some time.

re: Page Layout View

tjtjjtjt — Thu, 06 Apr 2006 16:09:08 GMT

How will Headers and Footers be handled? I get a lot of requests from coworkers for the scenarios below. If I was a help desk employee, I wouldn't....
A printed worksheet needs a different header on the first page.
A printed worksheet that will be used as an Appendix to a Word document needs to either start at a number other than 1 and/or have only the Header alternate on odd and even pages.
If I missed a post that covered this, could you direct me to it?

I am literally on my way to help a coworker who needs her Excel sheet (of approx. 1500 rows) to be inserted as a table into a Word document. The Page Layout features you have described here will be a great help, if the Headers and Footers can be made to match the Word document quickly and easily without VBA. (I'm interesested in VBA solutions but they are not allowed -- office policy.)

Thanks.

re: Page Layout View

Colin Banfield — Thu, 06 Apr 2006 19:45:27 GMT

<<How will Headers and Footers be handled? I get a lot of requests from coworkers for the scenarios below. If I was a help desk employee, I wouldn't....
A printed worksheet needs a different header on the first page.
A printed worksheet that will be used as an Appendix to a Word document needs to either start at a number other than 1 and/or have only the Header alternate on odd and even pages.<<

I'm wondering what's new in headers and footers also. What's lacking in current versions of Excel is a "section break" feature to do the stuff you're asking plus the ability to mix portrait and landscape pages in a printout.

The new Page Layout view is certainly welcome and looks good. For a long time I've considered Excel's page layout features and interface to be an embarrassment. Compared to Word, it's clunky and hasn't changed much since time begun. It's too bad that you can't print multiple selected ranges on a single page. For more than ten years this question has surfaced in multiple online forums and a common (but imperfect) workaround using the camera tool (buried so that no one can find it) has been suggested. Anyway, the new interface is a positive improvement.

Colin

re: Page Layout View

John McCall — Thu, 06 Apr 2006 21:10:00 GMT

Hate to leave this here but the charting blog is closed.

Work with alot of XML spreadsheets in XL2003 version and hate that there is no charting when using XML data. Im assuming this has been addressed with the 2007 release? correct - chating is available?

But further am wondering if the patches for the XL2000, XL2003 versions will also address this so that xml spreadsheets with charts will be backwards compatible?

re: Page Layout View

David Gainer — Thu, 06 Apr 2006 22:25:25 GMT

Sam, no rows to repeat at bottom this time ... and you could set up a template for graph paper.

Tim, basically the same feature as in the mac.

tjtjjtjt, Colin, headers and footers in a separate post. I hear you about the multiple ranges.

John, yes this has been addressed in 2007. We will have a full-feature XML format.

re: Page Layout View

Tianwei — Thu, 06 Apr 2006 22:46:57 GMT

While we are on the misc. options topics, can you have a separate topic on the new Options dialog boxes? Frankly it's quite messy in Excel 2000, over the years I have learned to find various options at different place but would like to see that improved. Any news is welcome.

Specifically, I'm curious whether Excel 2007 will allow more than 9 historical files be listed under File?

re: Page Layout View

David Gainer — Fri, 07 Apr 2006 03:31:58 GMT

Tianwei - I will add that to the list, as there have been some significant changes.

Excel will allow up to 50 files under File. Default is 9.

re: Page Layout View

Sige — Mon, 10 Apr 2006 15:34:15 GMT

> beside it has a watermark saying “Click Here To Add Data”.

Speaking of watermarks: Will you have a feature to show watermarks on each page?

Sometimes I find it very useful to have a "grey-print" over my page saying:
"Draft","Original", "Specimen", etc ...

Headers and Footers in Excel 2007

Microsoft Excel 2007 (nee Excel 12) — Mon, 10 Apr 2006 21:21:40 GMT

In the post last week on Page Layout view, some of you may have noticed the words “Click to add header”...

re: Page Layout View

Sige — Tue, 11 Apr 2006 11:47:32 GMT

> In the post last week on Page Layout view, >some of you may have noticed the words “Click >to add header”...

Yep ... but can I center my watermark "DRAFT" in the MIDDLE of my page ... in a let's say 45 angle, size 72, with a header/footer?

I don't think headers/footers are designed for that... where would one write the "normal" header/footer data then?

excel page break view

excel page break view — Wed, 30 Apr 2008 23:57:24 GMT

PingBack from http://francisconewsblog.hostclix.com/excelpagebreakview.html

repeat bottom rows on printout

repeat bottom rows on printout — Thu, 19 Jun 2008 22:04:15 GMT

PingBack from http://cooper.finestmatingstories.com/repeatbottomrowsonprintout.html

Microsoft Excel Page Layout View | home lighting

Microsoft Excel Page Layout View | home lighting — Fri, 19 Jun 2009 08:32:46 GMT

PingBack from http://homelightingconcept.info/story.php?id=2710