Conditional page break
is there a way in Excel to insert page break(s) depending from datas?
Better: I have an invoice list:
invoice # amount article ecc..
1001 4000 C01 .....
1001 5000 C02
1001 4500 C03
1001 3000 C04
1005 6700 C01
1005 4000 C04
and I want a page break _after_ the invoice number changes.
Is it possible to do that?
N! Xau, try this if your invoice numbers are ...Page breaks around every cell (Excel)
Every now and then I get page breaks around every cell. What causes
that and how do I get rid of them?
...Word documents only open as half pages
I have a students whose Word documents only open as half pages instead of
full pages. This is not a magnification issue, but rather only the top half
of the screen appears. Any suggestions?
Document windows are resizeable. Drag to show the rest of the document
window. Word should remember the window size and position (stored in the
registry) the next time it's opened. If it reverts to the half window, then
there's probably a corrupted Word Data registry entry. Because you didn't
specify the version of Word, I can't tell you where it is in the regist...rotation
Is there a way in excel to rotate the contents of the cell to 180 degrees?
Yep ............... Format>CELLS>alignment select the required orientation
"mireillea" <email@example.com> wrote in message
> Is there a way in excel to rotate the contents of the cell to 180 degrees?
Your system clock appears to be off since I show receipt at 7/9 @ 4:31 am
"mireillea" <firstname.lastname@example.org> wrote in message
new...Button hidden in Continuous form depending on specific record value
I've created a continuous form and I'm trying to display (or hide) a control
(text field or button) depending on the result of a combo box entry in each
individual record. Up to this point I've been able to create the code that
will display or hide the control but it does so for each record on the form.
Would you know a way to do it on a record by record basis??
While it may look as though you've got, say, 20 buttons on the form when
there are 20 rows of data, in actual fact there's only a single button,
repeated 20 times. That means that ...How can I cross reference a SmartArt Graphic to a page/text?
Operating System: Mac OS X 10.6 (Snow Leopard)
I am trying to allow users to click on the SmartArt Graphic on my first page and automatically go to the respective page within the document. I click next to the wording on the graphic and go to Insert, but it will not allow me to insert the cross reference. You can do it the other way around - from the text to the graphic, but not from the graphic to the text. Anyone know a way around this or another way to do it?
Objects cannot be used as active hyperlinks in a Word document. You can do
what you describ...Outlook Today as "Default Home Page' for Email/Tasks/Calendar
I have set Outlook Today as the page to open when I fire up Outlook (2007).
I like it.
BUT can I get it to display the Calendar, not just a list of appointments
that I have IN my calendar, but the week ahead calendar itself?
Tks n Rgds
no, you only get a list of future appointments.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCR...Page Setup shows 2 cm top margin, yet the page hs no top margin a.
When I open MS word (2003), my page setup appears to have no top margin,
however on opening the Page Setup window it indicates 2cm. Changing this
value seems to have no effect either.
This problem seems to have come from nowhere quite recently, with MS Word
working perfectly normally for the past few years...
Hope this helps
> When I open MS word (2003), my page setup appears to have no top margin,
> however on opening the Page Setup window it indicates 2cm. Ch...Can I add a scissors line down a page (in between two pages)?
Is it possible to add a scissors line down a page?
You mean like cutting out a coupon? BorderArt, draw a box, lines, more lines,
borderart. You can draw a line and make it dashed...
Mary Sauer MSFT MVP
"9thbit" <email@example.com> wrote in message
> Is it possible to add a scissors line down a page?
...Error On Page Message
How can I download a template if I get Error On Page Message
Post the URL for the Template so's we(I) can try to download.
May come up with something for you.
Gord Dibben Excel MVP
On Sun, 20 Feb 2005 04:31:01 -0800, GeeJay <GeeJay@discussions.microsoft.com>
>How can I download a template if I get Error On Page Message
the URL is http://office.microsoft.com/en-us/templates/TC061011771033.aspx
I cannot click download without getting Error on Page Message - thanks for
"Gord Dibben" wrote:
> Post the URL for the Template so's we(I) can try...Change Button Color.
I have a push button, can I change the button color when it's been pushed?
You will need to owner draw it in MFC. There are several examples of doing
this at codeguru and codeproject. Take a look at those.
Ajay Kalra [MVP - VC++]
"Frank E Rogers" <firstname.lastname@example.org> wrote in message
> I have a push button, can I change the button color when it's been pushed?
...arrows on page
I have hit something on the keyboard by mistake and now everytinme I answer
an email I have a pye symbol where I want to write and a dot between every
word and an arrow pointing down and to the left at the end of every line. It
is sending me bonkers.
How do I stop it?
> Help please,
> I have hit something on the keyboard by mistake and now everytinme I answer
> an email I have a pye symbol where I want to write and a dot between every
> word and an arrow pointing down and to the left at the end of every line. It
> is sendi...How I do I rotate text in an excel cell? The rotate commands is g.
I am trying to flip some text in an excel worksheet either as a block or opne
cell at a time. However the rotate command in the Draw toolbar is greyed out.
Go to Format -> Cells - then go to the allignment tab -
you will see that there is a control set in the bottom
right for doing this
If the text is in a cell, you can rotate it up to 90 degrees using
In article <4984E244-3011-4A69-8648-86F6A8BA85F0@microsoft.com>,
"MickG" <MickG@discussions.microsoft.com> wrote:
> I am trying to flip some t...is there a special way to centre pictures/text on the page
is there a special way to centre pictures/text on your page,
Like centre horizontally or vertically, any options like that? cause i cant
> is there a special way to centre pictures/text on your page,
> Like centre horizontally or vertically, any options like that? cause
> i cant find them
Which version of MS Publisher are you using?
Try the options at: Arrange / Align or Distribute...
MS Picture It! -
Digital Image MVP
Highlights and FAQs
I have a flyer created on full page. How do i shrink the whole thing to print
4 per page or is that posible in publisher?
While in a state of ecstasy after repairing his laptop, Ed sees a
message from Crickett <Crickett@discussions.microsoft.com>. On it is
> I have a flyer created on full page. How do i shrink the whole thing
> to print 4 per page or is that posible in publisher?
This is not possible in Publisher - you can use a utility such as FinePrint
(www.fineprint.com) to accomplish the same thing. Some printer drivers (HP,
for example), offer this functionalit...Text Rotation
In Word 2007, I can rotate the text left or right but I need the upside down
text (180 degree) in edit able format i.e. able to update in Mail Merge
process. Any one now how this task can be accomplish without an option of
Word Art or using Paint software to flipping the text. Any help in this
regard will be greatly appreciated
I use a shape box. Go to Insert, Shapes, then select a square. Type your
text. Now go to the Text Box Tools tab and click Format (if it is not
already showing). From here you will be able to remove the Shape
Outline/Fill and will be able to rot...freeze a heading so it will show on every page as I scroll down
I have headings across the top of my page, as I continue to type in info, the
headings "disappear". How can I make those "freeze" so as I continue to add
info in my spreadsheet I can still see the headings and so they will show up
on each and every page when I print!
"Karen" <Karen@discussions.microsoft.com> wrote in message
>I have headings across the to...Printer Friendly Email: Page Breaks
How do I insert a page break into the text of an email in
Outlook Express 5? Any other tips on where to go to learn
how to format email text using html? Thanks.
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.public.windows.inetexplorer.ie5.outlookexpre...News button is missing from customize toolbars
I tried to add the News button to allow the newsgroup
reader function. It was there at first. I followed the
instruction that said it was hidden, and I had to move it
from the Customize Toolbar menu. I went under the Go
section, and found News. I moved it to the Go section of
my file menu, and it was there. I opened the newsgroup
reader, and started to create a usenet account. I was
missing some info for my account, so I canceled out and
closed the newsgroup reader and Outlook. Now when I open
Outlook, the News button that I put under the Go File
menu is gone, and it isn't...put calendar on two pages in publisher- calendar is 2 pages wide
When using publisher, I want to make a calendar that spreads across both
pages. the templates only seem to allow me to put a calendar on one page.
Is there a way to do this?
Are you creating a booklet? How are your pages setup? What size is your stock?
Mary Sauer MSFT MVP
"nancyj" <email@example.com> wrote in message
> When using publisher, I want to make a calendar that spreads across both
>...Mail Merge Page Setup
I would like to know how to keep the same document settings from a mail merge
template to the merged documents.
I would like to set up features for printing etc in page set up. When I do
this in my mail merge template the features do not move into the merged new
Is this possible? How can I make this work?
...rotate a sheet on its axis
255 columns is not enough for me. I'm wondering if there is a way to rotate
my sheet 90 degrees so my columns are now rows and rows are now columns.
On Jan 15, 12:30=A0pm, sramsey <sram...@discussions.microsoft.com>
> 255 columns is not enough for me. =A0I'm wondering if there is a way to r=
> my sheet 90 degrees so my columns are now rows and rows are now columns.
> Thank You
Copy all your data then Paste Special (with the option transpose
checked). It will do exactly what you need.
Copy, then right-click, paste special, t...some images not loading on home page or web pages
i have windows vista running on a toshiba laptop with 2 user accounts - one
of the user accounts has no problem and all images are loaded when ever
displayed - the other user account only gets some of the images on their home
page and web pages but also boxes with red crosses inside where there should
Any suggestions as to how to make all these images load ok?
There are many things that can cause this. However, based on only what
you said, I would say it's possible one user has something running in
the background hogging up any RAM or what little RAM y...Importing pages from an existing Publisher document (2003)
I need to insert about 30 pages from an existing Publisher document into a
new Publisher document. Is there an easy way to do this - short of copying
and pasting everything?
Are the text boxes linked? Copying and pasting are tough when the text boxes are
linked. If you open the Office Clipboard, you can collect 24 items.
If you are game I have a method of combining Publisher documents on my web site.
It is not for the faint of heart.
Mary Sauer MSFT MVP
news://msnew...ole notes present button on allother windows
ole notes present button is existing only on employee maintenance window.it
should exist on all other windows so that end users can attach the files.
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.