| Thread | Last Post | Replies |
|
| Excel help needed! Over my head! | 16 May 2008 17:05 GMT | 1 |
Hoping someone can help me out, would be much appreciated. Here is what I am trying to do: I have several spreadsheets, each with 46,000 rows of data. I need to analyze it in a couple of different ways. I am very strong with Excel,
|
| Sorting other than a-z | 16 May 2008 16:58 GMT | 1 |
I am doing the entries for a sporting event and have completed the entries, but now need to sort them in to the order they will compete but do not wish to sort in alpha order. I have three columns of info i.e. rider, horse, club so I need to keep the information in the rows ...
|
| Excel 07 - text displays as pound signs | 16 May 2008 15:25 GMT | 6 |
OK, I'm not new to Excel, just 07. And this is killing me. I have a user who uses Excel to track discussions of phone interviews, so she's using one cell in which to type her comments. MOST of the time, the text is fine. Randomly, any given cell will suddenly appear as all pound ...
|
| left/right scrolling with mouse wheel | 16 May 2008 14:34 GMT | 2 |
Here's the problem side scrolling is not workign right. 1. split a spreadsheet vertically so you have left and right sides. 2. Pick a cell on the right side and using your mouse wheel side scroll. When my user does this the left split side scrolls, not the right one where
|
| Excel XP - Diagonal line in a cell | 16 May 2008 12:50 GMT | 2 |
How do I create a diagonal line separating "Day" and "Time" in a cell?
|
| Paste special shortcut | 16 May 2008 12:24 GMT | 5 |
I read posts concerning paste special shortcut, but I do not know how to do this: I would like to assign a shortcut (lets say ctrl + m) to opening of paste special dialog box.
|
| Merge and Centre | 16 May 2008 11:45 GMT | 1 |
This is my sheet SLR NO. NAME POINTS REDEEM POINTS TOTAL 001 HARDEEP 4500.00
|
| How can I show hour values in a diagram | 16 May 2008 10:58 GMT | 1 |
How can I show hourly values in a diagram – now the minimum resolution seems to be day
|
| Building reports in Excel, for data being entered in Multiple Workbooks by Multiple users | 16 May 2008 10:39 GMT | 3 |
Hello - I have a group of nurses that keep a lot of patient data in standard excel workbooks. I need to pull reports based on that data on a weekly, monthly, and sometimes daily basis. For now, I have been having them send me the data, and then I copy it
|
| excel 2000-split a cell or a column or a row without transferring | 16 May 2008 09:49 GMT | 1 |
Top row is all merged. Underneath is a row consisiting of several groups of merged cells, each of which is acting as a heading for the columns underneath. How to insert more blank columns underneath each heading? Thanks
|
| bar graphs that are have bars joined together | 16 May 2008 08:17 GMT | 4 |
I just cannot seem to get this to happen. Instead of a space between each piece of data I want the bar to look more solid in connection. I have hours in 15 minute incements over a 24 hour period eg.A2:10, and say the date in B1.
|
| Conditional formatting in Excel 2007 | 16 May 2008 05:08 GMT | 3 |
i have a worksheet with a list of prospects. I want the row to be conditionally formatted when a change one cell to "quote". i can get that particular cell to change, but i want it for the whole row! Can anyone help?
|
| Extracting the data according the number of cell (at specific range) | 16 May 2008 04:57 GMT | 3 |
I have a minor Excel formula problem. In my example has following data, cell A5 shows "apple", A6 shows "salt", A7 shows "sugar" and A8 shows "fish". On another hand, cell B3 is the "criteria" data showing 3. My question is to form an Excel formula which can
|
| Option Buttons/Radio Buttons | 16 May 2008 03:51 GMT | 7 |
I run Excel 2000 I have 2 option buttons in each row (total of 20 rows) I would like the only one of the 2 buttons in each row are on or off. The problem I am having is that it dosent matter which button on which row I
|
| Print comment | 16 May 2008 03:47 GMT | 1 |
Is it possible to print out the Comment? There is no option in Print dialog box to print comment Regards,
|