| Thread | Last Post | Replies |
|
| missing X in the top right corner | 21 Aug 2007 12:41 GMT | 4 |
I am some how missing the X in the top right corner of my excel sheet. Anyone able to help me...
|
| Drop-Down Lists | 21 Aug 2007 12:20 GMT | 1 |
Hi, I've already created a drop list for each cell in several Columns. Example for Column A is a list that will show all car brands e.g. Volvo, Toyota, Honda. Column B will show the whole list of models e.g Carmy, Altis, Civic,
|
| password in excel files | 21 Aug 2007 10:54 GMT | 2 |
CAN ANY BODY HELP ME IN TO OPEN A PROTECTED EXCEL FILE?
|
| how do i merge sheets | 21 Aug 2007 09:26 GMT | 2 |
I am trying to setup on Excel a link where I can have a Button on Sheet One which when clicked will take the user to Sheet 2, or Sheet 3 etc etc?? I am not sure how to do this, also I want to beable to ensure that if I add amounts into sheet 3 they can be auto added in a main ...
|
| Paste image into cell. | 21 Aug 2007 09:20 GMT | 3 |
I have Office 03 with Win XP Pro SP2. How can I paste a picture into a cell by using the right-click paste option? If I open my pictures then righ-click on one and select copy, then when I try to paste that option is grayed out however I am able to paste into Word.
|
| DIVIDE FORMULA | 21 Aug 2007 08:55 GMT | 2 |
I would like to divide a column of numbers by the sum. However, when I copy/paste the formula throughout the worksheet, I receive errors
|
| Problem with ~ in excel | 21 Aug 2007 08:29 GMT | 1 |
Why is it that when I use ~ in any of the cell in Excel, I can't do Vlookup or any seach function.
|
| command button that copies and pastes from one list box to another | 21 Aug 2007 06:42 GMT | 8 |
I inserted the below code to accomplish the below. Why do I get an error for the i ? Private Sub CommandButton1_Click() If ListBox2.ListIndex = -1 Then Exit Sub
|
| Leading Zero in Hexadecimal? | 21 Aug 2007 03:32 GMT | 5 |
I'm using the DEC2HEX function to convert decimal numbers in cells to hex numbers. For Hex 00 to 09, how do I format the cells so that there is a leading zero?
|
| Add percentage to a whole column of numbers | 21 Aug 2007 03:18 GMT | 1 |
I have found it most difficult to find a simple solution to this question/problem. I need to add a percentage to a column of numbers. For example-
|
| degrees minutes seconds | 21 Aug 2007 03:12 GMT | 2 |
How do I formate a cell or column of cells to handle full angular measurements. eg 359degrees 59' 59.99" Similar to time except the 'hour' would go up to 360 not 24.
|
| How do I do simultaneous AND and OR filtering ? | 21 Aug 2007 02:32 GMT | 3 |
I would like to do a filtering operation that is a combination of an AND command and an OR command. In other words, I have a worksheet consisting of data in say, columns A, B, and C that I am requiring to be greater than zero. In another set of columns in the worksheet, say ...
|
| Ranking without duplicates | 21 Aug 2007 01:47 GMT | 9 |
Sorry to bring this subject up again, but i'm really confused!!! My Example: On a one sheet spread I want to auto sort and rank a list. In A1 to A4 I have the players: John, Bob, Dave, Ian
|
| Subtracting Date/Time | 21 Aug 2007 01:42 GMT | 4 |
I know this has been asked before, but I need a little bit more help. Ok I have this situation: A B C D
|
| Count filled data rows until empty | 21 Aug 2007 00:57 GMT | 6 |
In VBA, how can I count the filled cells in a column until the first empty cell? Thanks for any help, folks. =dman=
|