| Thread | Last Post | Replies |
|
| pdf file to excel | 30 Jul 2004 00:02 GMT | 1 |
i have an .rpt file converted to pdf. its in the form of rows an columns. can i use this in excel... i trie the usual methods.. but cudnt conver it....
|
| spreadsheet vanishes | 29 Jul 2004 23:59 GMT | 3 |
I open an excel 2k spreadsheet. it says the spreadsheet oopens but nothing is there? any ideas? In the status bar it says that the spreadsheet is open but it is just a grey screen
|
| Simple Formula to delete every other row | 29 Jul 2004 23:45 GMT | 3 |
Is there a simple formula that will allow me to delete every other row? any help would be appreciated
|
| Removing Spaces from Text | 29 Jul 2004 23:41 GMT | 2 |
Hi Dave, That was the first thing I did! However, it doesn't seem to work when the first character is a space (and maybe if all the other characters following the space are numbers).
|
| Creating a Custom Toolbar/Menu unique to a Workbood | 29 Jul 2004 23:02 GMT | 2 |
I have been trying for about a week to create a toolbar for use by a particular workbook and that workbook alone. Creating the toolbar was no problem and I named it 'Budget Toolbar.' It contains a very limited set of the 'normal' Excel objects such as File Save As and a few ...
|
| removing ALT+enter characters from a column | 29 Jul 2004 21:31 GMT | 3 |
I frequently get speadsheets sent to me which have had text entered int cells that has been separated by the "ALT + Enter" keys to force it ont a separate line. Does anyone know of a way I can remove thi automatically and add a comma & space character instead (perhaps with
|
| AutoSave Locking up excel | 29 Jul 2004 18:56 GMT | 2 |
We have an employee who does a lot of work with 2MB+ excel files, and he often has 3 to 4 open at a time, and excel is going into autosave when he has these files open and completely locking up the files. The PC being used is
|
| using a cell reference in another cell inside min function | 29 Jul 2004 17:42 GMT | 1 |
I have a cell reference generated by the vlookup function that I want to use inside the min function. Is there a way to do the following: min(b19:the value of another cell(which is a cell reference))? Any ideas?
|
| Toggle? | 29 Jul 2004 17:36 GMT | 2 |
Is there a keyboard shortcut to toggle between display formulas and the text view? Thanks.
|
| Concatenate | 29 Jul 2004 16:28 GMT | 3 |
Anyone able to write/instruct the formula for: I have lets say 30 rows with internet: which I want to associate wit the next row which have user names in them. So for example row A has internet: and row B is jbowman@glenbow.org an
|
| Is there away around an imported reports funky layout? | 29 Jul 2004 16:23 GMT | 3 |
What I have happening is this: I am converting a text report to a excel worksheet (done automatically,). The report USUALLY follows th same pattern.... 78..06..texttexttext.....0.....0.....0
|
| Protect my work | 29 Jul 2004 15:06 GMT | 3 |
Please can you help I have some accounts that I want to protect from being opened, I have a folder marked Accounts in that there is an icon for Excel worksheet is there a way if someone clicks that they are asked for a password before
|
| Excel VBA | 29 Jul 2004 14:49 GMT | 4 |
Bonjour, Je croyais que chaque fois que l'on lançait une proc du type Private Sub, toutes les variables étaient remises a zéro. apparemment il n'en n'est rien
|
| output Webform to existing spreadsheet | 29 Jul 2004 13:56 GMT | 2 |
I am thinking, or hoping rather there is a way to do this. I want to put up a webform that has 7 input fields. When the user inputs teh data into those fields and clicks submit, they will populate the same 7 fields in an excel spreadsheet that is pre-exisintg. DO I need to do this ...
|
| Excel 2003 Bug with Hiding all unused Rows/Columns? | 29 Jul 2004 13:36 GMT | 2 |
Running Office 2003 on XP SP1... If I have a simple spreadsheet that goes from A1 to K20 (small) and I want it to look neat - I hide all the other columns and rows in the spreadsheet. The problem is that when I do that - there is an
|