How do I get the From line to appear in the message header?
Our home laptop has two e-mail addresses and I want the Sender or 'from' line
to show above the 'To' line in the message header. This is so I can pick
which sender is sending the e-mail (myself or the other user). I went to
View/Message Header but it only has Bcc. Can anyone help? It is Microsoft
Outlook 200 SR-1
To show the "From" field in your email message, follow the appropriate steps below.
If you are using the Microsoft Outlook e-mail editor
On the View menu, click From Field.
If you are using Microsoft Word as your e-mail editor
...total number of characters in a cell
Is there a function that can count the total number of characters in a cell?
The LEN function will return the total number of characters in a
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"plumstone" <email@example.com> wrote in
> Is there a function that can count the total number of
characters in a cell?
Note that this includes space and other non-printing characters.
In article ...Remove GUID in email Subject Line in v1.2
How do I remove the GUID in the subject line of emails in v1.2?
I see this KB at MS
http://support.microsoft.com/default.aspx?scid=kb;en-us;829459 but it
references CRM 1.0 only and the date of my Crmemaildispatch.dll file is
later than the one in their hotfix.
Can anyone give me some pointers?
Follow those guidelines for setting the registry setting indicated. The
hook to look for this is in the 1.2 dll already.
MVP - Microsoft CRM
"Stewart Arnold" <stewartarnold@DELETEIT.yahoo.com> wrote in message
How do I remov...how do I create custom line patterns in Visio?
I have just begun using Visio as diagrammatic tool, but I cannot seem to get
customised line patterns to work for dynamic connector.
...Cells get automatically converted
I want to store installment details of employees in the format: 9/15,
10/15 etc.. These are text values and are transferred via .NET
application to Excel. But it considers it a date and so converts 9/15
to 15-Sep, 10/15 to 15-Oct. I even searched for options to disable
this, but could not find it. Please help switching this off.
In message firstname.lastname@example.org,
RP <email@example.com> Proclaimed from the tallest tower:
> I want to store installment details of employees in the format: 9/15,
> 10/15 etc.. These are text values and are transferre...Grouping like coloured cells
I have a conditional format set up to change cells different colours
when certain conditions are met. I want to be able now to set up a
separate table with all the same coloured cells in. I'm sure this is
possible, however, I also want to be able to copy the row title into a
section of the new table. Is there a way to do this?
I have just changed the format of the chart. All I need to do now is
form three seperate charts of positives, negatives and neutrals,
however, they still need to be linked to the original row title.
...Insert Worksheet Name into a cell
I've been trying in vain to solve this problem.
I work with multiple worksheets and part of my title has th
worksheet's name. Right now, for each title, i edit the title
Is there any function like the = cell("filename") that extracts th
filename that can work on extracting the sheet name instead.?
Thanks in advance.
Message posted from http://www.ExcelForum.com
Provided the workbook has been saved, you could use
"Pr...Format all cells containing formulas
I'd like all cells which contain calculated values to show up in
different color (or some other formatting change). I know I can toggl
formula fields to be visible and manually update each one individually
but I'd ideally like something that automatically formats new formul
cells (and even applies to new .XLSs and worksheets). Seems like a
obvious thing to want to do, but haven't found this anywhere in th
A usable fallback option would be a macro to search the worksheet an
apply (eg) Red Bold to every cell containing a formula.
Message posted fr...use command button to total datas in cells through VBA codes in ex
how can i establish a new command button in combo box to total datas in cells
by wrinting VBA codes ??
thanks you !
...Line graphs with many lines
I am trying to figure out how to make a graph where I can have toe population
as the y axis and the date as the x axis. The lines I want series a to be
"2004" and b to be "2005". Anyone got any ideas?
In A1 enter the text Date and in cells below enter the date values; in C1
enter the text Series A values and the values below; likewise in column C
enter the Series B values.
Lets say there are 10 values; select A1:C11 and click the chart wizard.
Specify an XY type chart.
Bernard V Liengme
remove caps from email
"...Drop Down Boxes for Validation Cells are Too Wide
For some reason, in some columns of my spreadsheet the validation drop
down boxes are too wide for the cell. In column A, for example, they
will be the width of the cell plus the dropdown arrow - perfect. In
column C they will exceed the width of the cell plus the drop down
How do I fix this?
Extra wide dropdown lists appear occasionally, usually if cells on the
worksheet have been merged (not necessarily the cell with the data
To get rid of them, you may have to delete the row or column and
recreate the data validation.
> For some reason, in some...Combined charts
"How do I change the format of a data series in a chart from a line to a column?"
On Fri, 7 Nov 2003 06:26:10 -0800, Kurt Bonner =
> "How do I change the format of a data series in a chart from a line to=
Select the data series by clicking on it. On the menu, click Chart | =
Chart type | select a column chart. If you do this as instructed (i.e. =
with the data series selected), only the selected data series will =
change. The other data series will remain as before.
dvt at psu do...Multi-value paramter syntax...help
How do I write the syntax for a stored procedure that has one parameter but
accepts multiple values. I am running a report from reporting services that
can pass multiple values or pass all values to the stored procedure
stored procedure 1: exec getcolor @color = blue....this runs fine.
stored procedure 2: exec getcolors @colors in('red', 'white',
create procedure getcolors @colors nvarchar (50)
where color in(@colors)
need help making this work.
thanks in advance
O...More multi threading advice needed!
Need more help with this.
I have an array of objects (Computer class).
The class has a method that takes a while to run and I want it to run in
it's own thread.
So I have code like this:
Private ProcessResultHandler As AsyncCallback = AddressOf ProcessResults
For i = 0 To ComputerArray.GetUpperBound(0)
sfh = AddressOf ComputerArray(i).UninstallAgent
Public Sub ProcessResults(ByVal ar as IAsyncResult)
Now, I need to know from within ProcessResult...protecting cells (Excel 2000)
How do I prevent certain cells from being altered, allowing
users to enter data only in certain areas.
I can only see how to protect an entire sheet or workbook.
first select the cells for which you want allow entries. Goto Format -
Cells - Protection and uncheck 'Locked'. Now protect the sheet
"David Kinston" <firstname.lastname@example.org> schrieb im Newsbeitrag
> How do I prevent certain cells from being altered, allowing
> users to enter data only in cert...NA in Line chart plotting as zero
I'm using Excel 2007 and the line charts with NA are plotting as zero. I
suspect there's a setting I need to change, but I just can't find it. Can
In xl2007 you can select the chart then use right-click Select Data. There's
a hidden/empty cells button.
Or via the ribbon, Chart Tools > Design > Data > Select Data
Andy Pope, Microsoft MVP - Excel
"Barb Reinhardt" <BarbReinhardt@discussions.microsoft.com> wrote in message
news:A9F7F651-153C-4DC1-B415-D37969...cell color #4
is it possible to auto change cell color depending whether there is a yes or
no in the cell...i want to make the cell turn red when i enter yes
read about Conditional Formatting
=LEFT(A1)="y" or if spelled out
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"kd" <email@example.com> wrote in messa...moving cells to new sheets
I am trying to tidy up a fairly large and complex workbook
that is all (quite confusingly) kept on one sheet.
Is there any way to move cells to other worksheets and
have them hold on to their original reference from the
e.g. easily copy cell from Sheet 1 with say, (=R1/2) to
Sheet2 so it now has the formula (='Sheet1'!R1/2)
Try: Cut (from Sheet 1) > Paste (in Sheet 2)
D Abramovich <firstname.lastname@example.org> wrote in message
> I am trying to tidy up a fairly large and complex workbook
...Adding Formula to Cell with Data
Column A has hard coded data. I need to add to the hard coded data figure
another cell. I do not want to insert a new column or change the format of
my worksheet. How can this be done without manually adjusting each cell?
> Column A has hard coded data. I need to add to the hard coded data figure
> another cell. I do not want to insert a new column or change the format of
> my worksheet. How can this be done without manually adjusting each cell?
What type of data in the cells?
If numbers and you want ...Cell Character Display Limit
I have numerous cells with over 3500 characters in them. In one case, only
about 2000 characters are displayed. Is there some way to get all the
characters to display. Must I format the cells a specific way?
Place ALT+Enter periodically in the text, say every hundred characters
Barb Reinhardt wrote:
> I have numerous cells with over 3500 characters in them. In one case, only
> about 2000 characters are displayed. Is there some way to get all the
> characters to display. Must I format the cells a specific way?
> Bar...Anchoring cells
I have a spreadsheet I am working on where I have 4 columns of
demographic information followed by 12 columns for their status during
specific months. I would like to anchor the 4 columns and then be able
to go the month in question. I want to be able to see the demo
information next to the cell for that person and that month. HOw?
Xcel 2004 for Mac if you need the information.
Thanks for any help.
I want to find a voracious, small-minded predator
and name it after the IRS.
Robert Bakker, paleontologist
Place your cursor in cell E2>Windows>Freeze Panes
This w...Extract data from a cell after a constant value
I have a spreadsheet that contains 1 column of data, if the cells of the
column are the city names and populations of towns in the following format:
Appleton, Wisconsin (WI) (pop. 70,087)
The 'pop.' is always present.
I want to extract just the population number (ie: 70,087) from these cells
into another cell.
What is the simplest way to accomplish this?
On Sun, 19 Aug 2007 12:29:37 -0500, "Wolfman" <email@example.com> wrote:
>I have a spreadsheet that contains 1 column of data, if the cells of the
>...linking cells from different files -fill down
I'm trying to fill the same formula (links) down a column on
I'm linking from the same cell from a months worth of files,only th
file reference is changing as shown below.(11-1-05,11-2-05,etc..)
singlgl1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2638
...Line Drawing Between Separated Data Points ?
Have a chart made from a table that has bolood pressure readings as a
function of dates.
Some dates are skipped.
The chart generated now connects a line between all the dates points that
are there, sequentially,
irrespective of whether there are points for all the (daily) dates.
Is it possible for the generated chart to have the line missing for dates
for which there is no data, and then to resume connecting the dots between
actual data ponts ?
Graph looks funny for data points connected for each day, which is what I
want of course, and then a line connecting two points perhap...how can i susbstitute the symboals like '-' or��#�� in the cell?
till now ,the excel only support substitute the text in the cell,as we can
use SUBSTITUE function.
But if i want to substitue the symboals like ��-�� or��#'��how can i do?
On Thu, 13 Dec 2007 09:12:47 +0800, "Sebation" <firstname.lastname@example.org> wrote:
>till now ,the excel only support substitute the text in the cell,as we can
>use SUBSTITUE function.
>But if i want to substitue the symboals like ��-�� or��#'��how can i do?
What was wrong with using the SUBSTITUTE function?