Highlighted word wont DEL when I use Bakspc only in office/word
When I highlight a word in and hit the Backspace key it will not delete the
word, this is only in outlook and word , however I can delete using the
backspace key using one key stroke at a time.
In Tools > Options > Edit, check "Typing replaces selection". (In Word 2007
this option is at Office button > Word Options > Advanced.)
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
backspace key not working correctly wrote:
> When I ...conditional formatting sort
Is there a way to sort after conditional formatting. So, if I've set up a
conditional format to color my text red if the number is between 0 and 95,
then I want to sort so all red numbers are at the top of the spreadsheet?
Thanks for your time and assistance.
On Thu, 25 Oct 2007 05:08:00 -0700, rrupp
You can't sort by color, but you can add a column to your query like
SortColumn: Iif(SomeValue >= 0 and SomeValue <= 95, 1, 2)
Then sort by this column.
>Is there a way to sort after condition...How2 set Defaults for Paragraphs in Pub2003
I have just upgraded to Pub2003. My old Pub2000 had no such feature. My
problem is when I cut and paste into the new Pub2003 it automaticly uses a
Line Spacing default "After Paragraphs: 9pt" - this whacks out all my old
logos and forms when they are copy/pasted in to a new Pub2003 .pub
If I open an old (2k) .pub file with Pub2003 the spacing is fine - if
figures out the Line Spacing is "After Paragraphs: 0pt"
...Formula without using numbers after decimal in the answer
I have a formula that derives the answer from a figure with a decimal. I
don't want to use the figures after the decimal. Is there a way to just use
the whole number and omit the numbers after the decimal without having to
manually key in all these numbers manually?
You can use the INT function. This 'rounds down' any number to th
nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) return
swatsp0p's Profile: http://www.excelforum.com/member.php?...Using Relative path for XML data file?
Is there a way to specify a relative path to an XML data file imported into
Excel 2003? I am writing a web app that generates report data as XML for the
user to download to their local machine. This data is to be consumed by an
Excel reporting spreadsheet, which contains display-formatted tables and
charts that are mapped to various data fields in an XML Map, which is in turn
linked to the xml data file they will download.
The idea is the user only needs to download the data for updates, not the
whole spreadsheet. However, since I cannot predict the path where the user
will store their...Setting a dynamic range in a formula
I have a column of numbers and I always want the following arra
formula to use the last 12 entries:
Phillycheese5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2419
View this thread: http://www.excelforum.com/showthread.php?threadid=37809
Assuming that Column D contains no blanks, try...
...confirmed with CONTROL+SHIFT+ENTER.
Hope th...Disable Secure Sockets Layer on exchange server when using RPC over HTTP
Hi im trying to enable RPC over HTTP to enable users to establish contact to
my Excahger server 2003 over the internet.
Now, I dont want to use SSL (security not that important) and i am told by
this article that i can disable SSL in windows registry.
Note While RPC over HTTP does not require Secure Sockets Layer, you must
modify the registry to enable RPC over HTTP if you do not want to use Secure
Sockets Layer. Microsoft recommends that you enable and require Secure
Sockets Layer for your RPC over HTTP communications.
At this address: http://support.microsoft.com/?id=833401
But i ...Is anyone an expert with outlook that I can call on the phone?
How do I share calenders between outlook and my MSN Premier account?
Assuming you are using the outlook connector, you need to set the msn
account to be the default message store then outlook will use the msn
calendar as the default.
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:
You can access this...using the journal on outlook
Once I link an email to the journal, can I still find that email in my mail
box? I seem to be able to get to it only via the journal. If this is the way
it is supposed to be, how do I remove it from the journal and get it back
into my mail box? Am I just missing something?
Are you linking to the item or putting a copy into the journal item? Also,
has the item been archived or not?
"Independent" <Independent@discussions.microsoft.com> wrote in message
> Once I link an email to the journ...Document Template question
It's legal for a document to have multiple views into it's data, but when
CMultiDocTemplate is created, it is only passed one runtime view class. How
are multiple views handled in the document template context? Should all
views of your document be derived from the class passed to
CMultiDocTemplate? This is confusing me because MDI AppWizard did the work
of setting up a document view class for me, but now I'm just using a child
window with an imbedded static splitter window to show two different views
of my document, and these views have nothing to do with CMyProjectView that...How to delete a set of rows depending on Value
I have two worksheets
I need Worksheet A to look at each cell in Worksheet B, if a cell exists in
Worksheet A, then I need the row deleted...
Basically I have a list of Grand list of items to do, then a list of items
already completed. I need to now remove all entries in the grand list that
have been completed.
Is this feasible or should I look at using some Unix script.
It sounds like you could use VLOOKUP to find out if the value in B exists on
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel....Let me use the Line Color icon on charts
It would speed up a lot of my work if I could use the Line Color icon on
Excel charts, the same way I am able to use the Fill Color and Font Color
However, when I highlight any chart object, like the Plot Area, Chart Area,
or a Series, the Line Color icon is disabled.
Stuart Bratesman, Jr., MPP
Muskie School of Public Service
Univ. of Southern Maine
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 ...Terminal Server and GP Settings
Not being a Windows Terminal Server expert by any definition, I have a
question for somebody who is.
When wanting to have a user profile to store individual dex.ini files, my
understanding is that each user would have his own Windows folder under their
user folder. Additionally, if you typed SET at a command prompt, the settings
for WINDIR would point to that user-specific Windows folder. Is this thinking
Charles Allen, MVP
I think you also have to make certain that the dex.ini does NOT exist in the
program install location for GP or it will still look to that.
Dwight...Fixing a formula to read a general format?
A few months ago I had asked a question and got this answer:
I have a a set of values in A1 through A100.
I need to look up each value and find a match in
another set of values located in C1 through C200. If a match is found then I
need the formula located
in column B to return the value in the same row but
the next column over (D).
Copy down through A100.
The formula worked fine, however the reference value and the look up value
are not any more numbers but a combinatio...How to set "licence" for Access 2007 database?
I developed an Access 2007 db to a client. Now I want to make a year
based licence for that database that the client must pay if they want
to continue using the database after year. It must be so that database
cannot be used after this date. How I can accomplish this? Thanks!
On Mon, 12 Apr 2010 13:14:17 -0700 (PDT), Sandroid
>I developed an Access 2007 db to a client. Now I want to make a year
>based licence for that database that the client must pay if they want
>to continue using the database after year. It mu...Does Outlook use the DAV protocol?
I'm an Outlook Express user who wants to switch to Outlook. I received a
notice from Microsoft that includes the following: "... as of June 30, 2008,
Microsoft is disabling the DAV protocol and you will no longer be able to
access your Hotmail Inbox via Outlook Express."
Please tell me if this action by Microsoft will affect Outlook in the same
manner, or am I free to make the switch.
"BudV" <BudVitoff@(NO)att.(SPAM)net> wrote in message
> I'm an Outlook Express user who wants to switch to Outlook...Can't do adjustment in analytical accounting
I am trying to change an analytical assignmnet through the Edit
Analysis. When I try and change it, I receive an error stating "The
Code of this Transaction Dimension cannot be adjusted". Has anyone
seen this before? I have done similar changes many times, but I don't
know why I can't now. Any insight would be helpful.
What version of Gp are you running? I haveseen this happen in 8 but one of
the service packs fixed it. (I think it was SP 4 or 5)
> I am trying to change an analytical assignmnet through the Edit
>...number format with leading 0
Dose anyone know how to create a number format that would show a leading zero
for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
text format but would like to retain the integrity of the number.
Does that help?
> Dose anyone know how to create a number format that would show a leading zero
> for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
> text format but would like to retain the integrity...Can I share entities in migration process?
The entities in CRM have only one owning user. If I want=20
who a user see a entity of another user, the entity must=20
be shared with this user.=20
Well, I want migrate entities who must be shared with some=20
users. Exists a way to do it?
Thank you for pay attention and sorry my bad english.
Vin=EDcius Pitta Lima de Ara=FAjo
...How can I create Schedule Chart?
I have simply an activity list which shows START and FINISH date of
related activity. I need to put this information into a Chart, so
i will get a bar chart highligting the line between the START and
FINISH date of the activity.
It is very similar to what we can create in Microsoft Project.
Do you know a specific chart type for this?
It's called a Gantt chart:
"mezzanine1974" <firstname.lastname@example.org>...Can validation lists be enlarged
When a validtion list is created can this be enlarged in a spreadsheet which
has been reduced to view.
for a workaround see:
"AC" <AC@discussions.microsoft.com> schrieb im Newsbeitrag
> When a validtion list is created can this be enlarged in a
> has been reduced to view.
...can't open new worksheets in a separate window
I've been trying to open multiple wookbooks in Excel, but they won't open in
a new window. Instead they continue to open in the same window - one on top
of the other. I've tried playing around with the maximize and restore, but
to no avail. I tried right clicking on the Excel button in the taskbar to
cascade the windows, but the pop-up menu is inactive. any advice would be
Running Excel 2003, Windows XP.
This might be it:
Tools - Options - View tab - Show: Windows in taskbar.
"3R's" <3R's@di...How can I change text to proper text in multiple cells.
I need to change names that are all in caps to proper case in 100 cells.
If I click each one individually, it works, but I need to be able to perfomr
this funcion automatically on all the cells. One other post said to be sure
calc is set to automatic and mine is. Any instruction is most appreciated.
Insert a helper column to the right of the column with the names.
Then use a formula like:
and drag down that column
Then select that column
select the original range
And then delete the helper column.
> I...Remote humans can't get email addressed to them from within the do
I call them remote humans because they are not "users" set up on the SBS2003
system. I've set up a local domain, call it domain.local, and the email
domain is domain.org. For all internal users, there is no problem. But
there are two people, out of state, with email addresses email@example.com and
firstname.lastname@example.org. Our email is hosted, and we use the POP3 connector to
bring it into our Exchange server. We do not use POP3 connector for the
remote humans - their Outlook client has the POP3 account set up on it.
These remotes will never connect to the local domain, all th...Formating text in cells
Hello, does anyone know how to force Excel to keep the hyphen or dash
character (-) with the associated numbers when putting multiple dash-#s in a
cell and turning "wrap" formating on? This is the same problem I have in
Word; when I add dash-#s (ie; -xxx, -yyy, -zzz) Office apps interpret dashes
( - ) as a hypehen to a word and will keep the dash/hyphen on the line above
until there are enough characters to force the dash/hyphen to the next line.
In my work we use the format; -xxx, -yyy, -zzz to denote multiple versions of
the same base part. Work instructions to operators...