| Thread | Last Post | Replies |
|
| Printing Excel Sheet | 24 Jan 2008 22:55 GMT | 1 |
I am trying to set a macro to print to a certain printer and to hold it. Is this possible? Thanks, Jay
|
| Macro for protecting and unprotecting multiple worksheets | 24 Jan 2008 22:49 GMT | 7 |
I would say that I am a moderate user of Excel and I need some help with running a Macro. I have a workbook that has about 60 pages in it that several people have access to in order to edit information on each of the sheets. Each sheet has a Vlookup table that I am constantly ...
|
| Dynamic Range in Excel that won't count formulas | 24 Jan 2008 22:47 GMT | 1 |
I have an excel file that I constantly have to update the the ranges for some of my formulas because sometimes the data fills A1:A35 or sometimes can go down to A1:45. There are formulas that pull data from other sheets in cells A1:A45 (if there is data). I would like the
|
| Excel Comments | How to Format many at one time | 24 Jan 2008 22:27 GMT | 1 |
Can I set defaults to comments for them to act in a specific way? For example, I want the default of a comment for the properities to 'Move and Size with Cells' automatically. currently they are defaulted to 'Dont Move and size with cells."
|
| rank of text instead of numbers | 24 Jan 2008 22:17 GMT | 1 |
Is there a function to rank text (really where they stand relative to each other if alphabetized) instead of just numbers where they rank in smallest to largest or largest to smallest? Thanks.
|
| Create an ASCII Fixed Length File from Excel | 24 Jan 2008 21:56 GMT | 3 |
I need to create a fixed length file from an excel file that I have created. Certain columns need to be defined as alpanumeric, decimal, etc. and each field/column needs to have a certain position determined (1-10, 11-11, 12-21, etc.).
|
| Referencing date column A & time column B to get info from column | 24 Jan 2008 21:50 GMT | 1 |
Hello! i have what seems to be a fairly simple task, and I think i'm close, but im not quite there, and I was looking for some advice. I have a spreadsheet I'm working on, and I want to tell Excel to look for the date (such as 1/6/2008) in column A, then i want it to look for the ...
|
| Cross Checking | 24 Jan 2008 21:43 GMT | 1 |
All, Please help me in solving the issue: I was asked to use http://support.microsoft.com/default.aspx?scid=KB;EN-US;q272623&; to add the print directory feature. But now whenver I try to open a folder in the win
|
| Ordering Problem | 24 Jan 2008 21:26 GMT | 4 |
I made a column Index using data from three other colums of the spreadsheet, and put it in outline form, separating them with decimals. (#.#.#) When I sort them in ascending order, I get problems like the example shown below. 1.11.110
|
| CountA problem | 24 Jan 2008 21:22 GMT | 8 |
I am using the formula as shown below, but I want to exclude the letter D or d from the count, any ideas? Thanks
|
| Help! Need A Quick Answer Please! | 24 Jan 2008 21:12 GMT | 1 |
I have a workbook with 2 sheets, all completely formatted, and they are like formats and print areas. My problem is when I pull the thing into Powerpoint as an object, I lose the right hand column. And you know how you can open the workbook and drag the right margin over a tad to ...
|
| List, Filter Sort? | 24 Jan 2008 21:08 GMT | 1 |
Excel 2003 I have sheet (in second TAB, named "Tickets". 300 lines total there are 3 lines of labels there are 295 lines of data (cols A - AP)
|
| Trying to pull data from multiple sheets (and Word docs too) | 24 Jan 2008 21:02 GMT | 1 |
Not sure if this can be done. I have a list of clients in an Excel worksheet, which includes contact name, address, and phone info, but no e-mail addresses. I have several individual order sheets for the same clients in both Excel and Word format that contain e-mail addresses. Is ...
|
| Printing Tabs on one page | 24 Jan 2008 20:59 GMT | 1 |
If I have multiple tabs in my docmument and I want to print the tabs onto the same page instead of each tab being a seperate page how can I do this?
|
| EXCEL: always start edit/replace at FIND WHAT: line | 24 Jan 2008 20:59 GMT | 3 |
Using Excel 2003 SP3. First time I start EXCEL and use EDIT/REPLACE, the cursor sits at the FIND WHAT: line. All other times, the cursor goes to the REPLACE WITH: line. It's illogical to start at the REPLACE WITH: line. How do I force the
|