How to incorporate page counts in TOC
I need to find out how to incorporate each document’s total page count into
the Table of Contents instead of the current page number.
In my case, we have 20-60 separate document files that need a single TOC
that states the total number of pages for each file.
Section No. of Pages
I forgot to mention, I am using MS Word 2007
> I need to find out how to incorporate each document’s total page count into
> the Table of Contents instead of the current page number.
> In my case, we have 20-60 s...Printing Page Numbers for Multiple Worksheets
I am trying to print an entire workbook and would like the page numbe
to be specific to each worksheet set.
For example, my workbook contains 7 sheets, each of which has a uniqu
header that contains the command for Page X of X Pages. Each shee
contains multiple pages.
If I print the entire workbook, I can get the printout for each shee
to begin with a 1 by manually setting the First Page setting to "1" i
Page Setup. No problem there.
However, my question is...Can I control the command for "X Pages"? Fo
example, when I print the entire workbook, I'd like the first ...How do I delete a single page among many connected pages in Publis
I work with documents typically imported from Word. Occasionally I need to
delete a single page without changing the formatting on subsequent pages.
When I simply use Edit/Delete Page all of the original text from Word is
apparently in the overflow area because it is not visible. Text Boxes and
pictures that I inserted into the Publisher document after importing the main
document from Word do not seem to be affected.
...Three line charts on same chart
can I break the y axis to plot three series with total different value on the
same line chart and showing their clear paths.
These sites might help:
These examples deal with columns but you can easily apply the same concepts
to line charts.
> can I break the y axis to plot three series with total different value on the
> same line chart and showing their clear paths.
Here's anoth...sheet tabs as page number and in a cell page of pages?
i have looked a little but can't find what i think is the right thing.
i have a workbook with 3-4 pages in it. in the upper righthand corner
is a page of pages cells set up. i want to have it grab the current
tab(page) for one cell and the rest of the tabs(pages) for the other
cell. i am not very good at the coding VB thing so exact instructions
would be grately appreciated. i have tried a few of the suggestions but
cannot get them to work. i am using excel 2002. TIA
...header and footer on every page except the first page?
how do i put header and footer on every page except the first page?
In article <EBE1E559-C27E-47F9-BA16-0AA05EE9352E@microsoft.com>,
marany <firstname.lastname@example.org> wrote:
> how do i put header and footer on every page except the first page?
...Full Page POS Receipt
I have been making receipts for over a year and I have the following code
which I thought would print the receipt type in the top right of a full page
receipt (which it does) except for when it is an "On Account" order type
where if my statement made sense, it would print INVOICE in the corner
instead; it is however still printing Sales Receipt for an On Account ticket;
<BORDER> tbNone </BORDER>
<ALIGNMENT> ">~" </ALIGNMENT>
<CONDITION> Tender.Descriptor.TenderType = tenderAccount </...I did do an update today form Microsofts update page #2
If I can remember correctly, it was 2 new items that came
out today for the OS. Could that have casued this. But it
worked Ok afterwards. Nothing else installed in the last
...Print 2 pages on one page in Excel
I need to print 2 pages on one page, I have 3 colunms of data on each page
400 pages, I want to print 6 columnms wich would be 2 pages of data on one
page how do i do this??
Look on David's site
Regards Ron de Bruin
"BIGCHAD36" <BIGCHAD36@discussions.microsoft.com> wrote in message news:BD9FC46D-2DBC-403D-9B96-EFA2A503A0C3@microsoft.com...
>I need to print 2 pages on one page, I have 3 colunms of data on each page
> 400 pages, I want to print 6 columnms wich would be 2 p...Attachment inside word
How can I attach my excel spreadsheet inside MS word. So that when th
user opens MS Word and icon appears containing my excel file. Is thi
please help, ThaNKS
kkondrat1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=600
View this thread: http://www.excelforum.com/showthread.php?threadid=27213
in Word use 'Inser - Object - From file'. Choose your Excel file and
check 'Display as Icon'
kkondrat1...Bug: printing of a specific page range is broken in MFC-VS2005
If you create an MFC application that includes printing support, and your
application does print-time pagination as described in this MSDN library
then specifying printing of a specific range of pages in the print dialog
does not work. The application always prints all pages of the document.
To see this problem download and build the WordPad sample MFC application.
Start a new blank document, then paste into it enough text to fill several
pages. Choose Print from the File menu. Choose a print range of page 1 to
page 1....Reordering Pages
I have a multi-page document where the pages go from the last
page to the first. How can I reverse this so that when i open the
document I see page 1 rather than page 8?
Try running a macro containing the following code:
Dim i As Long
Dim Source As Document, Target As Document
Dim trng As Range
Set Source = ActiveDocument
Set Target = Documents.Add
For i = 1 To Source.BuiltInDocumentProperties(wdPropertyPages)
Set trng = Target.Range
trng.C...Business Portal "Copy to Excel" not working in Query pages
I am using Business Portal 4.0. When browsing through one of the queries
pages in Business Portal, i clicked "Copy to Excel" icon. I got an error
saying "The Office Web Components (OWC) must be installed to copy results to
Excel." at the bottom.
I am using Office 2007 on my machine. I came to know that Microsoft Office
Web Components will no longer be shipping in Microsoft Office. I tried
installing Office 2003 Add-in: Office Web Components from
a...Page Breaks 02-07-08
Is it possible to insert a page break in a report header?
Try it and report back with your results.
Microsoft Access MVP
> Is it possible to insert a page break in a report header?
You can insert a page break into a header so that part of the header prints
on the next page, if that is what you mean, but it is hard to see why you
would want to do that.
Each section of a report, including the header, has a Force New Page
property. Perhaps that is what you are seeking.
"Bev" <Bev@discussions.microsoft.com> wrote in message
new...Changing page numbers #2
Is there any way of making page numbering start at a different number?
I created a 16 A5 page document, the first two and last two sheets were a
cover page which I printed separately.
When I printed pages 3-14 I was asked if I wanted the pages to be printed as
a separate document and I replied YES. However the page numbering on this
separate document started at page 3 - I would have preferred page 1.
The obvious solution of deleting pages 1,2,15,16 did not work. When I
deleted pages 1 and 2 the text moved on leaving blank pages. I realise now
that the text of the document was a continuous s...Change Business Portal home page
Can someone point me to some clear info about changing the default home page
in Business Portal 2.5. I want to remove the default links/tasks(?) in the
Key Information section and replace them with some new ones.
To remove the defaults I have done the following:
1) Manage Portal Pages then for Directory page in Page List, for Roles I
removed Employee (did the same for Benefits page)
2) Removed the Benefits menu item (see p.110 of admin guide). This was at
Manage Navigation -> Change Menu Organization, then selected Benefits and
chose Remove. Did the same for Policies.
3) Under Set up ...rotate page #2
How do you rotate a single page in a multi-page document in Publisher?
"Rotate page" brings back no help in MS Help...
You cannot rotate the "page", you can rotate all the objects on the page. Select all
the objects, group, you can either rotate manually or the arrange menu has options.
Mary Sauer MSFT MVP
"jim e." <jim e. @discussions.microsoft.com> wrote in message
> How do you rotate a single page in a ...Page Break Preview
Operating System: Mac OS X 10.5 (Leopard)
What happened to Page Break Preview in Excel 2008? This was an excellent feature but can't find it now.
This view got replaced by the Page Layout view.
On 30/07/08 23:27, in article email@example.comR9absDaxw,
"firstname.lastname@example.org" <email@example.com> wrote:
> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: Intel
> What happened to Page Break Preview in Excel 2008? This was an excellent
> feature but can't find it now.
Michel Bi...IE8 not presenting web pages correctly
My IE8 won't show some web pages correctly, even with the Compatibility view
activated. Some pages I can't use to enter comments, or enter an ad to sell
And what is more strange: In the window Add or remove programs the "Windows
Internet Explorer 8" is presented as seldomly used; in fact, last time used
says May 14, 2009, which is more than 6 months ago. I use it daily,
Has anyone any idea on this? Is there somewhere I can download an
installation file for the IE8 to re-install it? (When I try via the web, I
just get the remark that I alrea...formatting all the pages
This is a multi-part message in MIME format.
I asked this a few days ago, as to setting up each page in a calendar =
alike (so the picture is in the same place on each page)
I probably confused everyone by not asking it clearly.
I'm coming across the same question again. I'd like to format/set up =
ONE page of a calendar and have it applied to all the pages, is this =
possible? Without having to go over each page and use rulers, and line...How Print a horizontal page?
How Print a horizontal page?
"Adri�n" <Adrin@discussions.microsoft.com> wrote in message
> How Print a horizontal page?
Have you tried printing in Landscape mode?
Replace the _nosp@m_ with @ to reply.
...Finding current printer page number
I have hunted for this without success.
I want to know - programmatically - what page the active cell is in.
More precisely, what page ActiveCell.Top is in.
(I take it some sows can split into more than one page.)
I want to automate putting manual page breaks into a sheet.
I would put breaks at or before those automatically inserted by Excel.
In message <KBH7nVN7dSuJFwvS@freenetname.co.uk> of Thu, 12 Mar 2009
15:17:15 in microsoft.public.excel.newusers, Walter Briscoe
>I have hunted for this without success.
>...Hiding/Unhiding Fields in a Data Access Page
I created a Data Access Page for my small department (5 users spreadacross the country) to track project status in an Access database on ashared drive. I figured this would be a lot less of a hassle thanreplicated databases and FE/BE setups. At this point, I've reached amajor brain cramp. My boss wants me to make some fields viewable onlyif a particular checkbox is selected. I know how to do this veryeasily in forms using VBA and macros, but I'm just plain stumped inDAP; I can hide the fields via format properties under the ElementProperties dialog, but cannot unhide them via code....3 leaflets in landscape on an A4 page. Any suggestions?
Microsoft has wonderful templates. Love them.
Can't find a leaflet back and front which is on an A4 page which requires
only 2 slices to make it in to 3 leflets. Max usage of paper, minimum cost
and minimum environmental cost.
Start with something close and modify it. Or remember that not everything
needs to be started with a template. Creativity goes a long way.
MVP Microsoft [Publisher]
"Rosemarie" <Rosemarie@discussions.microsoft.com> wrote in message
> Microsoft has wonderful...Clone styles (and content) cellwise across pages
Is there a way to make a "master page" of styles and content, which would
assign the style and content of that page to all the same cells of other
pages in the workbook?
Or possibly, assign a "category" to the cells that will make them take the
style of the category?
if you group your sheets when formatting the first sheet - all the sheets
will get the same formatting (to group sheets, click on the first sheet,
hold down your shift key and click on the last sheet). remember to ungroup
them before you do anything specific to the first sheet (...