Excel 07 selects 3 cells when I click on 1
Hi I just got 2007 (I want 2000 back) and a lot of the time when click on an
empty cell 2 or more below it are selected and the typing goes on the bottom
row. I just want to select the cell I click on.
Are the cells merged??
I don't like the 2007 either!
If i could i would have the look and feel of 2003 on the engine of
On Thu, 1 Nov 2007 20:21:01 -0700, Brian
>Hi I just got 2007 (I want 2000 back) and a lot of the time when click on an
>empty cell 2 or more below it are selected and the typing goes on the botto...Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu.
Under Look In options
Find allows for search by formulae OR values OR comments
Replace is restricted to formulaes ONLY
Have a look at this google search result. This topic came up a couple days
ago and was addressed by Dave and Myrna.
Gord Dibben Excel MVP
On Fri, 28 Jan 2005 03:49:02 -0800, "cp" <email@example.com> wrote:
>Under Look In options
>Find allows for search by formulae OR values OR comments
>Replace is restricted to formulaes ONLY
...Synchronise Outlook 2003
I am using outlook 2003 on a laptop. I would like to sync my changes with my
assistant outlook 2003 when I get back to the office. Is it possible to sync
I do not want to use a central data base but really sync 2 different data
phil <firstname.lastname@example.org> wrote:
> I am using outlook 2003 on a laptop. I would like to sync my changes
> with my assistant outlook 2003 when I get back to the office. Is it
> possible to sync contacts ?
> I do not want to use a central data base but really sync 2 different
> data bases.
http://www.slipstick.com/outlook/...Setting up Exchange 2003 in a new environment
I need some guidance as I am preparing to setup a new domain and
this company currently has no internal domain structure, and no email
structure at all. however their website/domain is being hosted through
service provider, which has included a certain # of email accounts that
can be used, via POP3 and SMTP.
for these email addresses to work with the new exchange, what are some
of the steps that I need to ensure that I use, in order for email to
properly work internally and externally?
I know that I need to have a DC structure put into place first, with
...how do i enable dde in excel?
i am posting a DDE link into an excel cell from an external program and
getting the message
' DDE Not enabled' in the cell once the link is pasted in.
how do i enable DDE?
...Conditional Format order
Is there an easy way of changing the order of the three conditional
formats for a cell, or do I just have to re-type them all?
Thanks - Dave.
Sorry, no quick and easy way - just be glad there aren't more to deal with!
Do remember that you can change groups of cells to same conditions, at least
you don't have to do that one at a time.
> Hi all,
> Is there an easy way of changing the order of the three conditional
> formats for a cell, or do I just have to re-type them all?
> Thanks - Dave.
You could open...excel file can't be opened #2
I have a recent excel file (about 1 month),but since two days ago,the file
can't be opened completely or always not responding.
What should I do so that I can use this important file.
Any help would be appreciated
...Outlook 2003 attach File Browse Window Stops Responding
In outlook 2003 when I try to attach a file and the browse window pops open
to browse for the file I want to attach the window will stop responding and
I have to force quit the outlook.
do you have mapped network drives? how long do you wait before quitting
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipsti...How to transpose in excel file
Hi I would like to make a transpose like this?
House Defect How much
#1 Broken Sinks 1000
#1 Bad Paint 2000
#1 Bad Lighting 1000
#2 Broken Sinks 0
#2 Bad Paint 2000
#2 Bad Lighting 100
and Transpose into
House Broken Sinks Bad Paint Bad Lighting
#1 1000 2000 1000
#2 0 2000 100
A Pivot Table will do that and more.
Set House as row field, Defect as column field and How much as data.
HTH. Best wishes Harald
"vilfood" <vilfood@d...Outlook 2003 cuts off lines
I synchronize my PDA daily and as part of its software, Newsbreak, I can
send myself emails of interesting stories with URL links to look up online
later when I get home and connect. When I load them into Outlook 2003 and
send them to myself, very long URLs appear correct in the Outbox version of
the emails. When I end up receiving the emails back INTO Outlook, it cuts
off lines beyond a certain length, thereby rendering the URLs broken.
Now I can look in the Sent Items and click the good version of the URL but I
would really love to know how you keep Outlook 2003 from hatcheting...Microsoft Money 2003
When I try to print a chart or report, I get the
message "This program has caused a default, etc." and it
Can you give me some hints on how to correct this? Thanks
Is this all reports or a particular one? If it's only one, try resetting
the report. If that doesn't help, try it in a new file. If it does it in
multiple files, you may need to try updating your printer driver or removing
and reinstalling Money.
"Mary J" <email@example.com> wrote in message
> When I try to print a chart or re...Headers in Excel #3
Can you tell me if it's possible and if so, how I can
change the header cells, i.e. A B C D E ... etc?
no this is not possible. The best workaround you can achieve is:
- use row 1 as header
- goto cell A2 and to the menu 'Windows - Freeze Panes' to always show
- in 'Tools - Options - view' you can hide the row and column headers
"Andrea" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Can you tell ...Report Designer on Visual Studio 2005: Is it possible without 2003?
Do I have to install Visual Studio .NET 2003 to design new reports on CRM? I
can't publish them on CRM when I have only the Visual Studio 2005 installed
on my machine. When I install the SRS Designer, the Wizard tells me that I
do not have the Visual Studio 2003.
Thanks in advance!
You need VS to create report rdl file. Visual Studio 2005 should work. To
publish report you can log into CRM to upload your report file.
"Juliano" <email@example.com> wrote in message
> Do I have to install Visual Studio .NET 2...Pivot Table Axis format
I have a macro that creates a pivot-table and pivot
chart. The X-axis is a date. In the raw data, the date
is formated as month/day. This is the way I want it on
the chart. However, the X-axis formats with
month/day/year. How can I force this to display correctly?
Do you see a grey little dropdown under the X axis (where you can choose your
dates to show)?
If yes, then rightclick on it.
Select the top option: "Format pivotchart field"
then click on the Number button on the next dialog.
There are a bunch of date formats that you can choose from.
Maybe...Exchange 5.5 to 2003 Migration Question #3
We are currently migrating users to Exchange 2003 from 5.5. The 5.5 server
is located here and the new 2003 server is located in a different office.
One user (who we have moved already) is trying to access and user's
calendar, but that user is still on 5.5. They are getting the following
unable to display the folder. The information store could not be opened
Any ideas on how to make the user on 2003 (running Outlook 2003) connect to
the user's calendar on the 5.5 server?
The user has the "Owner" permission on the 5.5 calendar.
...Can't access comcast newsgroups in outlook express 6 or Outlook 2003
I had the comcast news server working in both aps, but trying to make it
work with outlook 2003 as the default program to access the newsgroup
reader, by removing the newsgroup account in outlook express 6, I now can't
get it to connect in either ap. duh...
It's completely gone from Outlook 2003, ie, where before, under the go
button there was a link to news, now there is not.
Outlook express 6 still has the newsgroup reader, that's how I'm sending
this, but when i try to go to the comcast news server it repeatedly asks for
username and password. I deleted the a...Automatic Generation of Campaign Response CRM4
Wondering if anyone can tell me if Email Router and Rule Deployment is
required for the automatic generation of campaign response to work in CRM4?
The e-mail router and rule deployment is one of the methods for e-mai
integration in CRM as described in the implementation guide:
....but it is not necessary to have the e-mail router installed to have
campaign responses automatically created and tracked in CRM as described here
in this blog:
http://blogs.msdn.c...Importing Outlook 2003 to Win 98 Outlook
I'm trying to import contacts from my office XP system running Outlook 2003
back to my home computer running Win 98 with Outlook, unsuccessfully. I've
also tried to install Outlook XP software onto Win 98 and while it appears
to be installed, there is no difference. Can anyone advise me on what to do?
Outlook 2003 pst-files cannot be opened in previous versions of Outlook.
You'll have to move them to an Outlook 97-2002 pst-file first. For detailed
Robert Sparnaaij [MVP-Outlook]
www.howto...Is this possible within Excel 2000?
Hi, I've used Excel on a get by basis for many years at work, and I'm just
beginning to realise its vast capabilities, having viewed several groups
which I didn't know existed previously.
I subsequently would like to ask if it is possible for Excel to look at the
numerical or text content of a cell on one worksheet and then look at a
predefined range on another worksheet and find the equivalent cell content
and then move the cursor to that cell? This has me stumped presently.
Thanks in advance for any assistance.
To actually move the selection, you'd need to use a litt...Excel -> Access Import Bizarreness
A guy gave me an Excel file that he needs me to covert to XML. No problem.
Slurp it into a database and use a DataSet.WriteXML() call to turn it into
an XML file.
But I can't import it into Access because it has "Merged Cells". For
example, data that should look like this:
The three "this" cells have been merged into one tall cell:
I need to "unmerge" these, but I know almost nothi...Excel 2000 fail to open workbook
I have one Excel template. If we open it on Excel 2000, the Excel will hang,
and the process occupy cpu 95% ~98%.
But we can open this tempalte in Excel 2003 normally, and if we save this
tempalte in Excel 2003, and then open it in Excel 2000, it work normally
Excel 2000 (9.0.3821 SR-1)
Excel 2003 (11.8231.8221) sp3
Would you help us to find the reason for this issue?
Perhaps there was some (probably minor) corruption/inconsistency in the workbook that Excel 2003 could fix but Excel 2000 couldn't.
[Microsoft MVP - Word]
...How can I create an invoicing database in Excel?
I would like to know how to create an invoicing database, or register in Excel.
(Invoice + tax = total) Are there any templates free online?
How about a web search?
search for invoice
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"Vcollins" <Vcollins@discussions.microsoft.com> wrote in message
>I would like to know how to create an invoicing database, or register in
&...Outlook 2003: export accounts settings
I need to transfer my Outlook 2003 to another PC, but I can't export the
Any information about how to do this would be greatly appreciated.
"Helder Costa" <firstname.lastname@example.org> wrote in message
> I need to transfer my Outlook 2003 to another PC, but I can't export the
> accounts settings.
> Any information about how to do this would be greatly appreciated.
> H Costa.
Go to Start-All Programs-Microsoft Office-Microsoft Office T...Excel prints some sheets very small
When I try to print multiple sheets of the same workbook at the same time,
one of them (a different one each time) prints very small (about an inch
tall) in the upper left hand corner. I am printing from a network file but I
don't know if this has anything to do with it or not. Please HELP!!!
...EXCEL 2007 acting up
j$ = "THIS MACRO WILL ERASE THE SECOND & THIRD SET OF DATA" + Chr$(13) +
Using EXCEL 2007, I get an error with the line above as a macro.
It does not recognize CHR$.
What am I doing wrong?
Not for me it didn't.
Check for MISSING references in Tools>References, uncheck them if there are
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"pcor" <email@example.com> wrote in message
> j$ = "THIS MACRO WILL...