|
averaging class grades
All I could get it to do was average 3 weeks grades instead of the 6 weeks I
put in for (from G1:M1) and by highlighting the whole area-I used the
=AVERAGE,etc. I'm not sure what I did wrong still. ...
|
3 |
12/29/2008 9:16:13 PM |
|
|
formatting all worksheets in a workbook identical
i have eight sheets in a worbook---they have headers, footers, row heights,
column widths, font sizes, etc. can I format these so that everything
appearance, layout, margins, etc. are identical on the eight sheets. Of
course, the text or figures un the cells would be different
thank you very much...
|
6 |
12/29/2008 3:49:35 PM |
|
|
How do I average my grades for my students
I have 20 students with 6 grades entered for most of them-How do I average
them?
--
sally nbct '02...
|
3 |
12/29/2008 3:03:35 PM |
|
|
copying formulas
how do I copy a formula in a column through 52 rows?
I have a column of 52 rows into which I want a sum from about 10 other
column's cells to appear. How do I copy this formula to keep the sum from
the same 10 columns following down with appropriate row #s throughout the 52
rows?...
|
2 |
12/29/2008 5:51:03 AM |
|
|
Copying Web Tables To Spreadsheets
I'm trying to copy a table from a website to an Excel 2003 spreadsheet so
that the results are listed in a single line for each nursing home listed.
When I initially attempted this, I copied the table including the first
column for the check boxes. The transfer appeared to go well but before I
could examine it in depth, I chose to delete that first column of check
boxes. Then I decided t...
|
4 |
12/29/2008 2:26:48 AM |
|
|
Cell display
Due to a print formatting issue I am trying to copy the contents of one cell
to another. If the original cell is blank, I want the duplicate cell to be
blank. If the original cell contains a numeric value, I want the duplicate
cell to contain the numeric value to two decimal places. How do I format the
duplicate cell to achieve this?
Thanks...
|
3 |
12/28/2008 11:03:17 PM |
|
|
Cell formatting
For print formatting purposes I need to duplicate a keyed in numeric value
from one cell (say A4) into another cell (say Z4). In many cases the
original cell (A4) will be blank. How do I make the duplicate cell (Z4)
remain blank also? Right now I end up with the original cell (A4) as blank
and the duplicate cell (Z4) as a 0 value. If I do put an entry into the
original cell, it will ...
|
3 |
12/28/2008 11:00:27 PM |
|
|
a transcript
im a principal and im trying to figure ou how to make a transcript...
|
2 |
12/28/2008 9:24:03 AM |
|
|
how can I create a csv file with quotation delimiters & commas
...
|
2 |
12/27/2008 11:39:49 PM |
|
|
added unwanted data in column
Why does excel add a y to the abrev. st? How do I ge it to quit?...
|
2 |
12/27/2008 9:55:03 PM |
|
|
Should I update to Excel ?
Hello
This is my first message on this forum.
I am not really a computer person but I do use a computer especially Works
version 7 spreadsheet to do my accounts. I do not have Excel but
I am consideing buying the Excel update.
If I do this what happens to my existing works spreadsheet files ?
Do they become unusable, or do they become automatically converted to Excel ?
Or can I continue to...
|
2 |
12/27/2008 6:18:55 PM |
|
|
adding values from 2 columns
I am trying to compose a personal cash flow chart where I can enter outgoings
and income for every day of the month and see what the balance is on any day.
I need to get a value in Col F which adds the value in Col C (daily income),
subtracts the value in Col E (daily outgoings) and shows the balance.
Also I may have to specify several rows if I have multiple outgoings on a
particular day....
|
2 |
12/27/2008 12:34:01 AM |
|
|
nebie help please
hi everyone .I am new to excel so please be gentle with me.
2 things.
I have a spreadsheet I that I " inherited " it is quite large and has
a number of sheets which produce results which are entered into the
first page. Is there a way of seperating the first page ( results page
) from the rest when all data is entered so I can email it easier, the
result page still has to have macros enabled an...
|
3 |
12/26/2008 5:32:01 PM |
|
|
performing regression
want to determine a value for a period of years that i do not have data...
|
2 |
12/26/2008 4:10:41 PM |
|
|
importing data
how do i import data from labview to excel sheet...
|
2 |
12/26/2008 1:44:56 PM |
|
|
a simple count question ... ?
I'm using Excel 2007 and in column A I have a list of items that I wish to
have a total count of. I have spaces (empty cells) between some items in
column A to make it easier to group (and to see) but was wondering if
there's a way to count the cells that only contain info.
In case I haven't described this clearly, I don't want an addition of these
items (they're words and not numbers)...
|
3 |
12/26/2008 1:31:58 PM |
|
|
Simple graph question
Hi, new to Excel..
....have two columns...in one is a list of about 60 dates during 2008, in the
other a list of miles walked on the specific dates...and have managed to
produce a bar chart showing miles per walk.
How do I easily arrange to:-
1. Show a vertical line on the bar chart on the first of each month.
2. Alternately color the area of the graph for the 12 months, say
red..green.....
|
1 |
12/26/2008 1:31:29 PM |
|
|
How to get the lines in an Excell document to print?
In an Excel document only the text in and above the columns prints. I want
both the vertical and horizontal lines to also print....
|
9 |
12/25/2008 7:44:00 PM |
|
|
How do I enable megrge cell function
The mere cell function is checked, but dimmed and cannot use it. Most
probably I hit a wrong key on my keyboard. Any tips on how to enble this
funcion again...
|
2 |
12/24/2008 4:55:10 PM |
|
|
can you use something like words "includes" in excel
To create a book in word you can use "includes" to build the different phases
of the book. I am creating a multiple page census report in excel, the
bigger it gets the more it crashes, can I make separate files and use
something like "includes" combine all pages in printed copy of the book.
Mary Ellis...
|
2 |
12/24/2008 1:45:32 PM |
|
|
Sort data Excel 2007
How to sort using date and then time in an "a" and "p" format for Excel...
|
5 |
12/24/2008 2:11:01 AM |
|
|
SHADING FOR MULTIPLE TEXT ENTRIES
hello again,
more specifics on exactly what i am trying to do.
i have 300 rows (record entries) containing people's names. These folks
over the next 12 months are going to be going in a variety of locations.
I have a large amount of columns set up as dates.
I am going to limit the data entry into the date column/cell to the following:
DB, DN, DS, DO, DJ, HH, PCS, LV
As I...
|
5 |
12/23/2008 8:37:01 PM |
|
|
unwanted superscript change in macro
Hello,
I have a macro that does a copy/paste followed by a find and replace to
change the color of some text and make it bold. At the end of running the
macro though I discovered that it also changes the formatting to
superscript. I got around this by turning off superscript after the find and
replace but I am wondering if there is a way to stop it becoming superscript
in the first pl...
|
1 |
12/23/2008 7:54:39 PM |
|
|
How do I calculate duty times
How do I calculate duty times and need to separate if any one is late and
their overtime...
|
2 |
12/23/2008 1:18:04 PM |
|
|
How to convert csv file to dbIII
How do you convert csv file from Excel to dbIII for mat for another program
...
|
2 |
12/23/2008 12:47:02 PM |