disable snap-to while dragging tab stops?
How do I drag a tab stop to arbitrary position without it snapping to the
tick marks on the ruler?
I tried holding down shift, ctrl, alt. None of them works. I even turned off
everything in the arrange->snap menu.
Set the tab to about where you want it, zoom to 200%, open the tab dialog and input
the number where you want the tab positioned, click set. The tab button can be
dragged to your toolbar by customizing. This is the best that Publisher can do...
Mary Sauer MSFT MVP
"p...update a date cell only when worksheet is edited
Hi. is there a function that updates the date cell automatically only when
the worksheet is edited or something to that effect. thank you
This might help
Joe Black wrote:
> Hi. is there a function that updates the date cell automatically only when
> the worksheet is edited or something to that effect. thank you
I received a excel file, where there is "+" sign on the left. If I click it,
it expands and click it again collapses. What is that for?
Also I see "1", "2" on the top left. If i click "1" all the "+" expand and
if I click "2" all of them collapse.
What is the difference in these two formulas:
See "About using outlines" in XL Help.
The "+" in the first formula is superfluous. It's often used by Lotus
users who have switched to XL.
In article <4C95F8D7-03A9-4F48-A8DA-6F6A1F30A...master reformat cells to comma delimited format
I want to transfer info from an excel spreadsheet and need
to convert the large spreadsheet to a comma delimited
format. Thoughts? Thanks!
...Solving an equation in a cell
I have an excel spreadsheet that has a list of numbers
that are 55% of a total that is unknown. Is there a way
I can create a formula to figure out the total in a cell?
26 - 55% of total
My equation is:
..55 * x = 26
I need to solve for x.
Is there a way to solve this in a cell?
Answered in Worksheet forum. Please don't multipost.
"Mark" <email@example.com> wrote in message
> I have an excel spreadsheet that has a list of numbers
> that are 55% of a total that is unkn...Highlighting cell on value difference.
I currently have the text changing colour if the value is greater (green)
and (red) if the same or lower compared to the value in the previous cell.
But i would like to have the background cell change colour if the value is
10% +/- difference from the previous cell as well. This would be very useful
if any one could help.
Try something like
=ABS((A2-A1)/A1) > 0.10
> I currently have the text changing colour if the value is greater (green)
> and (red) if the same or lower compared to the value in the previous ...stops responding
A few days ago while trying to balance one of my accounts, Money would start
hanging and I had to kill the process and created a LRD file. My file is
only 12MB and it has been fine until recently. I am using Money 2007.
I should have put my system specs. I have a P4 3.8GHZ w/ 2GB RAM running XP
Pro. When I have Money open, I typically only have Messenger, a browser, and
sometimes Acroabat Reader running also.
> A few days ago while trying to balance one of my accounts, Money would start
> hanging and I had to kill the process and created a LRD file. ...Clear a range of cells given 2 Cell addresses
I want to be a able to clear a rectangular area.
I know the top most left corner address.
I know the bottom righ corner address.
all addresses are in the format r,c where r,c are integers.
So I know cell 1 to have coordinates (r1,c1) and cell 2 to have coordinates
How can I issue a clear command to clear all data and formulas in this region?
Thanks much in advance.
With kind regards,
"ekareem" <firstname.lastname@example.org> wrote in message
news:...Inseting data in cells
I have a row of cells that have last names in them, is there a way I can
insert some data into all of the cells, this data will be the same for
then if possible export all of the names to a word or text file all in
Thanks for any help!!!!
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Assuming last names are in A2:Z2
Put in A3 :...blue stop screen 0x0000007E
stop error code after windows installs drivers. this is new hdd and mobo but
problem persists.oxoooooo7e (oxf748eobf oxf78da2o8,oxf78d9fo8....was doing it
with last mobo and hdd...help please!!!
thanks one and all for your helping hands
> stop error code after windows installs drivers. this is new hdd and
> mobo but problem persists.oxoooooo7e (oxf748eobf
> oxf78da2o8,oxf78d9fo8....was doing it with last mobo and hdd...help
That *is* a driver issue. You are installing the incorrect drivers or need
to contact the manufacturer of said ...how to protect formulas in a cell
You have cell where values are entered, but it has a formula in it. How
can I protect the formula and still let the user enter data in it?
How do I RESET the table to its orginal state. Say all cells should be
set to "o" or "empty" and everything, formulas, formatting for the
entire table goes back to when first opened.
Please see Pic in attachement (having problems with my server uploading
the file). Pls let me know if get to see the pic, I am learning...
|Filename: ...recipient policy stopped working
I'm seeing an issue in my Exchange 2003 environment where an admin will
create a new account and the recipient policy does not populate the users
email address. This just started happening a few days ago here in the US...
It happened in our UK office last week but I thought that might have been
user error on the admin. We are in mixed mode with Exchange5.5, which we have
been for almost a year. I did how ever remove some old 5.5 servers but the
last one I removed was almost a month ago, so i don't think it would be that.
I know you need to ask this question so yes th...How do I stop a cc email to myself from going to deleted folder
Sometimes when I send an email, I want to keep a copy ofr myself. When I
enter my email address in the cc part, this always goes straight to the
deleted folder, even though I have my email listed as a safe sender. Any
On 13/03/2010 01:53, technochallenged wrote:
> Sometimes when I send an email, I want to keep a copy ofr myself.
Outlook automatically keeps a copy of every email you send in the Sent
There is no need to cc yourself.
"technochallenged" <email@example.com> wrote in
message news:D4...Count the Colorindex of a cell with a conditional format
Is there any way (with or without code) to count the number of cells that
have a condition that displays a specific colorindex tied to a conditional
I answered no to this once and Bob Philips corrected me and pointed me
towards his page below. You can count conditionally formatted cells but it
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
questio...3197: The microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time
I have a fairly large (For Access - its slated to be transferred to
MySQL) backend that allows the user to use the database's front end
normally to store and retrieve data. However when I try to open the
database I get the Error "The microsoft Jet Database Engine stopped
the process because you and another user are attempting to change the
same data at the same time".
This isn't true because I have it on my local computer.
I've tried importing to a new DB file and I get the same error. The
original DB will not open to allow import (show table list) and show
er...Stop all macros
I have a button on a form, which should do different things depending on
1. The data contained within the current record;
2. Whether the current record is a 'new record';
3. Whether the current record is the first record in the form.
On click, an embedded macro is initiated. Each step in the embedded macro
has a condition and a corresponding 'RunMacro' action.
All the conditions are mutually exclusive, and each sub-macro has a final
step of 'StopAllMacros'. So the embedded macro should trigger one, and only
However, it appears that what is act...How to omit certain cells in formula
If I have monthly data in a table, but data form April on is not
available yet, but I would like to be inputted automatically from some
other table when it becomes available there. So I put in the cell a
And as the source is empty so far- I get the result of the formula
But at the end of this line (that now includes data till March and for
the next 9 months there are 0) I have formula for average- which by
now also takes in to account the 0 in the line- which I do not want.
What would be the best way to tell the excel that: calculate average
in the lin...Stopping the scroll bar
Hi all, this is my first time. I don't know if this is the right place
for this problem but here I go. I have created a template of an
invoice the size of an A4 and would like to stop the scroll bar moving
both horizantally and vertically in normal view just as if it was in
print view. Is that possible through VBA and if yes what is the code
that I would need to achieve such task.
Thanks in advance
Message posted from http://www.ExcelForum.com/
Not too sure what you are after but you can remove the scrollbars with
<Tools - Options> and then in the View tab, at the bottom,...Data validation master cell
Is it possible to change what list is in a cell by selecting the name o
that list from a "master" cell?
For instance, say the master cell is A1, and it's validation lis
contains the list "cats, dogs, horses".
The list in B1 would be based on what list is selected in A1. Fo
instance, if A1 was set to "cats", then the choices in B1 would b
something like, "Calico, Tomcat, housecat, Siamese".
What I really want to do though, is only have one "master" cell an
have dependent cells that change depending on the master.
So, if A1 is the master,...Sending value to a cell
I want to dump a computed value into a cell that isn't the one the
calculation was done in. Can it be done from the original cell?
no, not with a formula
"CM32134" <CM32134@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi there,
> I want to dump a computed value into a cell that isn't the one the
> calculation was done in. Can it be done from the original cell?
A worksheet formula returns a value and can do nothing else.
Think...How to have multiple columns in excel that will expand and colaps.
I have a large about of tiered data, multiple columns, that I would like for
the users to be able to expand and colapse on by each column level to view
that level of data. Is there a method of doing this.
It's hard to understand what you are wanting from what you say. Provide
some detail about what the data looks like at the start, then what it looks
like after expanding and then what it looks like after collapsing. Don't
attach a file to your post. Just describe what you have and want. HTH
"columnhelp" <firstname.lastname@example.org> wrote in me...Cell names of merged cells
I have a two columns merged together. I have given each merged cell a name.
However, the name appears not only in the name box but also in the cell
itself. How do I get it not to show in the cell?
How did you name the cells?
Insert>Name>Define or Insert>Name>Create?
I find an easy way to create multiple cell names is to have a list of names
in Column A.
Now you can delete the data from column A.
The created names will remain.
Gord Dibben MS Excel MVP
On Wed, 14 Apr 2010 14:47:01 -0700, DLB <DLB@discus...PivotTable
I have a PivotTable with two columns - student names and tuition.
I highlighted the **grand total tuition** with fill color. Please note that
only ONE cell had this format.
However, when I changed the column of student names to a row of student
names (by moving the "button"), all the tuition (and not just the grand
total) had the fill color. Is this a bug? Is there a way to get around
this? I know I can remove the fill color first, change from column to row
then put back the fill color. Just wondering if there is a better way.
...Stopping a Campaign Temporarily
My client has executed the campaign in Jan 1st 2006 and the end date is Dec
31st 2006. But he wants to stop the campaign temporarily from 15th July 2006
and again start it from 1st Aug 2006.
So what is that I need to do for this thing, i have never come across this
kind of situation before.
Thanks in advance.
...Looking up the rounded value in a cell, not linking to the value.
What function will look up the rounded value appearing in a cell, rather
than the value including all digits of precision.
Suppose cell A31 has this value in it: 34.23942498747
And the value is rounded in that cell to 2 digits: 34.24
What function can I enter in cell A2 to reference the value in cell A31 and
display its rounding value in A2?
This seems like an Excel 1.0 question but I do not know the answer.
On Sun, 30 Nov 2003 20:51:39 -0500, "John Wirt" <email@example.com> wrote:
>What function will look up the rounded valu...