| Thread | Last Post | Replies |
|
| office2007 beta | 12 Sep 2006 20:08 GMT | 1 |
how can i get product key ?
|
| Cursor moves after enter, when it should not | 12 Sep 2006 20:04 GMT | 2 |
Using Excel 2003/SP2, I have the check box in tools/options/edit cleared for "move cursor after enter". Normally this is fine, but I made a sheet with a few protected cells and now it moves to the next unprotected cell, in whatever direction is greyed out. I don't often protect ...
|
| How to take a list of cells and sort them into a new list | 12 Sep 2006 19:48 GMT | 6 |
Let's say I have a list of 20 student numbers, unsorted, in cells A3:A22. How, if possible, can I set up my worksheet so that it will automatically take the values in that range of cells, sort them, and display them in cells C3:C22 in sorted order?
|
| Months | 12 Sep 2006 19:48 GMT | 1 |
Is there a way (formula or whatever) to have the 12 months instead of typing them. I used Jan in cell B2 and Feb in cell C2, selected both cells and then used the mouse to copy them to the range D2:M2.
|
| Speading up my Excel calculations. | 12 Sep 2006 19:29 GMT | 9 |
In a nutshell: I am putting together a database. I created a search "grid" that allows the user to choose a name from a data validation list. After selecting a name, the grid (shows 4 locations across, and the 12 months down) uses Sumproduct to count the number of units the
|
| Microsoft Office 2003 | 12 Sep 2006 19:29 GMT | 2 |
When I try to open an Excel file, nothing responds and I end up having to doa ctrl. alt. delete and get a message 'you chose to close a non responsive programme'. It cannot find excel.exe and when I try to re-install or repair Office it
|
| Help Debug Complex Formula (SUMPRODUCT? SUMIF?) | 12 Sep 2006 19:16 GMT | 3 |
Folks, I'm really struggling with this one. I've got 354 rows of data (rows 3:352). In column G there may be a date. In column M there is a number (1-12) which represents a monthly period, and in
|
| A cell appears "######". What's this? | 12 Sep 2006 17:21 GMT | 16 |
I write down a type, for example "55,000", which is by default a general type. From the menu Format, Cells, Number , I try to make it as an accounting type(in dollars), I press ok and then my type "55,000" disappears and appears a "#####" instead. What is this and how can I ...
|
| Opening Excel files in Works | 12 Sep 2006 17:06 GMT | 1 |
Is it possible to open Excel files in microsoft Works?
|
| operaciones con comentarios de celdas | 12 Sep 2006 16:33 GMT | 1 |
Hola a todos :: estoy trabajando con unas con multitud de comentarios, y quisiera saber de que forma puedo "jugar" con ellos mediante macros las dos operaciones que necesito hacer ahora son
|
| More lines in Product Pricing Calculator | 12 Sep 2006 16:24 GMT | 1 |
Hello I am new to this site and I am hoping someone can help me. I am trying to put together a pricing calculator so my staff can easily do quotes for our client, I currently work out everything manually. I need to put three or four more costs into this calculator and I am ttally ...
|
| Consolidate and Lookup | 12 Sep 2006 15:52 GMT | 1 |
I receive 8 reports monthly, 1 for each area, with the all the activity for that period. I would like to consolidate the data into one total sheet. I have a master sheet with all the specialties where I would like to have all the totals show. The activity will be different each
|
| How do I enter a date typing 040906 and have it appear 04/09/06? I | 12 Sep 2006 13:44 GMT | 3 |
I would like to format a cell so that I can just type in the numbers in a date and have the cell display the date with the forward slashes added automaticly! Example type in only 040906 and have Excel display 04/09/2006 in the cell.
|
| unable to open excel file | 12 Sep 2006 12:19 GMT | 5 |
I cannot open an excel file on the network, an error occur that "filename.xls cannot be accessed.The file may be read-only,or you may be trying to access a read-only location.Or, the server the document is stored on may not be responding"
|
| Changing a Number in a Column Using Arrays? | 12 Sep 2006 10:28 GMT | 3 |
I am trying to change a number in the left column to the number in the adjacent column. My setup looks like this. Number to Change Change to this Number 182001 182000
|