Printing Page Numbers
Is there an easier way to assign page numbers to a large
workbook other than to do it page by page? I was hoping
for some global method.
How about grouping your worksheets (right click on a worksheet and click on
"select all sheets") (Or click on the first tab and ctrl-click on subsequent--if
you don't want all the sheets.)
then File|Page setup|Header/footer
and set them all at once.
when you're done, make sure you right click on one of the grouped worksheets and
select "ungroup sheets". Everything you do to one of the group, you do to all
of ...Printing Checking register
I try to print register but only get balance and check amount but have
no list of check numbers or to who i paid. I have used quicken in the
past and was always able to print what I was seeing. How can I resolve
this problem. i need to send a copy of my register to a company. Thanks
for your help
...Computer freezes when printing mail merge in Publisher
When I use mail merge in Publisher, I can only print about 10 of the contacts
at a time or Publisher freezes. It doesn't seem to matter how large or small
the file size is either. The problem started when I got a new laptop. I
didn't have this problem on my old one, so I'm thinking it has to be a
setting somewhere. Thanks for any advice.
Hi r2knutso (firstname.lastname@example.org),
in the newsgroups
|| When I use mail merge in Publisher, I can only print about 10 of the
|| contacts at a time or Publisher freezes. It doesn't seem to matter
|| how larg...IF Statement #7
I'm trying to create an IF statement whereby if a certain stock in my portfolio goes up for that day's activity, it will display a green up arrow; if it goes down, a stick person dangling at the end of a rope. (Just kidding about that one). The GIF pictures I want to use will be in the same subdirectory as the Excel spreadsheet. I'm using Excel 2003.
Thanks in Advance!!
If you would care to use the WingDings font instead of a
GIF, try this:
=IF(K3>1," J",IF(H3>F3,"K","L "))
Then format the result as WingDings. You get either a
smile...Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus,
First of all, let me thank you in advance. I find it exemplary that
you all can devote time to helping others who are having issues with
their work. Hopefully one day I can be at a mentor level, and help
Hope you can help! I have an issue where I don't know how to write the
formula that I need without going over on the nesting. The current
formula that I have is as follows:
Data",IF(V7="Yes",&qu...PAGE SIZE DIFFICULTY
WHEN I CHANGE MY PAGE SIZE AND PAPER SIZE MY PUBLICATION REMAINS THE SAME.
COULD SOMEONE TELL ME HOW TO SHRINK MY DOCUMENT TO MATCH MY PAPER SIZE
>WHEN I CHANGE MY PAGE SIZE AND PAPER SIZE MY PUBLICATION
REMAINS THE SAME.
>COULD SOMEONE TELL ME HOW TO SHRINK MY DOCUMENT TO MATCH
MY PAPER SIZE
Choose Page setup from the File drop down menu and set the
page size to suit your needs. Note that elements on the
page do not change. You will have to rearrange to suit.
> WHEN I CHANGE MY PAGE SIZE AND PAPER SIZE MY PUBLICATION RE...publisher. why does webpage preview show only half page
When I'm viewing my webpage design in webpage preview I am getting a large
empty space on the right hand side and bottom of the page
On Fri, 17 Feb 2006 17:50:02 +0000, yousane wrote
(in article <65E39911-B9CA-4785-BD48-358D03F3695A@microsoft.com>):
> When I'm viewing my webpage design in webpage preview I am getting a large
> empty space on the right hand side and bottom of the page
And your problem is...? That's how it's supposed to be. Web pages designed in
Publisher do *NOT* fill the entire screen. I suggest you learn to use the
right tool for the job (I&...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...VB Macro #2
I have a macro that is generating Excel files. When the macro runs, it saves
two different tabs in the workbooks as values. It needs to test and wait
until the formulas that are pulling amounts from another database are
correctly populated with the amounts.
Right now, I am getting N/A# instead of amounts for some, but not all, of
the files. I think the problem is that the formulas have not completed
pulling the amounts before the macro pastes that tab as zeros. (N/A# is what
appears when the formulas have not completed calculating - once they have
completed, the N/A# is replaced ..."Customize Outlook Today" does not respond
The "Customize Outlook Today" button no longer functions.
I use Outlook 2000 on two separate computers. the
Customize feature works on neither one. They both
formerly functioned perfectly. I have noted a few other
postings with the same issue, but there have been no
responses. Is it possible that one of the updates to
Outlook 2000 has rendered this feature inoperable? Since
I keep my programs up to date, that is the only guess I
I have the exact same problem on more than one pc. I have
been searching for an answer all day. I just decided to
start using the opti...VCR to DVD Part 2
Many thanks for previous answers.
Yes, finalizing the DVD worked
I found that DVD-R need finalizing but DVD+RW disks do not
But why was I able to play the unfinalized DVD-R on one machine and not on
What was special about the first PC?
Bernard Liengme wrote:
> Yes, finalizing the DVD worked
> I found that DVD-R need finalizing but DVD+RW disks do not
> But why was I able to play the unfinalized DVD-R on one machine and not on
> two others.
> What was special about the first PC?
Almost anything will play a finalised D...Heading at top of page
Working in Word 2003, I put two spaces between a paragraph and the next
'heading 2'. This works fine until the 'heading 2' spills on to the
next page. There is then two spaces gap at the top of the page.
Is there a way to tell word to keep the heading at the top of the page
if it spills over? Don't want to put in a hard page break.
How are you creating the spacing? If you are pressing Enter twice, then don't.
Use Spacing Before instead (Paragraph dialog box, Indents and Spacing tab).
Microsoft Wo...Problem with macro assigned to custom toolbar button
Problem with macro assigned to custom toolbar button
I am having a probelm with macros assigned to a custom button on
custom button. I am using excel 2000.
1. I have created a macro called "Jump" in a workbook named "Test1"
2. I then created a custom toolbar and added a custom toolbar button t
3. Through the customize dialog box I assign the Macro "Jump" to th
Everything works fine UNTIL.
If I do a SAVE AS for the workbook "Test1" and call it something els
like "Test2" and then close "Test2" an...Printing In Color
Operating System: Mac OS X 10.6 (Snow Leopard)
I am trying to print a document in word that is color but it is only coming out in black and white. How can I change the color settings on my printer?
Word has no setting to print in color v. B/W -- that's a function of your
printer & its driver software. The settings are available in the Print
dialog in the Copies & Pages List, but exactly where the setting is located
depends to a great extent on what printer you have. Some printers also have
physical controls on the printer, itself, but that isn't common.
...set print area #2
Where is the "set print area" button in Excel 2002 that was in Excel '97?
> Where is the "set print area" button in Excel 2002 that was in Excel '97?
Are you sure it was "standard"? Only way I could get in was to right-click
the toolbar|Customise and drag it to the toolbar from Commands|File
...Email Statements from Collection Module
When I attempt to email statements from the Collection Module I am getting an
error message, ' Wrong number of arguments to 'RM_Statements_Update_Header'
...how do you get a landscape page?
Please help, desperate!
If you are using 2010, Page Design tab, Size, More pre-set page sizes. Letter
landscape is the first choice.
In all other Publisher versions landscape will be on the page setup screen found
in the File menu.
"becky.x" <email@example.com> wrote in message
> Please help, desperate!
...OEM publisher 2002 Sp1-2
I have the OEM version of Publisher 2002 and cannot find the Export as web page under File. Is there a way I can get that feature with a standalone disk?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Chicagogal <firstname.lastname@example.org>...
> I have the OEM version of Publisher 2002 and cannot find the Export
> as web page under File. Is there a way I can get that feature with a
> standalone disk?
The OEM version of Publisher is exactly the same as the release in every way
but the license, so the standalone version will be no differen...GP SP#2 hangs with sa and Collections Issue
I just installed 8.0 SP#2 (ran the script that it says to run cuz we had
upgraded from previous version to remove dups in smartlist tables) and when I
log into GP as sa, it hangs and CPU sits at 100%.
When I was able to log in previously to SP#2, I constantly received errors
about the CN_Collector_MAIN table with invalid column names etc. I've
deleted the table, then re-ran the create tables, but it keeps coming back
with this error. I've even gone into file > maintenance > sql and deleted
and recreated the table, but then get "number of results doesn't match ...Custom reports #3
I want to pull a report on how many customers I am getting
every hour of the day. Does anyone out there know how to
do that? I can try writing a query if someone can tell me
which table I can find this information in (timestamp,
transaction etc). Any help is appreciated.
This info is given at the end of the Z report.
If you want to use it in a query open the Z report
recipt file using the Notepad and see the fields that
are used... Report.Hour.HourSales etc...
Hope this helps...
> I want to pull a report on how many cust...Customize columns in 'Marketing List Members'
I can't figure out where one can customize the columns used within the
"marketing list" entitry when you click the 'marketing list members'
on the left side to show the members. I want to add some columns, like
Just read the Posting on the Microsoft CRM Team Blog.
<email@example.com> schrieb im Newsbeitrag
> I can't figure out where one can customize the columns used within the
>...Changing ip address of exchange server #2
I have a back-end server and a smtp server in DMZ.
I want to change ip address of back-end server. are there any issues?
all incoming and outgoing emails are going via smart host.
No issues at all as long as you remember to change all the references to
this server in your firewall, SMTP scanner etc.
"Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message
> I have a back-end server and a smtp server in DMZ.
> I want to change ip address of back-end server. are ...How can I print on 8 1/2"x17" paper?
I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
change the paper size to accept and print anything bigger than 14." any
suggestions would be greatly appreciated
First make the size settings in the Printer Setup. You may need to use the
"mickilena" <firstname.lastname@example.org> wrote in message
>I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
> change the paper size to accept a...Error with Bold
Range(Cells(1, 1), Cells(1, 2)).Font.FontStyle = "Bold"
Take a look at the activesheet. I bet that range is bolded.
But if you want Recent to be the sheet with the change, add a couple of dots.
.Range(.Cells(1, 1), .Cells(1, 2)).Font.FontStyle = "Bold"
Without those dots, the range refers to the activesheet (if the code is in a
> What's wrong?
> With Worksheets("Recent")
> Range(Cells(1...when opening an excel file, 2 files open (one is book1)?
When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
To prevent Book1 from opening you can append /e to your shortcut for opening
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e
Alternative to the above............
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.
If using WinXP OS you would scroll down to...