| Thread | Last Post | Replies |
|
| Find the most recent date | 19 Sep 2007 09:43 GMT | 4 |
Hey all, Is there a way to find / fitler by the most RECENT date entry. I.E. I have the following data set: ID DATE
|
| A hard one - How to edit screen tip in colour palette? | 19 Sep 2007 09:32 GMT | 1 |
By entering -->tools--> options tab-->colour it is possible to create your own colour palette for your excel sheet. When I use these colours I get screen tip telling "colour scheme". I whish that my colours get named in screen tip. Eg "red", "Blue" ...
|
| Excel 2002: How to condition format rows with empty cells ? | 19 Sep 2007 06:51 GMT | 6 |
Dear Sir, I have the following workshhet: A B C 1 CODE DATE AMOUNT
|
| How do I delete a header? | 19 Sep 2007 06:36 GMT | 1 |
I'm new at this--- I made a header but it's not what I want and I want to delete it and it keeps appearing on sheet.
|
| Dynamic Range Using INDEX instead of Offset | 19 Sep 2007 06:16 GMT | 4 |
Need Help to learn this: Dynamic Range Using Index(). I can do this: =offset(A1,0,0,CountA(A:A),CountA(1:1))
|
| Saving text with commas in a .csv file then converting to a .txt f | 19 Sep 2007 06:10 GMT | 3 |
I need to get an Excel sheet (Office 2007) into a text format that is comma seperated with quotations around the cells that contain text. I can save the sheet as a .csv file which handles the commas, but when I change the file extension to a .txt type I end up getting quotations ...
|
| Calculating a Data Range | 19 Sep 2007 05:58 GMT | 2 |
To whom it may concern, I have an age data range from H2:H1844, with ages ranging 23 thru 101. I need to put them into categories such as 23-35, 36-45, 46-55, etc.... I need to count how many times 23,24,25...35 occurs for a single number so I
|
| Print area giving me 1 page per cell | 19 Sep 2007 05:36 GMT | 4 |
When I try to adjust my spreadsheet to one page both manually (through print layout view) and automatically (by adjusting to 1 page tall by 1 page wide) I get a print layout that is 1 page per cell. Any idea what is causing this error and what I can do to fix it?
|
| Email to list sat up in Excel | 19 Sep 2007 05:00 GMT | 3 |
I have entered about 500 email addresses into Excel spread sheet, how do I merge these into a email so I can send this out in groups of 50? I know they have to be separated with commas but I do not remember how to do this. Please give step by step I am very slow with a computer
|
| How can a picture become a resource for multiple Excel worksheets | 19 Sep 2007 03:26 GMT | 2 |
I'm trying to have a picture dropped into a cell, that I can then source as required in other work pages. Is this possible?
|
| Enter number in cell and have it divide by 4 | 19 Sep 2007 03:08 GMT | 10 |
I have a cell that when I type the number for example 12 I want it to return 3 So the Number I type in divided by 4. I have some other cells I am going to do with the number 8 and so on. Thanks
|
| Find exact match, same workbook, different sheets | 19 Sep 2007 03:02 GMT | 2 |
I have a worksheet named, "contact master" that has the name and address of employees. I have a second worksheet named, "master schedule" that has the names and training schedules of employees.
|
| named cell in macro | 19 Sep 2007 02:18 GMT | 2 |
I posted this question earlier & it got posted in Excel for MACs, I am using a PC Currently in a macro, I copy a cell from Workbook A into Workbook B by specifying the worksheet and cell ID.
|
| Different info per printed page | 19 Sep 2007 01:53 GMT | 3 |
My wife is a teacher and uses Excel to keep track of student grades. Up to this point, she's been having to manually type student names and grades into a word document in order to give the students printouts. What I'm trying to do for her is make either a Word document or an ...
|
| Typed or pasted text in a cell appears as #### | 19 Sep 2007 01:50 GMT | 6 |
What do I do to make it readable on the spreadsheet?
|