| Thread | Last Post | Replies |
|
| CELL HAS A GREEN TRIANGULAR SPOT ON THE TOP. WHAT DOES IT MEANS. | 21 Mar 2006 19:54 GMT | 1 |
On the rectangular box along with the figure there is a green triangle ypside down. What does it means.
|
| can't seem to add a line break in a cell | 21 Mar 2006 19:40 GMT | 2 |
Hello, I'm working with excel 2002. I want to hit enter and create a new line within a cell, yet I am unable to do that. Does anyone have any suggestions? Thank You
|
| moving text from a word document to excel | 21 Mar 2006 19:18 GMT | 2 |
I'm moving a large amount of text from word documents to an excel spreedsheet, and I have a few questions: 1. When I copy/paste text from the document to the spreedsheet, the text will sometimes expand the cell very large. How can I keep all the cells the
|
| Freeze header row at top of each page and exclude it from sorting | 21 Mar 2006 19:02 GMT | 4 |
In Excel XP on Windows XP, I need to freeze the first row (header row) so that it will always appear at the top of every page and its data will not be included in sorting. Only data below the first row should be sorted. How do I do that? At present whenever I sort by any column, the
|
| Spin box min/max | 21 Mar 2006 18:05 GMT | 2 |
I put a spin box linked to a cell containing an item cost of 1.50 because the items cost is part of a cutting test I want the user to b able to increase the cost in increments of .01, the spin box increase by 1.00 and the coding will not accept under 1.00, is there a wa
|
| Web query and special characters | 21 Mar 2006 17:59 GMT | 1 |
I have a simple HTML data dump which has special characters: áéíóúñ In the HTML source I placed <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> When I download this table, all the accents are translated into unprintable
|
| How do you add text after a formula? | 21 Mar 2006 17:11 GMT | 3 |
I'm working on creating a report. At the top of each section is a mont that I type in. At the bottom I want a cell to display that month an also add the word "Total". So for example I have May listed in Cell B3 I now want "May Total" to be listed in cell B36. I know if I want it t
|
| Paint control in the vba toolbox? | 21 Mar 2006 16:52 GMT | 1 |
I want to have some lines, boxes and circles on my excel vba userform. In the excel vba toolbox there are no paint controls. Where can I find these controls and how can I add them to my toolbox? Thanks,
|
| Hyperlinks | 21 Mar 2006 16:52 GMT | 2 |
I've copy/pasted information from a web page into an Excel worksheet. The information in my new worksheet is in the form of hyperlinks which I don't want. Is there anyway of deleting hyperlinks (all in the same column) in bulk?
|
| Staff holiday Records - Dynamic Record? | 21 Mar 2006 16:08 GMT | 1 |
I am using Excel for keeping track staff records - Holidays - Medical annual, etc. so far it works good for me, the thing is everytime a new member come in i have to add the formula (copy). no problem. but everytime a staf
|
| copy sheet error message | 21 Mar 2006 14:18 GMT | 1 |
I am trying to copy a sheet in a worksheet but keep getting message that the name is already used as a formula or range. I cannot find this. And worse, It puts me into a loop and I have to finaly shut the program down to get out of it.
|
| Data to transfer from column to row | 21 Mar 2006 13:59 GMT | 2 |
I have a cell that contains like: PM-1234, PM-2345, PM-5689, PM-9999. I want to segregate these 4 tag into rows. i.e.,
|
| Function TTEst in Excel | 21 Mar 2006 13:51 GMT | 1 |
I need write function TTEst in my own program, which return value same TTEst in MSExcel. I try use code from: http://www.public.iastate.edu/~jessie/PPB/Stats/Testing%20loads.htm
|
| Need help with copy if | 21 Mar 2006 10:54 GMT | 6 |
What I am trying to do is copy column A-D from "scheduled" worksheet t "test" worksheet if column X has an "X" in the column. Is thi possible and if so how is it done --
|
| Sub list and rum macros in the function | 21 Mar 2006 09:46 GMT | 1 |
1- I want make a sub list in the excel. I make the dop down list in the cell A1 contain: Eua, Brazil, Ingland, Canada. And i want that in the cell B2 apeard: Texas, Arizona, Florida when in the cell A1 is Eua.
|