Adding static character to a cell
I want to insert a $ in column of cells. Use currency as the format, but I
want the $ to stay in the cell so it can be used also when printed out. I
hope that's clear?
The $ in a currency format should also get printed. It is a view of the
data, but consistent on screen and print.
(remove nothere from the email address if mailing direct)
"Frank" <stratster68@IHATESPAMworldnet.att.net> wrote in message
> I want to insert a $ in column of cells. Use currency as the format, but I
>...How to link cell for value in another cell of pivot table?
In Excel 2003, when I link a cell in pivot table, it copies Getpivotdata
And when I drag or copy this cell, again it copies the formular.
Can you help how to just get the value, then be able to drag to link next
cell and its value?
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:
> In Excel 2003, when I link a cell in pivot table, it copies Getpivotdata
> And when I drag or copy this cell, again it copies th...cell to change colour at given date
I have a cell in a spreadsheet into which I type a date. When the pc clock
shows that the date in the cell is more that 30 days old I want the cell to
turn red. How would I do that.
Basic to many of you I am sure, but to someone who doesn't use this side of
Excel, virtually impossible ! (I'm using Excel 97 if that makes any
difference - but I presume not)
Thanks in advance
LOL - My pleasure. Glad you got sorted, and thanks for the feedback.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP...Two conctact lists
In setting up a new computer, I had to install the personal folders because
the first was wrong. Everything is OK now, except that there are 2 contact
lsts, one of which is empty. Now the contact screen itself is fine - I'm
referreing to the one when I am addressing an email. The blank concact list
comes up first, and then I have to click on the down arrow to get theone
that actually has the names in it. How do I get rid of that blank one? Is
there a file name for it or something?
I've had this problem before and it can be a real pain. There mgiht be a
better way to f...Cell Data to Reflect Active Cell
Help - I'm struggling! Is it possible to switch the data in a particular
cell to reflect the active cell as and when I move through a range in my
A1 = Apples
A2 = Pears
A3 = Oranges
A4 = Lemons
and my active cell is A1 then I would like B5 to = Apples. If I move focus
so that the Active cell is now A3 I then I would like B5 to = Oranges and so
Thanks in advance, Peter
"Peter Davies" <email@example.com> wrote in
> Help - I'm struggling! Is it possible to switch the...Updating links
In one of our office spreadsheets, everytime it is opened it asks do you
want to update cells from another spreadsheet. I believe when this
spreadsheet was set up, a work sheet was copied from another spreadsheet. I
thought that all the references to that other spreadsheet had been removed.
Is there anyway to identify (other than manually checking each cell) which
cell has a formula linked to the old spreadsheet.
Thanks in advance,
Download and install Bill Manville's FindLink add-in, which you can find
In article <bYd1d.27315$Z14.90...How would I fill blank cells with the data from a previous cell?
Need to fill blank cells in a column with the data from the previous
non-blank cell in Excel 2000. Used to do this in Lotus. Can't seem to get it
try edit>fill>series (select one)
Lotus's is simpler.
>Need to fill blank cells in a column with the data from
>non-blank cell in Excel 2000. Used to do this in Lotus.
Can't seem to get it
One way, assuming you mean you have
or something like that and you want the cell with data to fill in the blanks
below ...select cell based on a number in another cell
This is what I want to do
I have a cell A1 with the number 40
In another cell I want to use the number 40 to select a cell, something
Where 40 in B40 is the number typed in A1.
how do i do this please?
Please keep all correspondence within the Group, so all may benefit!
<firstname.lastname@example.org> wrote in message
This is what I want to do
I have a cell A1 with ...picking out matched data
I have 2 different sets of data each with 3 columns. I am going to place the
2 sets of data on Sheet 1 of a spreadsheet and Sheet 2 of a spreadsheet. The
data in a row across the 3 columns pertains to each other. This is true for
the data on each sheet. I need to take the data from sheet 1 and have it
match up with any entries that exist on sheet 2, and have it show these
matches on sheet 3. The problem is the data in sheet 1 and 2 are not exactly
the same. On sheet 1 the data is: Customer Name, Transaction#, Acct#. On
Sheet 2 the data is: Customer Name, Reference #, Acct#...Select Range of Cells
Within a single column, how would I set a range to be just the cells that
have data? I want to lock these cells using a change event, while leaving
the remainder of the cells editable. I'm trying to set one range as the
entire column, and a second range as cells with data, then using an intersect
to lock the cells with data. This should allow for continuous locking of
newly used cells.
Maybe use SpecialCells(xlCellTypeBlanks) to find the empty cells and lock
the column then unlock those
"programmingrookie" <email@example.com...sumif color cells with same month
My file have two columns A - Month B - Amount
I will change the color to red of certain cells in column B
Can I use the sumif function to total column B of those cells with same
month and color red ?
You can't sum by color (is there some criteria you could use, such as
greater than x value?), but you can sum by month like this:
"eva cheng" <firstname.lastname@example.org> wrote in message
news:769CE3C9-1043-4D16-B872-E80B07E47C73@m...Changing Cell Reference in Formula
I've got this big long formula:
What I want to do is go through and change all of the A2 to k16, and
change all of the b2 to k15.
What is the easiest way to do that?
Select at least two cells (click on this cell, and ctrl-click on an empty cell)
Then use a couple of Edit|Replace's.
> Excel 2007
> I've got this b...Using the contents of a cell in a cell reference
In order to save time it would be useful to create a cell reference that
contained a variable. Does anyone know if this can be done and if so what
the notation might be?
The idea is this:
If I normally want to reference a data set from D5:D21 but sometime the
length of the data changes an it might be D5:D35 it would be helpful if I
could enter 21 or 35 in cell A1 and then reference the data set as D5:D(A1)
that way anytime I change the value in A1 my data set would be updated.
Thanks in advance
I think you want to use =indirect().
A simple example:
=SUM(INDIRECT("D5:D&...How do I stop graphs reading zero in Excel from cells with ""?
I am making a model in Excel which is takes data updates from an outside
source and then processes the information to develop charts on the data.
There are a lot of charts so I have developed the model to process the data
automatically as the data comes (down the sheet). This processing means that
there are formulas in place, waiting for the data to come in. I use a
=if(a1="","",<operation>) notation to do it for me. If there is data then
the if statement is false and the data can be processed; if the data hasn't
arrived yet then instead of getting...Bad visbility off a cell
Operating System: Mac OS X 10.6 (Snow Leopard)
Hi, i am new here. I have a question, when I click in a cell in an excelsheet then this is obscured. I mean the square of the cell is almost invisible. So if there is a lot of figures in this sheet you can not find back the cell where u was working. Has anyone a solution how to change in a better visibiliy? Thanks in advance. Thijs
On 3/3/10 8:04 AM, Thijs@officeformac.com wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
> Intel Hi, i am new here. I have a question, when...unlock frozen cells
I opened excell program to add data but it is locked. I can't add nor delete
data. None of the functions work. It opens, but is locked. Help
It might be that you have a 'Freeze Panes' issue.
To unfreeze the windows...
In 2003 -
WINDOWS > UNFREEZE PANES
in 2007 +
VIEW > WINDOWS > UNFREEZE PANES
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
"Windows 7" wrote:
> I opened excell program to add data but it is locked. I can't add nor delete
> data. None of t...what type of information we can enter into spreadsheet cells?
Please use this BIG WHITE SPACE for your detailed question.
You can enter ANYTHING you like in a cell......
Is this a homework question possibly?
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)
...Two users, one laptop, one Outlook?
I'm running Outlook 2003 on a laptop that I use for connecting to work and
for home use. I have two user accounts set up under XP, one for each role
(but I am the only physical user of the laptop). I connect to my employer's
Exchange server via VPN and I have offline caching enabled. On the home
front, I have a personal POP3 email account.
What I would like to do is share the Calendar, Tasks, Notes, etc between the
work and home users--but keep the email separate. It sounds as though this
is possible when both log-ins are non-Exchange because the same PST can be
referenced; ...Cell Protection
Arite. Does anybody Know if its posible to protect an individual cell
The only options i get are to "protect sheet", "protect workbood" o
"protect and share workbook". Im needing a bit of help. Cheers
college1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1502
View this thread: http://www.excelforum.com/showthread.php?threadid=26642
- first select all cell you DON'T want to protect
- goto 'Format - Cells - Protection' and uncheck ...Making pick list conditional on selection from previous pick list
I would like to know how to make a pick list (a "list" of names) conditional
on what was picked in the previous column pick list (e.g. of the 4 main areas
of a plant (pick list/ column A), there are anywhere from 3 to 5 sections
within each main area. I would like to format/program the second pick list
(coumn B) to only show the list of sections corresponding to the 'main area'
selected in column A. Then I need to do this for a third pick list (specific
equipment). If you have an example, it would be appreciated.
See Debra Dalgleish's Depend...two companies one Exchange 2003 server
Can I set up two storage groups one for companyA and one for companyB and
have an administrator at companyB administer the mailboxes in companyB while
I can administer the mailboxes in companyA and companyB. Both our domains
are in the same forest. We only have one exchange server and my IT director
wants to separate them as much as possible with out buying another exchange
2003 server. What are some examples of what other people have done in this
Have a look at the following webcast, it will provide ideas how to delegate
http://support.microsoft....How do I average a range of cells when one cell contains #N/A
I perform a lookup where the results could populate one cell or as many as 15
cells with number results. The cells that do not result in numbers have
#N/A. I want to average the fifteen cells but only the cells with numbers.
How do I get it to ignore the #N/A when performing the average?
which is an array formula, so commit with Ctrl-Shift-Enter
"hongkonglt" <email@example.com> wrote in message
> I perform a lookup where the re...Moving from cell to cell is very slow!!
in a machine with all office updates and xp sp2, when using excell (2000) if
you move from cell to cell either to edit data or just to format a group of
cells it takes about a minute. even in a new empty excel spread sheet.
is there a setting or maybe one of the updates cause the program to do a
search or something to delay the switching between cells?
any help would be appreciated.
"Skoal" <Skoal@discussions.microsoft.com> wrote in message
> in a machine with all office updates and xp sp2, when using excell (...Pick cell from chart
I am developing an estimating spreadsheet that calculates labor hours. I have
built a separate 10 column and 6 row chart with info I want to pull into the
estimating spreadsheet. The colums are labeled as "Difficulty Factors" and
the rows are labeled as "Pipe Sizes". Each intersecting cell is a portion of
a labor hour.
The estimating sheet has 3 drop down lists. I want to build a IF AND
statement that will select a intersecting cell in the chart if certain
criteria from the drop down lists are true.
There are 60 different cells in the chart. Is it necessary to write ...Cell Formatting After VLookup Is Done
Here are the given data
NAME OBJECTIVE ACTUAL
Jones 150 159
Smith 150 172
Ashby 150 146
Brown 150 152
Aaron 150 142
In the summary, I need to enter the NAME (say, in Column D) and i
Column E, the corresponding entry in the ACTUAL column will be looke
up. I can do this with no problem.
Here is where I need help.
If the ACTUAL value looked up in Column E is less than the OBJECTIV
(from Column B), I want the entry to be RED in color. Otherwise, i
ACTUAL>=OBJECTIVE, the cell en...