|
how to delete an old workbook from the right column in excel
I'm trying to remove an old workbook from the display column in excel.I would
like to know how to remove them when I don't need them anymore....
|
2 |
25.09.2006 03:05:16 |
|
|
comparing two excel documents
How can I compare the data in two excel documents other than manually
comparing or arranging the two files on the screen?
Word has that option of comparing two documents but I can't seem to find it
in Excel.
I have Excel 2000 and am running XP Home.
Yvonne
...
|
2 |
25.09.2006 03:03:24 |
|
|
Check Boxes
I am trying to insert a whole column of check boxes into an excell spread
sheet. I have figured out how to do one check box at a time. But if i try to
just copy and paste into the column it only copies it to the first selected
cell in the column....
|
3 |
25.09.2006 02:49:01 |
|
|
Can I use Outlook contact information in Excel w/o import or expo.
I am trying to build invoices in Excel, but would like to use MS Outlook
contact name and address info for each customer. Any ideas without a full
blown import/export of data??...
|
1 |
25.09.2006 02:02:02 |
|
|
Importing a Value from many Excel Files
Hello All,
I use a template to complete a weekly Expense Report. On every report the
cell J30 is always the Total dollar amount
What I would like to do is create another Excel worksheet that imports just
cell J30 from all of my past Expense Reports to get a running tally. Other
than opening each file (200+) and linking the data or cutting and pasting, is
there an easier way?
Thank...
|
3 |
25.09.2006 01:23:39 |
|
|
Checking balance template in MS excel
What do I need to do to have a checking balance template in MS Excel? I have
seen it work great but have not been sucessful. I am using, D as payments, G
as deposits, and H for balance, just a simple quick reference....
|
2 |
25.09.2006 01:12:01 |
|
|
How can you access Data Analysis Plus for MS Excel?
I am wondering how to download or to find Data Analysis Plus for Excel. It
has the options to do a Stem and Leaf plot and a Box Plot in the Analysis
options. I teach a statistics class, and the text says that this should be
under the tools menu, but many of my students cannot access this option.
Does anyone know why, or how they can get the upgrade? Also there is no
information regar...
|
4 |
24.09.2006 23:47:23 |
|
|
consolidating results of multiple scenarios
I have a model that outputs a multi-year profit & loss forecast for one
of x projects depending upon input into a project number field. For
example, if I wanted to analyze project 1, I would type 1 into the
project number field. I'm trying to figure out how I can create a
consolidated p&l summary of all the projects that will most likely be
viewed as a pivot table. I'm trying to minimize the ...
|
1 |
24.09.2006 21:45:47 |
|
|
Excel makes an error
I am currious to find an explanation for this. In excel I created a
simple formula to calculate 12 to the 19th power written in full
numerical form. At 12 to the 17th excel makes an error (note the
zero's). Try it yourself. Anyone know why this happens?
12
144.00
1728.00
20736.00
248832.00
2985984.00
35831808.00
429981696.00
5159780352.00
61917364224.00
743008370688.00
89161004482...
|
4 |
24.09.2006 20:33:01 |
|
|
download existing spreadsheets into another existing spreadsheet
I need to download several existing spreadsheets into one existing
spreadsheet. Is this possible?...
|
3 |
24.09.2006 19:36:00 |
|
|
COUNTIF criteria
I have the following data:
70
80
71
71
66
83
70
77
79
65
62
57
50
I want to use the COUNTIF function to calculate the no. of times
numbers occur in a range. For example how many numbers are between
41-50. The criteria could be something like >=41 "to" <=50. But how do
i properly format it.
If COUNTIF cannot be used for this, other suggestions would be welcome.
Actually I...
|
10 |
24.09.2006 19:11:51 |
|
|
Totaling pre-defined groups?
I am not an excel wiz and I have a problem that is hard for me to solve. I
would like to total the # of units for a defined height range. For example:
how many units are within the height range of 38-44? or 46-51? I would like
to have a simple macro that references cell addresses for the min and max
height ranges I wish to total. Below is data examples. The auto filter
works ok, but I wan...
|
6 |
24.09.2006 19:00:32 |
|
|
Sorting
I have one column with data but some rows are blank. Is is possible to set up
function like "advanced sort" where the data from the column that isnt blank
is copied to another column then sorted, but so that if any items are altered
in the first column the second column automatically updates itself without
the need to run a sort again? Hope that makes sense!...
|
8 |
24.09.2006 18:58:02 |
|
|
Excel 200 crashes
I can open excel spreadsheets no problem. As soon as I try to change the
font, or the font size, it crashes. Anyone have any ideas?
Thanks
...
|
2 |
24.09.2006 18:49:18 |
|
|
Chart or macro problem
hi
problem: Have around 300 student records want to produce a chart for
each one, the chart contains 4 pieces of data for each student and is
unique to each student, I want to produce a seperate excel template for
each student e.g. i will end up with 300 seperate excel files prefably
called the students name??
any help would be gratefully received
cheers
paddy
...
|
2 |
24.09.2006 17:55:03 |
|
|
Exam Marksheet - Grading
Please help me with a formula for my marksheet.
The exam grading is A, B, C, D and E. E is a failure
To pass the overall exam, a student must :-
Must NOT FAIL in any 4 subjects from columns E7, G7, I7 and K7
and MUST PASS ONE subject from column M7, O7, or Q7
and MUST PASS ONE subject from column S7, or U7
What is the best formula for this? Can u suggest the formula?
Thank you f...
|
2 |
24.09.2006 17:33:51 |
|
|
Help with conditional formatting
How would you write this formula to show in red?
If F1 = 5 OR O1 = 5000 then conditional format these cells in red.
B3,B7,B8,B13,B14,B17,B19,B20,B21,B22,B23,B24,B28,B30
Thanks in advance!!...
|
3 |
24.09.2006 16:25:48 |
|
|
data table based on data table
Is it possible to get a data table that is based on a data table?
I have a data table, and the results are obviously driven by two variables.
The resultant cell is an IRR cell.
I have set up 6 scenarios of 5 inputs. The model which drives everything is
based in part on the scenario chosen from a dropdown. In other words, I have
a dropdown which selects the scenario number. That dri...
|
1 |
24.09.2006 14:11:01 |
|
|
How to display month only for date format?
Does anyone know how to display the month only for date format?
such as 26 Sep, 2006, it displays Sep only.
Thank you for any suggestion
Eric...
|
3 |
24.09.2006 13:59:36 |
|
|
Pointer shapes
I understand that each shape has a meaning such as the hourglass means
"working" however, is there a place where I can find the meanings of each
different shape? My daughter sent me a spread sheet that I needed to edit
for her. When I copied and pasted it into my program the pointer was
something I hadn't seen before. It was an outlined "pkus" sign. The arrow
doesn't appear on the s...
|
1 |
24.09.2006 13:02:02 |
|
|
self-sizing adv.filter criteria range
I'd like to have an advanced filter which does not need to be told, manually,
how high the criteria range needs to be for a filter. In other words, I want
a user to be able to enter either one line of data, or two lines, or maybe
more. If I put an adv.filt on a range for three lines at once, then if I
don't have and OR criteria (on two lines), the third line ends up serving as
an "all"...
|
4 |
24.09.2006 12:30:11 |
|
|
Graphing problem. Please help.
Hi there,
I have a graph with columns and lines on 2 axes. I'm using the format
"Line-Column on 2 axes" but i want specific data sets presented on
lines and others on columns.
Can anyone tell me how you select whether a data source appears as a
line or column?
Any help much appreciated.
Thanks.
Kim
...
|
2 |
24.09.2006 10:54:54 |
|
|
Repeated shading of rows??
I want to create simple planner/calendar:
(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.
I would like to shade in every seventh row.
Can I do this shading automatically with Excel 2003?...
|
9 |
24.09.2006 09:28:01 |
|
|
Automated printing
I have workbook with ten tabs, I would like to link check boxes on the first
page to printing. Is it possible to set a macro linked to a button to look at
the check boxes, then only print tabs for which the check boxes relate to....
|
3 |
24.09.2006 08:27:02 |
|
|
Editing an excel spreadsheet with the new data in colored text?
I would like to know how to edit data in a excel spreadsheet and have the new
data go in as colored text the same way that editing is documented on MS
Word.
I have a very big spreadseet to edit and I don't want to have to bold the
font and change the color (with multiple key strokes) each time I edit a
cell. I need to have some type of documentation to identify the edited dell
cont...
|
2 |
24.09.2006 06:52:12 |