| Thread | Last Post | Replies |
|
| convert to GBP - formula to identify 1st character and Acc type | 22 May 2008 15:27 GMT | 2 |
I have data in 16 columns with the header in the first row in Excel. The information is ODBC from Access. Currently there are about 45,000 rows of information. Col A has the account no. - for UK accounts it consist of 5 digits (e.g.
|
| SHIFT + CONTROL + DOWN ARROW is not working! | 22 May 2008 15:19 GMT | 1 |
I have Excel 2007 and I was playing with the options, and now I can't use the shift + control + right arrows (or down arrow) commands. It's extremly annoying not been able to use that. Please how do I fix that?? Thank you so much!!
|
| import filenames | 22 May 2008 14:48 GMT | 2 |
I have a hell of work updating the list of filenames located in one folder. The folder contains different file name ext. The files stored in this folder increased every week. Can I do importing the filenames and filedates to excel ?How?
|
| Can I change the default cell selection highlight colour | 22 May 2008 14:33 GMT | 2 |
When you select a range of cells in Excel, they are highlighted in light grey. Can I change this colour? I have Office 2007 SP1
|
| How can I restore a previous version of an excel document? | 22 May 2008 14:23 GMT | 3 |
I accidentally deleted a column in the excel program and saved the document. Now I cannot get that data back. Is there a way to retore a previous version of my document?
|
| Combining a string of text | 22 May 2008 14:22 GMT | 3 |
I want to combine a string of text from several cells. I can do this however the format of the text needs to be different. Example. I have "New Loan Application" in cell A1 and it is in Calisto MT size 9 font. In cell B1 I have "to be submited in" also in Calisto MT size 9 font. ...
|
| 2007 Compatability Pack for Office 2003 | 22 May 2008 14:19 GMT | 1 |
If I use the 2007 Compatabilty Pack on an Excel 2003 Install will this let me open 2007 spreadsheets with more than 65k rows?
|
| error says "file format not valid" | 22 May 2008 14:10 GMT | 1 |
I set up a spreadsheet for a colleague to use, she has now done something to it and it won't open. Help!
|
| Duplicates | 22 May 2008 13:24 GMT | 2 |
my data is on two different sheets in one workbook (sheet1-A1:A200 and sheet2- A1:A1096) . would like to compare the two columns for duplicates and extract to a new sheet or higlight duplicates in order for further detailed analysis.
|
| Formula | 22 May 2008 13:02 GMT | 2 |
I have a download into Excel which contains names, however the full name is in one cell eg Mr J Smith Mrs S Jones
|
| Making a Matrix into a column....... | 22 May 2008 12:01 GMT | 4 |
I have what seems to be an easy problem which I am unable to solve.... I have a matrix, lets say A B C D E F G H
|
| right click on the mouse does not work | 22 May 2008 09:42 GMT | 6 |
My right click button to access shortcuts does not work when clicking on the cells in Excel. I have tried the other ideas listed but they did not work. Does anyone have any other ideas?
|
| average values and reduce and simplify the worksheet | 22 May 2008 08:57 GMT | 2 |
I have a Excel2003 worksheet containing 2 columns and more than 20,000 rows. Column “B” lists the names of objects and column “A” lists the values of repeated measurements for each object. The repeating times of measurement vary from object to object. I will need to average the ...
|
| adding cells upto and including a specified cell | 22 May 2008 08:51 GMT | 6 |
Im trying to work out what formula i can use to sum the figures in row 4 upto and including the specified month in cell b1 and display the result in b6. a b c d e f
|
| Why does screen go blank when saving large files? | 22 May 2008 08:26 GMT | 3 |
My screen often goes blank (turns white except for the bar at the top) when saving large Excel files (4.0 MB). I have checked the CPU usage while the problem is occuring and it is only about 4%. Does anyone know why? Thanks in advance.
|