When I click on the end of a formula in a cell, I usually get all the
associated cells highlighted with different coloured borders.
I have one workbook with several sheets where this no longer happens on
just one sheet.
Is there some option I need to turn on in the sheet to make the coloured
cell borders appear? Or might it be something to do with very recently
using automaic update to bring my Office 2003 up to date?
Any assistance much appreciated.
You should always get *exactly* the same actions if you would click in the
As far as having the cell itself h...How do I search for data in excel?
I need to create either a macro or a function to do a search through out the
entire spread sheet for data. Can you tell me how?
In xl2k, you can group the sheets before you do edit|find. (Click on the first
and ctrl-click on subsequent--or right click on a worksheet tab and choose
select all sheets).
In xl2002+, you can specify "within workbook" under the options button on the
In all versions, you could use Jan Karel Pieterse's FlexFind:
> I need to create either a macro or a function to do a search through out ...Excel getting info from Access
I have recorded this macro that modifies the information that I am pulling
into Excel from an Access query. About half way down, there is a line that
says, "WHERE (invexcption.Area='US006')". I know that I can modify the code
to bring back another areas information. for example,
I would like to be able to make the Area a variable, so that I can create
and save a different file for each area... but cannot seem to get it to work.
Does anyone have any thoughts?
With ActiveWorkbook.Connections("Query from MS Access
Da...Formula for nonnumeric percentage
I have a spreadsheet that contains employee information.
I have 1 column that states the sex (M or F). Now I want
to know using a formula, what is the percentage of female
Thanks!! It worked perfectly.
>If E1 to E9 contained the M/F's
>Format the cell as percentage
>"Taleen" <firstname.lastname@example.org> wrote in message
>> I have a spreadsheet that contains employee
informatio...Excel vs Access
I have a project that I am being asked to develop for work. It will be a
method to QA reports using a grading method for sections within the report.
Initially, I was leaning towards using EXCEL with a userform to provide the
input for the grading of the report.
As I thought more about it, I realize that I can have around 1000 reports
per year per person that will be QA'd. I was going to have a workbook for
each employee. I am now wondering if ACCESS will be better suited do to the
number of reports and use Excel for the boss to collect a summary of the data
from Access...Minimum and maximum value of Axis set by user by reference to form
Excel seems to have 2 alternatives for defining the min/ max value of an
axis: either automatically or preset by the user.
But is there any way that the minimum and maximum value that the axis is
defined by the user based on the values of the spreadsheet (i.e., halfway
between the above two apparent options provided by microsoft)?
Yes, you can tie axis values to worksheet cells via a macro. The process is
described via the link below . . .
> Excel se...Value Axis Adjustment
I created a Gnatt Chart with 8 activities. The times on the values axis are
listed as 3:50 AM, 4:19 AM, 5:16 AM, 6:14 AM, 6:43 AM, 7:12 AM, 7:40 AM, 8:09
AM, 8:38 AM, however since my activities take place between 5:30 AM and 8:15
AM, I wanted to decrease the time that is displayed on the chart
dramatically. For example, I would like to see the time on the values axis
displayed in 5, 10, or 15 minute increments. I am assuming this requires me
to adjust the minimum, maximum, major unit, minor unit, and category X axis
data in the Format Axis, but I am not sure what to enter. Could yo...Save excel automatically
Is there anyway to save a backup of excel automatically when you are working.
I am using excel 97 and excel 2002
...how do I extend a trendline to cut x & y axis in excel
How do I extend a trendline on a scatter graph in the chart feature of excel
so it cuts the x and y axis
Thanks very much
Left-click on the trendline and choose Format Trendline. On the Options tab
are parameters to extend ("Forecast") the trendline as far forward or
backward as you wish.
> How do I extend a trendline on a scatter graph in the chart feature of excel
> so it cuts the x and y axis
> Thanks very much
...Excel Cell Width
How do I adjust the width of a cell WITHOUT adjust the entire column?
> How do I adjust the width of a cell WITHOUT adjust the entire column?
Jeff, the only way would be to use format center across selection, or merge
cells to put two or more cells in the row together
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"JeffW" <JeffW@discussions.microsoft.co...Excel VBA programming
I am bringing a large amount of data into worksheet 4 in a workbook. I want to use VBA to run queries on the table in worksheet 4. I am not sure how to set up a query for data that is in the same workbook. I'm sure this can be done, can't it?
EggHeadCafe - Software Developer Portal of Choice
Caching Pages and Application Data with Database Dependencies
Sure, but you will have to tell us more. the macro recorder can be your
Microsoft MVP Exce...Secondary Axis #9
I am trying to creat a chart with one y axis as x and a secondary axis as
100-x. Is there a way to do that? When I add a secondary axis Excel picks
the values for that axis I want to pick the values.
Format the axis and you can set the scales.
"JMH" <JMH@discussions.microsoft.com> wrote in message
>I am trying to creat a chart with one y axis as x and a secondary axis as
> 100-x. Is there a way to do that? When I add a secondary axis Excel
> the values for that...Limitation in number of charts
A friend of mine has run into a problem when adding charts to a workbook.
Right now he has about 60 charts in the workbook, and when he tries to add
another one, he gets in error telling him, that he exceeds "the maiximum
munber of FONTS in a workbook". He has enough memory so that is not the
problem, and as far as I have been able to find, that is the only limitation
concerning the number of charts (btw he needs about 350 charts in the
The only other linitations I have found deals with limitations for a single
Does anyone know if the details in different charts a...stock chart non-linear y-axis
A chart displays columns representing #shares traded for a group of 20
stocks along x-axis. Because the displayed values span a wide range
(some columns are 1000x larger than others) the small volume stocks are
hardly visible. What is needed is a way to make Y-axis non-linera;
however, a log scale is useless because of the enourmous compression
that takes place at the higher end of the y-axis.
Is there a way of displyaing non-linear values at a scale less than
allowed by log values? Web-based stock charts do this regularly, for
example see chart displayed on Yahoo finance of Apple Computers ...Excel 2003 VB referencing #N/A not working but works in Excel 2007
I have a very simple macro that works in Excel 2007 but hangs up constantly
in Excel 2003. Does anyone have a work around?
When referencing cells that have a #N/A value, Excel 2003 craps out even if
I use the ISNA application function before it. The following 2 statements
will cause Excel 2003 VB to stop regardless of order if the cell that is
referenced comes up with #N/A.
Series = Cells(RowNumStart + X - 1, SeriesCol).Value
If WorksheetFunction.IsNA(Cells(RowNumStart + X - 1, ColNum)) Then
Further background.... I am actually wanting to find #...Editing secondary x-axis
I have successfully created a secondary x-axis in Excel 2003, but cannot edit
it. The dataset I want clearly sits on a second, upper (?) axis, but I cannot
change min/max values, tick-marks etc as the only options available (using
Format Axis) are for the primary axis.
What kind of data is plotted on the secondary X axis? If it's in the form of
a line or column chart, the axis will not be numeric and you will be unable
to change the scale.
Did you really create a secondary X axis? If you simply assign a series to
the secondary axis, Excel often only creates the secondary Y ax...Excel creating 'backup' version of my sheet...
a user noticed that one of his sheets is creating backup-copies by itself...
- He deletes the backup version
- opens the original sheet
- change something
- saves the original sheet
- closes the original sheet
tadaaaaa.... now a new file with 'name backup.xls' is created...
He told me that he noticed this behaviour when he was 'protecting' his sheet
by a password. Now we moved to Office2007 and he wants to get rid of this
(btw, no add-ins are installed!)
Seems there is an extra checkbox, hidden in the tools options in 'Save...how do I create GST worksheet in excel
What is a GST worksheet?
Please explain what you're trying to do
"jl" <email@example.com> wrote in message
Sounds like Goods and Services Tax. Are you Australian?
GST is calculated as 10% of sales.
So if you quote a price inclusive of GST, the GST is =price/11
Total Price $110
Includes $10 GST
So, what do you want the worksheet to do?
Thanks for your response. I am Canadi...Excel auto accumulation formulas
I need a formula for auto accumulation formula like example:
John need to give me USD50 everyday for one month, so if he never paid the
money i will key in 0.00 in that collumn and the ammount accmulated for today
is 50.00 and the next day calculation like USD100, but if he did the payment
full i will key in 50.00, if he only pays USD30 i will key in 30.00, so the
balanse out standing will shows 30.00 for today and will shows 80.00 on the
next day. I need a formula for every single day it auto accumulate USD50.
I'm trying alot of formula but none is working. Th...Excel formula #5
I have downloaded data from my manufacturing system in a tab-delimited
format. I import into excel and some of the data in some of the
columns have quotation marks around my text. What formula can I write
to detect whether there is a quotation mark at the begining or end of
my column and if there is, delete the mark. Bear in mind that the data
is different lengths.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Select the data and Edit>Replace>~?>...Excel Changes not saving
Operating System: Mac OS X 10.4 (Tiger)
Hello, <br><br>I am working with a graph that is automatically updated through functions when I add new data to the spreadsheet. Everytime I try to change the format of the graph, (for instance making the values of the graph show vertically), when closing the spreadsheet after saving and opening the file again, the graph reverts back to its original format. Insight to my problem will be much appreciated!
> This message is in MIME format. Since your mail reader does not understand
this format, some or ...how to delete duplicated entries from an excel list
how to delete duplicated entries from an excel list
Chip Pearson has tons of ways of working with duplicates at:
> how to delete duplicated entries from an excel list
Use the technique here to tag the dupes, then autofilter on the tag and
delete the filtered rows
> how to delete duplicated entries from an excel list
...Y Axis Scale Problem
Hello. I'm making a chart that shows me the times between entries in another
worksheet. Thusfar everything works find but I noticed that there is the
occational drought of entries and the time goes from averaging around fifteen
minutes to a couple of hours. Especially during lunch. Is there a way I can
get the Y axis to increase the Major unit the higher in the scale a point is.
Something where I can have on hour take up half the total Y axis and the
second hour take up another half or third and so on so I can put a nine hour
workday on the scale and still have everything look ...Excel 2003: Cannot access directory
I have a second hard drive where I store my files. The windows mapping
originally mapped it as drive "F". I have added a 2nd DVD burner recently
and now my second hard drive is mapped to "G". In my Excel 2003, under
Tools:Options, when I click the Save tab, it gives me an error "Cannot access
directory F:\data\excel". In fact, it happens when I click any of the tabs.
Since this is where I need to change the mapping I am stuck. Anyone know how
to change this outside of the application?
"HeartInNC" <HeartInNC@discussions.m...money to excel
Is there a way to get a downloaded money file from a bank
which is in QIF or OFX from money into an excel file?