| Thread | Last Post | Replies |
|
| limited columns and rows number | 20 Dec 2007 19:19 GMT | 2 |
I need to create an Excell document which includse only 7 columns. Is it possible?
|
| Multiple Match and return header | 20 Dec 2007 18:16 GMT | 1 |
I am trying to find a way to Match on multiple values and return the header a row based on that. I have tried looking at combinations of vlookup, match, and index and so far haven't been able to figure out anything that can do what I need. I have a list of data with a
|
| Excel | 20 Dec 2007 17:33 GMT | 2 |
Can I change text in muliple excel files by using the find/replace facility
 Signature Mark g
|
| format cells | 20 Dec 2007 14:59 GMT | 1 |
I have a worksheet that accepts a user input in the range Ac5:ac200 what i want to do is check if a cell has the value "C" in the above range if it does i want to
|
| Comments | 20 Dec 2007 14:40 GMT | 1 |
I have a hundred comments and then I edited the entire spreadsheet and now when I show my comments they are hundreds of rows down. Anyway how can I get them to the right cell? If I hide the comments and run my mouse over the cell the comments they are find, only when I show them ...
|
| Cell colors | 20 Dec 2007 14:28 GMT | 1 |
Why is it when I want to find and replace something in a cell such as one character and make it red, the whole cell is red. Am I doing something wrong or is this just the way Microsoft does it?
|
| Several files opening at the same time | 20 Dec 2007 13:37 GMT | 2 |
I have a shortcut on my Quick Launch bar to a file called Index.xls wherein other hyperlinks take me to a zillion other places as a means of organisation of my computer data. For a couple of months I've been finding that whenever I click Index.xls another file called PERSONAL.XLS ...
|
| REQ: Need Help - Excel 2007 Blank Workbook opens in Compatibility Mode | 20 Dec 2007 13:31 GMT | 1 |
While the help file says it is not possible, a co-worker's Excel 2007 installation is creating new files in Compatibility Mode. We cannot find how to force Excel 2007 to create new files in .xlsx (2007) format. If anyone here has experienced this, what is the fix?
|
| Cursor placement without Macro/VBA | 20 Dec 2007 13:27 GMT | 3 |
I have an Excel file with 5 sheets that I need to email to a large group of people, and would like the cursor to go a specific cell everytime a person clicks on a sheet. Is there a way to do this without using a macro/vba since the email may be blocked becasue the Excel contains ...
|
| Order Sheet Excel Setup | 20 Dec 2007 12:16 GMT | 2 |
I have a basic Excel Spreadsheet which lists items in one column and then their price in another column and then the quantity, it then totals up the row and finally at the bottom totals to rows to give a Full and Final Amount to be charged. This goes out to our customers
|
| Concatenate Funcion Excel 2003 or Excel 2007 | 20 Dec 2007 12:03 GMT | 1 |
I have to concatenate some informations into a single line, these infos are html code and javascript so sometimes I have characters like ' " ; using them into the concatenate function they are interpret like interruptions or break bu they are not, how can I solve it?
|
| 2007 Service Pack 1 (SP1) | 20 Dec 2007 10:58 GMT | 3 |
I don't see the words "Service Pack" listed anywhere here. So, if anyone is interested: Ouch! 619 MB. 2007 Microsoft Office Suite Service Pack 1 (SP1)
|
| Stacked Column gap width | 20 Dec 2007 05:09 GMT | 1 |
I have a stacked column graph and I have set the gap width to 0. There is, however, still space between the stacked columns. The gap looks to be about twice as wide as the column themselves. Any idea why?
|
| Sort worksheets in workbook | 20 Dec 2007 01:19 GMT | 2 |
Let's say you have a number of worksheets within a workbook. Can these be sorted and put in order say alphabetically or any other way? Thanks.
|
| make tabs inaccessable? | 20 Dec 2007 00:16 GMT | 3 |
I am creating a quote template on 1 tab and would like to have my costing on another tab in the same work book so that some cells will fill automatically. How would I keep my customers from seeing my costing on the 2nd tab? Excell 2003
|