| Thread | Last Post | Replies |
|
| how to find out two offsetting nubmer in one column? | 20 Aug 2007 21:26 GMT | 1 |
In one column, there are over 500 data, how could I find out two numbers that offset each other. Thanks!
|
| How to insert a photo in the background for printing. | 20 Aug 2007 21:24 GMT | 1 |
I need it in the background see through and what not. I can insert the image easily. right click. send to back but that doesnt work... what do i do now?
|
| how to put a line between each group? | 20 Aug 2007 21:16 GMT | 6 |
My file has over 1000 lines by sku & customr, I need to add line between each sku group. This is a data file, I don't want to pivot table to add line, instead of manually add line between each sku, does excel have a formular to add line?
|
| How do I add a currency symbol | 20 Aug 2007 21:14 GMT | 2 |
I want to add the dollar format (U$S) to the currency symbols so that It doesn`t appear as text
|
| How to auto-select within a macro | 20 Aug 2007 20:54 GMT | 5 |
Hello, I recorded the following simple macro to check for a problem in some columns on a worksheet I'm working on daily. Selection.Replace What:=".988", Replacement:=".99", LookAt:=xlPart, _
|
| Row functions | 20 Aug 2007 20:28 GMT | 3 |
I am very new to excel, so this question may be simple. How do I set up a formula for an entire row, were the computer will divide the numbers in each cell by (ex: 93), and then multiply. Thanks
|
| Are there current issues with Excel attachments? | 20 Aug 2007 20:26 GMT | 2 |
A co-worker sent me an e-mail with an Excel attachment. I can open it , but others cannot. What would cause this?
|
| Format CONCATENATE | 20 Aug 2007 20:24 GMT | 3 |
i am trying to format the result of a concatenate equation so that it may have 2 decimal places. There is no trouble with the function itself just formatting. the equation is:
|
| Excel - Column headings | 20 Aug 2007 20:23 GMT | 1 |
My column headings are numbers instead of letters. How do I change it back to letters? I am on Excel 2002.
|
| Customer name-do you use 1 column (name all together) or 3(frst,m. | 20 Aug 2007 20:16 GMT | 2 |
I'm a bit new to this discussion group, so please forgive me for any errors. I have an unusual question for everyone in the community. I am working on designing a customer list spreadsheet and one of the things that crossed my mind was the way in which we enter a customer's ...
|
| Nested IF fn Alternative | 20 Aug 2007 20:16 GMT | 6 |
I am trying to string together IF functions to fulfill my requirements. However if i need more than 7 conditions (from my understanding the nested IF functions only go up to 7 cases) is there an alternative to this that would give me the same results? Thanks
|
| Merged my cells... now how do I get bulletpoints? | 20 Aug 2007 20:16 GMT | 1 |
Trying to make an order sheet for my company. I merged my cells to make 3 large columns for information. But how do I bullet that information???
|
| Copy range in macro using paste special values | 20 Aug 2007 20:12 GMT | 2 |
I have always copied a range by using the select cell. But then I learned a really easy way to do this with Set Set Rng1 = Sheets("... Set Rng2 = Sheets("...
|
| where are the recently viewed items in office 2007? | 20 Aug 2007 20:11 GMT | 1 |
One of the features I used in office products was the recently used history that was often under the file menu dropdown. Where did that go?? I am so frustrated that I haven't my menu bar anymore and have to add stuff - then I don't get my history so the most recently opened ...
|
| macro to copy from excel range to word doc | 20 Aug 2007 19:54 GMT | 1 |
Thanks to macropod and others, i cobbled together the following code to copy a specific range from a set of excel files to a specific word document. The problem i have, is how to insert a paragraph break in word in between each of the excel ranges after they are pasted into word ...
|