How do I set Outlook so that when I am reading a long list of something in
the bottom portion of the screen, I can scroll down the list with the wheel
on the mouse as opposed to using the down arrow?
...Pivot question (2 parter)
I have four columns: Category, Year, Month, and Amount.
When I do a pivot table, I would like to have the Year and Month
appear horizontally across; right now, I can only get it to show
I would like to consolidate some of the categories and call it
"Others," rather than showing all of the details for those categories.
What is an easy way to do this?
<<Year and Month appear horizontally across>>
drag your month field to the COLUMN area in the wizard.
<<I would like to consolidate some of the categories >>
You will have to make anothe...How do I uhide the MENU bar?
I had been using the MACRO tutorial s on line.
After I came back to a spread sheet of my own I could not find my Menu Bar;
FILE EDIT FORMAT...etc
I don't know what the tutorials did, but you may want to try:
put a check mark in front of "worksheet menu bar"
If that doesn't work...
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
application.CommandBars("worksheet menu bar").Enabled = true
Then back to excel to see if that helped.
> I had been using the MACRO tutorial s on line...Form Size and Scroll Bars
We have added a number of fields to the opportunity form. For some reason
when the form loads the scroll bar goes all the way to the bottom of the form
and the user has to scroll back up to the top of it. Any ideas why this
might be happening?
Check out JScript in your onload event of opportunity. Is there any code
which is moving the focuss to some field at bottom of form?
PLEASE do click on Yes or No button if this post is helpful or not for our
uMar Khan :: Freelance Consultant
Email Contact :: imumar at gmail dot com
"MDV1457" w...Exchange 2003 IMF #2
I have just completed an upgrade from Exchange 2000 SP3 to Exchange 2003 SP1 and all went well. I would like to also install the IMF to help reduce my spam messages. I am currently running Groupshield 6 for Exchange, which handles my email virus/worm activity. I do also have the spam mail filter installed with Groupshield, but it only catches about 1 in 20 spam messages. It's junk!
My question is can I install the IMF on my Exchange 2003 server along with the Groupshield product that also scans for spam? Network Associates would not answer the question.
In the last exciting...Invoicing #2
I have a batch that has no transactions in it but it will not let me delete
it stating that "This Batch is being edited by another user" Which of course
is not happening.
Has anyone had this happen before or do you have any tips on how I might get
rid of this batch?
Go to Enquiry > System > batches
You can find this batch is editing with which user. Ask that user to login
to the system and open and close that batch.
> I have a batch that has no transactions in it but it will not let me delete
> it stating that "This Batch ...vlookups and hyperlinks #2
I want to be able to enter a specified code on sheet 1 and have it go to the
hyperlink I have for that code on another sheet where I have the codes and
hyperlinks listed in a table format.
might work for you.
> I want to be able to enter a specified code on sheet 1 and have it go to the
> hyperlink I have for that code on another sheet where I have the codes and
> hyperlinks listed in a table format.
...opening files #2
When I open an excel file from desktop or my documents
then I just get a blank page and a dialogue box saying
windows cannot find the file. I close the box then click
on to file and open and have to access it that way.
I think this started when I accepted window updates into
my computer recently and there were a lot as I think my
computer had been taking them in from the net and waiting
for me to install, something I hadn't done at all in the
year I have had this computer.
try the following:
goto 'Tools-Options-General " and uncheck "Ignore other Application...POP3 Retrieval marks unread messages as read in Exchange 2003 #2
When a user with a blackberry or treo downloads messages via POP3 to
the device, it marks them as "READ" even if they are not read on the
device. They don't stay "UNREAD".
I'm not sure when this started happening but I know it didn't do it
before because I'm affected too.
Users have Outlook 98 - 2003 and they use Sprint/Nextel Blackberry's
and I use a Treo with T-Mobile all through POP3
I found an article in microsoft that has a hotfix for Exchange 2000 but
nothing for 2003.
I am suddenly having the same exact problem. I need help on this issue fas...Scrolling Caption
Is there any way to setup scrolling caption for userform? Is that
possible in excel. I am using excel 2003. Thank you in advance.
Have a good day
On 13 May, 08:12, baha <bah...@gmail.com> wrote:
> Hello Everybody,
> Is there any way to setup scrolling caption for userform? Is that
> possible in excel. I am using excel 2003. Thank you in advance.
> Have a good day
Theres a couple of ideas on how to do this below:-
http://www22.brinkster.com/accessory/for...How 2 enter a value in the Status Bar?
I'm using excel 2000. I have a test formula: =IF($N$37=$O$38,"OK","ERROR")
I would like to use one of the boxes in the status bar to display the
I have 8 of them, from L to R;
2. SUM (or other f())
Is it possible to put the formula in one of these boxes, or in another place
in the status bar?
I need the result to be visible at all the times.
Thank you in advance for your help,
AFAIK you can't change this statusbar the way you want
Manuel Dav...How 2 use colors to organize in Outlook 2010 w/o using catgories?
In previous versions of Outlook I could use the "Organize" feature to change
the color of inbox mail. For example, I could say that mail with only me on
the To line would be red, mail from my boss blue, etc. In 2010 I can't find
this feature. I've tried to use Categories to compensate but it doesn't
automatically work on incoming mail and I don't see how to use Rules to
associate incoming mail actions with a cateogory. I'd really like that
Organize feature back! Anyone know how to do it?
The Organize feature was nothing more than a combination of f...Outlook 2003 notes scrolling
Is there any way to get Outlook 2003 Notes to have scroll bars or scroll in
response to the mouse wheel?
Nope, not possible
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Navigation Pane Tips & Tricks
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Ric" <email@example.com> wrote in message
> Is there any way to get Outlook 2003 Notes to have scroll bars or scroll
> response to the mouse wheel?
...My excell tool/menu bar disappeared and I cant find it or get it
My excell tool bar / menu dissapeared and I can't get it back? any help?
Do you see other toolbars on your screen ?
You can reset your menubar to default
Right click on a toolbar and choose customize
Under Toolbars select the worksheet menu bar
and click on reset
If not post back
Regards Ron de Bruin
"Littkerl" <Littkerl@discussions.microsoft.com> wrote in message news:10A45BDB-66FF-4916-8DA8-617298C1AB92@microsoft.com...
> My excell tool bar / menu dissapeared and I can't get it back? any help?
"Littkerl&qu...Money 2005 Small Business
I upgraded from Money 2k4 Small Business (SB) to Money 2k5
SB last week - and my custom invoice is gone! I've seen
some other posts on this but nothing definitive (yes,
I'ver searched first; TechNet too.)
Fortunately, I said a copy of the invoices to a .INV file
(when I had the portrait/landscape fiasco in 2k4). SO, I
go into Money Invoice Designer and import it. Comes in
fine, and I see my invoice - but when I save it an exit,
the invoice STILL isn't there.
In Money, I tried to import the .INV file, and I get an
error saying it can't import items made before 2002 ...Exchange Permissions #2
I am trying to can access to a user's Calendar where their local email
client is Entourage 2004. I have Outlook 2002. I have set the permissions of
the Entourage client and added the appropriate delegates as Reviewer's to
look at the Entourage Calendar. But when the Outlook client adds the
Entourage mailbox, nothin shows up in the calendar. Do I have to go back to
Entourage and do something from there? I thought the permissions had to be
setup from Outlook? Is there something in Exchange that I need to setup? I'm
not sure if this is even the right forum, so I have posted in...slow down scroll down
Is there any setting to slow down the scrolling in Excel?
I'm familiar with some keyboards ways to scroll but this
was a question recently asked by a student in class.
A good question but I don't know of any way to slow the
Any suggestions would be greatly appreciated !
No way to control this other than where you drag the cursor.
If you pull the cursor off the bottom of the window you will generally speed
Try dragging just at the the bottom edge of the sheet.
Gord Dibben Excel MVP
On Tue, 1 Mar 2005 07:24:15 -0800, "Jugglertwo"
<anonymo...How to insert = in formula bar
Already this problem is posted but not answered for the right solotion?
There use to be = button in the formula bar in Excell 2000 its not in excell
XP, I tried with the = button from the toolbar but it did not worked as it
did in excell 2000.
How about clicking the fx symbol to the left of the formula bar?
"Tirtha Raj Adhikari" <Tirtha Raj Adhikari@discussions.microsoft.com> wrote
in message news:C02F4277-B8AC-4BE3-897A-368B2C6FFDD0@microsoft.com...
> Already this problem is posted but not answered for the right solotion?
> There use to be = b...hide an Application from Task bar
I am trying to hide an application (or any application that's currently
running) from the taskbar and also want to restrict it from appearing in the
Can u guys point me to the API's required to get this...
MSDN Article ID: Q125714
"Yogesh" <A@b.com> wrote in message
> Hey Guys,
> I am trying to hide an application (or any application that's currently
> running) from the taskbar and also want to restrict it from appearing in
> Atl+tab list..
I am sure this is a really simple question to answer, but can I fin
out how to do it ? - No.
I have a lot of text that I would like the user to scroll through
perhaps in a text box. How do I do this? Do I have to link a For
Scroll bar to a text box?
I would really appreciate any help.
Message posted from http://www.ExcelForum.com
You might try a combo box from the Forms toolbar.
"ajw150 >" <<firstname.lastname@example.org> wrote in message
| I am sure this is a ...Flickering when scrolling
Can anyone help, when I open a spreadsheet in Excel 2002
and scroll down the page I get an annoying flickering.
Does anyone have any ideas on how to rectify this? Is it
a Hardware or Software Isssue? I'm using a Genius Optical
5 button mouse on Win XP, 2400 AMD Cpu, 256 DDR.
Could this be anything to do with my Monitor Referesh
Rate? It's set to factory default setting.
thanks in advance
...Excel auto format #2
How can I turn off the auto format (or whatever that it
is) that changes my 1-1 to 1 Jan 2004, 0r changes my 1-1-1
to 1 Jan 2001??
You can't turn that off.
Preformat the cell as TEXT or, enter it like this: '1-1
>How can I turn off the auto format (or whatever that it
>is) that changes my 1-1 to 1 Jan 2004, 0r changes my 1-1-
>to 1 Jan 2001??
Either pre-format the cells as Text or enter an apostrophe before the 1-1-1
Gord Dibben Excel MVP
On Sun, 15 Aug 2004 17:58:13 -0700, "w...How do you lock rows for scrolling ?
I'm new to Excel and using Excel 2002. I can do basic functions and basic
sorting, but that's about it at this point.
I've seen some Excel spreadsheet that lock a few rows. Then when you scroll
up only the rows below the locked rows actually scroll.
For example if you have names in row 4 and all the details for each of those
names in rows 5-200, how can you lock row 4 to always stay visible on your
screen, even when scrolling down to view the rows in the 100's?
I hope explained this well enough to get some help...lol.
THANKS in advance !!!
"FISH&q...create a drop down based on 2 previous inputs eg. country and are.
I wish to create a drop down in excel based on two previous conditions.
Condition 1 is country
Condition 2 is Area.
based on these responses I wish a third drop down to be created for crops eg
,rice ,wheat etc.
Can someone help me with this?
Read this first:
And read this next:
>I wish to create a drop down in excel based on two
>Condition 1 is country
>Condition 2 is Area.
>based on these responses I wish a third drop down to be
c...There were 2 contacts folders listed under address book....
So I did some research and discovered that if you remove and readd the
OAB service it will put it back to one. Great! Worked fine! Except
it turns out those 2 contacts folders had different listings.....so now
some of my stuff is gone :-( Where the heck did that 2nd one actually
reside? I've hunted everywhere and have no clue !!!
Melanie <email@example.com> wrote:
> So I did some research and discovered that if you remove and readd the
> OAB service it will put it back to one. Great! Worked fine! Except
> it turns out those 2 contacts folders had different ...