| Thread | Last Post | Replies |
|
| Replacing a comma ( ,) with a new row | 25 Jul 2006 15:47 GMT | 1 |
Hellol everyone, I have being working ont this spread sheet for a long time because my work requires that I incert a number in a single cell in a new row. But some of the cells containt hundreds of numbers separated with a comma and this makes my life hell.
|
| access query reports to excel formatting help | 25 Jul 2006 15:45 GMT | 1 |
hi. i am really very new in excel programming. i did not even knew that we can do some programming in Excel until last week when i came up with a problem. i hope you guys can help me out. but first let me tell you i dont have no clue about programming in excel. so treat me like a ...
|
| absolute formula in Excel | 25 Jul 2006 15:34 GMT | 3 |
we need to use absolute formula in most cells, the way that we know is that use the normal formula and then add $ sign before cell ref. It is a nightmare to correct all cells manually. is there any way to make it fix?
|
| Format size of finished sheet? | 25 Jul 2006 14:31 GMT | 6 |
An error with IE when I tried to post (hopefully this will not be a double post) I have created a sheet in Excel 2007 (beta) I would like to save the sheet without the extra cells/rows etc I deleted pages 2&3 but can't remove the
|
| Workbook linking | 25 Jul 2006 14:24 GMT | 1 |
Is there any way of linking individual worksheets in a workbook to separate workbooks so that they will automatically update? Just cutting and pasting messes up the formatting and loses the charts. Thanks
|
| Help | 25 Jul 2006 13:55 GMT | 2 |
In column (I) I have cost centres, which range from 2001 to 2042 and in column (H) I have the number of days taken for payment. In cell AA4 and I want to return all payments over 5 days belonging to cost centres 2033,2036,2037 & 2041.
|
| Help on Lookup | 25 Jul 2006 13:47 GMT | 4 |
I have a spreadsheet that contains two worksheets (a & b). In worksheet b (which is hidden) all of the data is kept for a test that is run each day. (user form is used for data entry). from this data, a total is calculated (nothing serious, just =sum function).
|
| Which trend line? | 25 Jul 2006 13:32 GMT | 1 |
I need to interpolate some data points. But I am not sure which kind of trend line should I draw? There appears to be many different kind.. I do not need a super fanciful one. My main purpose is really to find the
|
| Message Box On One Sheet Only | 25 Jul 2006 13:20 GMT | 3 |
I have a large spreadsheet with multiple worksheets in it. When one specific worksheet is selected (it does the calculations used on the other pages) I would like a pop-up text box to appear warning the user not to print it.
|
| Transposing problem - please help if you can | 25 Jul 2006 12:27 GMT | 2 |
Hello, I have been puzzling over this for some time now and am sure a seasoned excel person will have a solution. ----------------------------------------------------------------- First let me explain the spreadsheet.
|
| Eliminate 0 values from pivot table | 25 Jul 2006 10:37 GMT | 1 |
I have a stock detail sheet where I have a line for all stock transactions. Basically they are organized as SKU (stock codes), LOT (lot number) and UNITS (+/- incoming/outgoing). This sheet is summarized in a pivot table.
|
| How to generate all possible combos, and combine fields... | 25 Jul 2006 07:44 GMT | 12 |
We need to generate all possible name combinations using, which for now includes 10 first names, 26 middle initials (a-z), and 10 last names...ie 2,600 total names- with no dupes.. If we start with the 10 first names in column/field 1 and the 26
|
| I'm in need of some help to create Excel Speadsheet | 25 Jul 2006 06:08 GMT | 7 |
I'm hoping someone can point me into the proper direction: I have a customer who has been using the LABELS template in MS Word to keep a list of customers. The list is over 3,000 Names and addresses.
|
| Show parentheses in Accounting Format | 25 Jul 2006 05:42 GMT | 4 |
I have Excel 2002 (XP) and want to display negative numbers in parentheses in ACCOUNTING FORMAT instead of with a minus sign. I know this is possible as a standard feature (I have done it before on a previous machine) and I think there was a KB patch for this flaw. Anyone know ...
|
| Excel Tool Bars | 25 Jul 2006 04:58 GMT | 4 |
Lately, when I open Excel, the top Excel name bar and the bottom tool bar are not on the screen. It appears that the worksheet is too large to be contained on the screen.
|