| Thread | Last Post | Replies |
|
| Multiple Sheets Ceates Folder of Sheets & XML File? | 27 Jul 2006 07:53 GMT | 2 |
Since installing MS Office 2003 last year I have noticed different behavior with working on multiple sheets. First, every new sheet I open or create causes a new instance of Excel to open. Standard Excel 2003 behavior? Or do I have something
|
| Help: Formula put into entire row creates large file size | 27 Jul 2006 01:19 GMT | 1 |
I have a spreadsheet where I would like one column to be the concatenation of two other columns. For example, in column C I would have =A1&B1. This excel file will be given to people and they will fill in values
|
| Multiple Row to columns | 27 Jul 2006 00:25 GMT | 1 |
I know this seems so simple...maybe I'm now frustrated due to looking at the computer screen all day. I am formulating an excel sheet as my data base to create mail merge. The website that I have gotten the information from pastes to the excel sheet as such:
|
| locking a row? | 26 Jul 2006 23:36 GMT | 2 |
Running Excel 97 SR-1 and have forgotten what you call locking a row in a sheet so that it stays in view and you can see the names of each column. How do you do it also? Thank you, Steve T
|
| Is there a way to paste special --> Transpose and delete blanks? | 26 Jul 2006 23:23 GMT | 1 |
Is there a way to paste special --> Transpose and delete blanks for a group of data? i.e. A
|
| Having Problem with Select Case | 26 Jul 2006 23:11 GMT | 2 |
Hi -- This is my situation: I have a list box from which users can choose the report that they want to print. The code works just fine when I use an "If-Then-Else" construct but not so when it is transferred to "Select Case". Here is a snippet from both:
|
| Exporting a toolbar | 26 Jul 2006 23:09 GMT | 1 |
Excel 2003 I've created a personal toolbar, which includes specific canned command buttons, as well as about six "designer" buttons which I created to activate several formatting macros.
|
| Subscript out of range error? | 26 Jul 2006 22:19 GMT | 1 |
I keep getting a subscript out of range error with this macro. Any help would be great. Public Sub AddSheetToEnd() 'Create a new sheet
|
| Insert a standard row through VBA | 26 Jul 2006 22:06 GMT | 1 |
Who is able to help? I try to make a piece of VB-coding for copying and pasting lines, but I cannot manage to hold the line-number in memory. This is the case:
|
| Range summing | 26 Jul 2006 21:33 GMT | 1 |
hello, when I copy and paste a formula instead of having it go like SUM(A1:A3) SUM(A2:A4) I want it to go
|
| Exacting the fractional | 26 Jul 2006 21:25 GMT | 3 |
How do you extract the fraction out of column A and put the fractiona in column B... example A B
|
| how do I make more then one line of pasted text not move to one cell? | 26 Jul 2006 20:22 GMT | 9 |
Hello. How do I make one block of text I pasted not go in to 2 cells and if I want to merge those 2 cells together in to one cell let's say merge 5d in to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this possible with the keyboard? Thanks.
|
| niet zichtbaar van afbeelding e.d. helppppp | 26 Jul 2006 19:55 GMT | 7 |
Als ik een afbeelding plaats in excel is die niet zichbaar op het beeldscherm wel als ik de pagina afdruk met de printer, dit geld ook als ik een pijl teken in de pagina.
|
| Comparing Column B to Column A | 26 Jul 2006 19:06 GMT | 3 |
Ok... say I have like 1,000 records on column A and column B ..is there a way to write a formula say... going down column B and compare to column A and tell me which number or char. is not in colum A but is in column B ..or vice versa ..
|
| Removing dead Link | 26 Jul 2006 18:55 GMT | 3 |
I've got my own *simple* problem Somehow my workbook thinks there is a link to temporary sheet I was using. I can't work out a way to get rid of *the link* Edit Links - tells me the file (which has gone), but won't let me delete
|