| Thread | Last Post | Replies |
|
| UserForm position | 26 Aug 2007 04:50 GMT | 1 |
Can a UserForm position be locked on the screen so that a user cannot move it? I have define one as Top of 0 and Left of 0 but the user can still drag it where they want and our scanner only looks at the top left hand portion of an Excell screen.
|
| Formulas | 26 Aug 2007 04:02 GMT | 6 |
I am making a timesheet specific to my job and can't figure out how to do the formulas. I have my total hours for the week tallied up but I need formulas for the following categories:
|
| How to count the char "w"? | 26 Aug 2007 00:14 GMT | 6 |
Does anyone have any suggestions on how to count the char "w" within cell A1? For example, in cell A1, waterfall - wc, please ignore the upper / lower case, I would like to count how many "w" or "W" inside the cell A1. Does anyone have any suggestions?
|
| How can I input arabic text into Excel via a UK keyboard? | 25 Aug 2007 22:54 GMT | 1 |
I am learning arabic and would like to create a vocabulary test study aid using Excel. i don'y know how to get arabic script to work on my PC. Any help much appreciated !
|
| Slanted cells with text | 25 Aug 2007 22:22 GMT | 2 |
How do I make several slanted cells with centered text at the top of a table in Excel 2003?
|
| how to repair an excel file | 25 Aug 2007 22:20 GMT | 1 |
I use excel 2003 and cannot open an important file. Get a message tht the file cannot be read. Then I get a message tht the file was so damaged that repairs were not possible. Is there a way for a novice to recover this file?
|
| "cannot shift objects off sheet" error message, | 25 Aug 2007 22:15 GMT | 2 |
I can't insert rows, I always get the above message. I also can't cut and insert a row.
|
| Have something occur on scroll | 25 Aug 2007 19:56 GMT | 2 |
Suppose I have a worksheet active. At any given time, a certain set of rows on the sheet are being displayed. 1) How would I have a VBA put the correct values in the variables FirstRowBeingDisplayed as Long
|
| file excel cannot open directly | 25 Aug 2007 19:48 GMT | 3 |
dear all, please help me. i cannot open file .xsl (excel) directly when i click. all files .xsl only can open and view ; after open excel application, then click open file, then search file and then select file then open.
|
| Hide Expand Rows | 25 Aug 2007 19:03 GMT | 1 |
I want to create rows underneath a row but I want them to be drop down when you click on the crosshaire next to a cell so they kind of roll up and down. Can any one help me with how to do this.licke the do on this website to see what is underneath you need to click the crosshair ...
|
| How can i make a name equal a value like DZ=12, GR=144 and EA=1? | 25 Aug 2007 18:04 GMT | 2 |
I'm trying to get a cell to know what his value is by putting a name. What I really want it to do is to know if it is a Dozen by putting DZ so it will automatically know it's 12. The same with a Gross, which is 144 and Each, that's 1.
|
| Trigger Event on Format Change | 25 Aug 2007 17:43 GMT | 4 |
Lots of posters, myself included, would like to trigger an event when a user makes a change in sheet formatting, like changing the interior color of cells. Of course, Excel doesn't consider changing cell formatting a worksheet change. The only thing I can see that changes is ...
|
| Saving file as current month name automatically | 25 Aug 2007 17:34 GMT | 2 |
I have folder which contains 40 different worksheets for each depatment which I want to be able to save it automatically as that month's name in the folder for that month. So that way, I don't have to manually do save as for 40 files. Can someone please help me with automizing ...
|
| autosum with filter excel 2007 | 25 Aug 2007 16:42 GMT | 1 |
I have a small database I'm using and when I filter nad try to use the autosum I'm getting a wrong answer. I think excel is also including numbers not in the filter range I've chosen. Any suggestions or am I doing something wrong.
|
| Dividing cells by 1000 | 25 Aug 2007 15:36 GMT | 1 |
I have a document in which I have to do my report in thousands i.e. $1000 represents $1,000,000. How do I divide each data cell by 1000 without individually dividing each cell by 1000?
|