| Thread | Last Post | Replies |
|
| how to set tab spaces in excel? | 26 Jan 2008 23:32 GMT | 5 |
Some one has changed the tab spacing on my computer so now it jumps from A to G, how do I get it back to moving one cell at a time?
|
| VLookup with criteria and delete row | 26 Jan 2008 21:29 GMT | 5 |
What is the best code to use to look for a name ( col A) and delete the whole row.
 Signature capt
|
| Protection | 26 Jan 2008 20:48 GMT | 1 |
We have several spreadsheets that feed into a report. Is there any way to protect the sheets to allow data entry but not allow to insert extra lines?
|
| Copy a file remotely | 26 Jan 2008 20:20 GMT | 1 |
I want to copy a file from one folder to another in VBA. Normally I would open the file and then use savesas, but the file is a csv and you cannot open in excel. So is there a way to just copy the file?
|
| Not detecting Open Workbook - Why | 26 Jan 2008 20:16 GMT | 7 |
I've written a application to write data from one workbook to another. Before the workbook actually writes to the other workbook, I'm looking for the workbook to alert me if the Second Workbook is already open. In the event it is, I do not want it to run the rest of the ...
|
| How do I make the gridlines go to the bottom of the page? | 26 Jan 2008 20:12 GMT | 3 |
I am trying to make the gridlines fill the entire page. I am trying to make an inventory sheet for my daughter to fill out. Please help
|
| chart is grayed out | 26 Jan 2008 19:38 GMT | 3 |
I have one spreadsheet where, whenever I am working in cells, the chart turns into a big gray square. If I click anywhere in the chart, it reappears, but then goes back to gray as soon as I click a cell. I have never seen this before. Any ideas about how/why and what I can do ...
|
| Save as csv file option missing from Excel 2007 | 26 Jan 2008 19:12 GMT | 3 |
I want to save an excel file in the csv as this is the format my address program wants for import. BUT, when I go to "save file as" there is no "text file" option, and no csv option under "other formats". I formatted all cells as text, and I deleted all the other sheets in the ...
|
| How do I set caluculations to update automatically? Excel 2007 | 26 Jan 2008 17:57 GMT | 2 |
I have checked in the setup that 'update calculations' is set to automatic ( no need to manual F9) but when I use the spead sheet and amend figures, the sum calculation does not update.
|
| Excel 2007 | 26 Jan 2008 17:56 GMT | 4 |
How do I set the calculations to update automatically? I have checked the settings have been set to update automatically. (no need for F9)
|
| Group and Outline on a Protected Sheet | 26 Jan 2008 17:06 GMT | 11 |
I have an Excel sheet that I use the Group (Data|Group and Outline|Group) to group certain rows. If I protect that sheet, I would not able to expand or collapse the groups. I tried turn-on various items (and all items) when I protect the sheet, and it still would not let me ...
|
| Merging Spreadsheets and Finding Matches and Exceptions | 26 Jan 2008 15:40 GMT | 3 |
I have two Excel spreadsheets that I wish to merge. One list has about 2600 names, the other about 800. The matching key is "user ID" How do I find the matches between the two spreadsheets and how do I find the exceptions? The fields are basic, first name, last name, used ID, and ...
|
| How do I format text so that when the formula delivers the mixed data, it looks right | 26 Jan 2008 15:39 GMT | 1 |
I'm using one formula to bring data from 2 cells (ranges actually) into one cell. The data is mixed; text with $X.00. When the data is delivered, the number is just an integer, no currency formatting. A B
|
| Form View | 26 Jan 2008 15:18 GMT | 1 |
This is such a cool feature - No print option here, just visual. Has anyone figured out how to print this?
|
| Delete Empty Cell With Formula | 26 Jan 2008 15:02 GMT | 4 |
I need a macro to delete formulas within a cell when the answer to the formula gives an emtpy cell. Any ideas ?
|