| Thread | Last Post | Replies |
|
| How do you force excel to save on close | 21 Sep 2006 10:55 GMT | 3 |
Having trouble with an excel user not saving an excel document even if she is prompted to. Is there anyway you can set an excel file up to save as its closed.
|
| Cell Formatting | 21 Sep 2006 10:40 GMT | 3 |
I'd like to format a cell (C15 for example), so that whenever I enter a name (e.g. "John Smith"), it is automatically converted to "Mr. John Smith". How can I do that in Excel?
|
| how come microsoft wont let me type? it's telling me is locked | 21 Sep 2006 09:30 GMT | 1 |
i go to type under microsoft word or exel and it wont let me. it tells me " the modification is not allowed because the document is locked". my question is how do i unlock it
|
| macro in toolbar | 21 Sep 2006 08:25 GMT | 1 |
i managed to attach a macro to the print button. now, no matter what workbook im in, it looks for that same macro to run. how do i remove the macro link and reset the print button to print? jat
|
| right click does not work to tabs | 21 Sep 2006 08:24 GMT | 2 |
up until last week, the right click used to work on the tabs along the bottom. now when i try to right click on the tab, nothing happens. the mouse works everywhere else, except on the tabs. issue exists in all areas (new workbook, old workbook/sheet)
|
| How to use macro to edit data in Excel cells | 21 Sep 2006 07:44 GMT | 11 |
I use macros by recording, not familiar with Visual Basics. I want to edit the cell content of similar cells . When I run the macro on other cells it takes the information from the very first cell and keeps repeating the info on the first cell. What is wrong?
|
| Filter | 21 Sep 2006 07:37 GMT | 6 |
I have huge data. Column A has Customer ID. Data here is not repeated untill next change in Customer ID. Column B have Invoice Nos. There are many rows for 1 customer ID.
|
| page break doesn't work. Help is no help. Help? | 21 Sep 2006 06:42 GMT | 1 |
In Excel, the page break function does not work. Help is no help. Nothing I try works. Any suggestions?
|
| Concatenation 2 Texts | 21 Sep 2006 06:16 GMT | 8 |
Suppose I have two Texts: "Text1" in A1 and "Text2" in C1. I want to make a concatenation of A1 and C1 in cell C3, and make the font of "Text1" bold, but not "Text2". Is there a way to do this in Excel?
|
| batch delete | 21 Sep 2006 04:01 GMT | 1 |
I have a file of about 10,000 lines that I down load each week. this file contains SKU numbers I have a list of about 1,000 sku numbers in another file that have to be deleted out of that big file each week before the big file can be used. is there a way to run a batch delete ...
|
| count | 21 Sep 2006 03:58 GMT | 16 |
how would you count everyother cell?
|
| Concatenating % | 21 Sep 2006 03:49 GMT | 2 |
I have two cells, showing a value of 5.25% and 6.75%. I need it to show 5.25%/6.75%. The problem is, the numbers will change. If I use the concatenate function, it comes out as 0.528/0.0675.
|
| change event on specific cell rather than worksheet | 21 Sep 2006 03:37 GMT | 10 |
Good morning. I have an in cell drop down list of vendors that another in cell drop down list of part numbers relates to. I have it set so that only part numbers that belong with a chosen vendor appear. The problem that I have is that if
|
| Rounding | 21 Sep 2006 03:30 GMT | 5 |
Let me try this again since I did a poor job explaining the first post. I am working on a price list. I am allowed to round up to the next nickel if the price is not on the nickel. So if the price is $1.60 or $1.65 it is ok. But if the price is showing on the list at $1.61, I ...
|
| countif question | 21 Sep 2006 03:27 GMT | 3 |
I have a table that shows various interest rates ranges, which is linked to a data sheet. 5.25% to 5.52% 5.53% to 5.77%
|