how to paste formula and retain all or part of the cell references
I have following kind of problem:
I want copy a cell from A5 to B5.
In A5 I have a formula that takes values from A2 and E5, i.e. "=A2/E5".
In the pasted cell the formula changes to corresponding values: "=B2/F5".
In some cases this might be what I want, but in current situation I would
like to change only column to corresponding - I would liket the resulting
cell to include formula: "=B2/E5".
How can I do this?
Of course, in case of such simple formula it wouldn't be a problem but if I
have very long formula with lots of references, it's a nightmare..
A..."Show Placeholders" in options/view menu does'nt work.
I have a macro that places a large number of pictures on a spreadsheet. I would like the pictures to show as "placeholders" to speed up viewing/editing. The only problem is that this feature (under Tools/Options/View) does not work. All the images are being display normally. I have tried this in Excel 2000/2003/XP with the same result. This feature works great in MS Word. Please help.
To see what I'm talking about. Go to Tools/Options/View and check the "Show Placeholders" option. Now insert a picture or clipart. The image will be displayed normally instead of just a b...Show which cell has MAX, MIN values?
At the bottom of a couple thousand rows of data, I have =MAX and =MIN
formulas. Is there some way I could make the cells beneath my MAX and MIN
formulas show me the address of which cell has the displayed MAX or MIN
value? At least the row number?
To return the row
=MATCH(cell with Max or Min value,range starting in row 1,false)
or to return the address, say, in Cell N3000, for a value given in N2999
or to return other matching information, like a name in column A
MS E...Show email address instead of contact name
How can I make Outlook 2000 show the typed email address instead of
resolving to the contact name in printouts of the contacts list and in the
address boxes of email ?
For example, I have a list of contacts in a custom list view with the email
fields showing. Several of the entries in the email fields have resolved to
the name of the contact. I want to see their email address not their name
Also, a second example. I have three email addresses for a person, in the
Email1, Email2, and Email3 fields. I go to send an email and instead of
selecting the default from the addressbook/contact ...require cell completion in a form?
I have a very simple form in Excel. I'm not sure if it matters, but
the machine I'm on uses Excel 2002, and most of the users are on Excel
2000. The first 2 questions on my form require that the user select
from a list of names, and then select their relationship to that
person. Then the users answer a series of questions about this
person's job performance.
I'm using data validation to manage the two drop-down lists - the
names and the relationships. However, about a third of my users end
up leaving one or both of these cells blank. I have a comment box set
up as a remin...Average range of discontinuous cells
I have a block of columns (P-CT) that I need to average but only every 4th
Example: I need to average P, T, X, AB, AF, AJ, AN, AR, AV, AZ, BD, BH, BL,
BP, BT, BX, CB, CF, CJ, CN, CR. If I just type =AVERAGE(selecting these
cells) it gives me 40238 when the only one with a value is cell P. These
cells contain dates if anything. They are payment dates. I need the average
number of dates it took to pay something. Any ideas for Excel 2003? Thanks.
Never mind. I forgot to include my beginning date. It works. Just user
> ...I cannot get "Send" to show up in Toolbar
I think I'm set up for Outlook use, but there is no "Send" button. ?? Iuse
Outlook all the time at work--I'm just rying to set it up at home.
> I think I'm set up for Outlook use, but there is no "Send" button. ??
> Iuse Outlook all the time at work--I'm just rying to set it up at home.
Have you set up an email account?
Interim Systems and Management Accounting
> vincem wrote:
> > I think I'm set up for Outlook use, but there is no &...how to only show first 20 words of a memo field
I have a memo field on a form, how can i show the first 30 characters and
add 3 periods after the first 30 words.
Message posted via AccessMonster.com
Use the Left function and add 3 periods:
Left(string, length) & "..."
"sheniece via AccessMonster.com" wrote:
> I have a memo field on a form, how can i show the first 30 characters and
> add 3 periods after the first 30 words.
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums...Last cell with data in a range
I enter weekly data into a spreadsheet with a summary page at the front.
After every week, when new data is entered, I want the formula at the front
to use the cell with the new data instead of me having to change the existing
For example, my data looks like this:
A B C
I need a formula that will automatically detect the last number >0 in column
Thank you for your assistance!
so your main page formula might be something like:
=...Printing from a Master page
I am trying to print a document and the text area is overprinted in black.
Anyone know how to correct that?
Might think about a printer driver update. Is this only happening on one
publication? What version Publisher? Not sure I understand what is happening.
Mary Sauer MSFT MVP
"sherlynn" <sherLynn@discussions.microsoft.com> wrote in message
>I am trying to print a document and the text area is overprinted in black.
> Anyone...deleting pages in publisher 2002
When deleting p.5 (or any page) of my 19 page document, last page deletes
instead! What's happening here? How can I delete my page? I'm using "edit"
delete page. Also, I am not in Master Page mode.
On Thu, 23 Feb 2006 22:39:35 +0000, KLeDrew wrote
(in article <CA87F080-CAF5-4A38-956C-FDF8896CA92A@microsoft.com>):
> When deleting p.5 (or any page) of my 19 page document, last page deletes
> instead! What's happening here? How can I delete my page? I'm using "edit"
> delete page. Also, I am not in Master Page mode.
> ...display cell value in msgbox formatted as %
I have been trying to come up with a way to display a cell value in a
msgbox so that it formats properly as a percent.
I have tried:
Productivity = Format(Range("A1").Value, "###,# %")
This always gives me a leading 0 (e.g 015%) and I want it to display
So I tried this:
Productivity = Format(CStr(Range("A1").Value) * 100, "#,###.0") & "%"
and it works ok but...
I want to use the value of productivity in computations - which I can't
formatted as a string ... Am I missing something - or is it as simple...Can multiple cell results be displayed in a single cell?
Is it possible to display the contents of multiple separate cells in another
If the results of several cells say B1, B2, and B3 are the amounts $10, $15
and $20, I would like to display them in cell A1 as follows:
I could do this statically by using text and the 'Alt|Enter' function within
the cell. However, these amounts will change from time to time so I'd like a
Is this possible or not?
Thanks for any help.
="$"&B1&CHAR(10)&"$"&B2&CHAR(10)&"$"&B3&am...Using color to ignore cells in a formula?????
Is it possible to set up a formula in excel to ingore certain cells if you
should change the color of that cell to a color.
if cell A25 was blue how can I ignore it so that it is not calculated?
only with VBA. See:
"Mike A." <MikeA@discussions.microsoft.com> schrieb im Newsbeitrag
> Is it possible to set up a formula in excel to ingore cer...in what order should i place multiple brochure pages?
i am wondering in what order should i lay out my pages in my brochure so it
will print correctly . . .
I would use one of the brochure templates, create, print it out and edit to
"critic" <email@example.com> wrote in message
>i am wondering in what order should i lay out my pages in my brochure so it
> will print correctly . . .
...Excel macros page breaks but not on row 1 and column value in footer
Hi, I have seen some posts that are similar, but no one seems to have
the problem that I am having. I will post my macro in this, for anyone
that is interested.
My users get a csv file every month, and we have to clean it up. This
macro does that.
My last issues are this:
1) having the spreadsheet create page breaks whenever the value in
column B changes. Below is just that code.
col = 2
LastRw = ActiveSheet.UsedRange.Rows.Count
For X = 2 To LastRw
If Cells(X, col) <> Cells(X - 1, col) And Cells(X, col) <> Range("B1")
ActiveWindow.SelectedSheets.HPageBreaks...Showing intenet headers on recieved mail
How? I can see how to do it in OE but not Outlook....
"Paul Williams" <paulfoel@nospam_hotmail.com> wrote in message
> How? I can see how to do it in OE but not Outlook....
...Excel: When printing some cells will not print text in them
Operating System: Mac OS X 10.5 (Leopard)
When I print an Excel 08 spread sheet, two of the cells that have text in them will not print the text in the cell. All the other cells with text prints fine. The text does not even show up on print preview in the print dialogue box.
Any suggestions on how to get it to include the text in these two cells?
...Country not showing up on POS screen
We process many international orders through online channels.
When we put the work order into POS, the country doesn't show up on the POS
It is kinda hard to type the customers address into the USPS mail program
without the country.
Please tell me there is something we can do that will make the country show
up on the screen so we do not have to add several steps to our processing to
(If Z-FIRM's Endicia add-in did International, this would not be an issue.)
you can use the CAPTION FIELDS in CUSTOMER. This information will be
displayed in your HTML B...Connecting Cell with Lines
I have seen MSExcel printouts that have dotted or solid lines of different
colors connecting different cells in a sheet. Is that something that can be
done in MSExcel or would they have been added outside of MSExcel? If it can
be done in MSExcel, how?
In article <QbYYg.13615$GR.firstname.lastname@example.org>, "jerry" <email@example.com> wrote:
>I have seen MSExcel printouts that have dotted or solid lines of different
>colors connecting different cells in a sheet. Is that something that can be
>done in MSExcel or would they have been added outside of...Publisher should allow the deletion of multiple pages
I wish publisher would allow for the deletion of muliple pages much like the
options available when printing pages.
lejianzhong <firstname.lastname@example.org> was very recently
heard to utter:
> I wish publisher would allow for the deletion of muliple pages much
> like the options available when printing pages.
Suggestion: Try here:
How to Contact the Microsoft Wish Program
Ed Bennett - MVP Microsoft Publisher
...Appending data in cells that utilize a Dropdown list.
I would like to append entries in cells that utilize a dropdown list.
Currently, when I select (in this case names) from my dropdown list I cannot
append them if I want to add more than one to a cell. If I select another
name from the dropdown, it erases the first entry. Is there some way to
append entries within cells that use this form of validation so that I can
enter more than one in a cell from the dd list?
Office XP Professional
Debra Dalgleish has an example workbook showing how to do this
http://www.contextures.com/excelfiles.html...Worksheet Change Event log for multiple cells
I have a spreadsheet that is available here:
(although I scanned it for viruses please make sure you do it again prior to
opening it as I cannot guarantee it's worm free).
I would like to create a log file in an additional sheet (hidden probably)
that would record every activity from column E after clicking a button
assigned to a cell in that column and show these records in a worksheet
Totals in a specific row.
For example: Column A from a worksheet „Totals” corresponds with column A in ...Pivot Table: showing data as % of subtotal
I have pivot table data in this format:
Name Type Amount
ABC 1 $100
ABC Total $1,000
DEF 1 $150
DEF Total $1,140
and so on
I want to see the data as follows:
Name Type Amount %
ABC...mail box rights it only shows "SELF"
Once the user has been created, checking the Email address tab show nothing
(empty), I pointing rus to the right DC, this solve that problem, but i have
still have the next problem:
under the mail box rights it only shows "SELF" where as all
the other account show 8 or more system users?
On Tue, 21 Feb 2006 13:10:27 -0800, "Marco"
>Once the user has been created, checking the Email address tab show nothing
>(empty), I pointing rus to the right DC, this solve that problem, but i have