| Thread | Last Post | Replies |
|
| Fill handle | 29 Jun 2007 02:00 GMT | 7 |
I am using Office 2007. The help for Excel says one can use a "fill handle" to fill data from a cell or cells above to cells below. Help also tells one how to enable the "fill handle", which I have done. However, help does not tell one how to get or find the fill handle. How ...
|
| Data validation and drop-down lists | 29 Jun 2007 01:46 GMT | 2 |
Background: I'm setting up an inventory that records the usage of corporate gifts. I've set up 2 worksheets. These are a 'Source' worksheet containing lists of gifts, gift values and staff names; and a 'Record Usage' worksheet where staff record their usage of gifts. 'Record ...
|
| Reorder a CSV file...Anyone? | 28 Jun 2007 23:43 GMT | 3 |
How can I reorder a CSV file (in Excel) in which names and addresses are held? Each name and address is on an individual row, with the name and each line of a particular address in a separate column. I wish to reorder this matrix
|
| sorting sheets | 28 Jun 2007 23:06 GMT | 2 |
I have a list of numbers that coincide with the sheet numbers... i want to be able to click on the number on my first sheet and have it open up the sheet# that i click on... is this possible and if so what function do i use to direct it to do this??
|
| Excel Data Entry Forms (Data, Worksheet) | 28 Jun 2007 23:02 GMT | 3 |
Folks: I have a small Excel 2003 spreadsheet that I use for data entry purposes each day. The first half is used for data entry and the second half does calculations.
|
| Cell displays different result than Fx | 28 Jun 2007 21:30 GMT | 7 |
I have a formula that sums up 3 different VLOOKUP values from data stored on a separate tab. However, when I paste over the old data with new data (a downloaded page from one of my company's systems), the cell results do not change. However, when I click into the "fx"
|
| Shifting Objects | 28 Jun 2007 21:05 GMT | 2 |
this is probably a bsaic question. I created a worksheet that has multiple columns of data. Some of the columns have a check box inserted in them. Now I would like to hide some of the other columns, but I am getting an error message telling me I "cannot shift objects off sheet". ...
|
| Module | 28 Jun 2007 20:46 GMT | 1 |
What is the difference between Module and class module? If I have a certain code in VBA, how do I know when to put it as class module, module or in sheet or workbook? Any explenation is highly appriciahted
|
| Totaling a column or row of "x" s | 28 Jun 2007 19:34 GMT | 12 |
I have several cells with an "x" in them. I am trying to get a total of the "x"s by row and column. I am new at this and need a step by step instruction. Thanks.
|
| Insert Picture | 28 Jun 2007 19:20 GMT | 3 |
I have never used excel before. I need to make a form with a box. When you click on the box it should ask if you want to add a picture to the
|
| Help - My tables have extra boxes around the text. | 28 Jun 2007 19:18 GMT | 1 |
I've pasted tables from an old document into another document. The tables now have extra boxes around the text. It looks like a table in a table, but I can't get rid of the extra boxes. Does anyone have any ideas?
|
| Creating lists from multiple worksheets within one workbook... | 28 Jun 2007 18:03 GMT | 1 |
I've got a list of information on a separate sheet within my workbook, and I'm wanting to create a pull-down list to choose from the options provided. However, I also want that result to automatically generate or fill in other fields associated.
|
| SumIf help please | 28 Jun 2007 17:59 GMT | 3 |
I want to sum column values if the adjacent cell has the word "Written" in it. Any help? I am sure excel can do this. Thanks In Advance, ~ck
|
| trying to concatenate two columns without removing leading zeros | 28 Jun 2007 17:44 GMT | 4 |
A customer sent me a spreadsheet in an incorrect format for my purposes. I have about 13,000 records in Excel 2007 where I need to concatenate column 1 with column 2 to create the format I really need. The problem is that each of those columns contains numbers, and when I
|
| password problem | 28 Jun 2007 17:33 GMT | 2 |
i have an old dell latitude laptop computer with xp home edition. i hardly use this computer and in doing so i forgot my password. i can't log in, is there anyway to bypass the password and get into the computer so that i can delete
|