| Thread | Last Post | Replies |
|
| See Data behind Pivot Table | 27 Aug 2007 18:04 GMT | 2 |
I have a source sending me reports in Excel Pivot Tables that I don't really want. I need the raw data, and I keep getting Pivot Tables. I've been searching the help files for how to get the Pivot Tables off so I can see the data behind them, and I'll I'm finding is ...
|
| Excel 2003 Using the keyboard | 27 Aug 2007 18:02 GMT | 13 |
I need to use the keyboard in Excel rather than the mouse for health reasons. Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a ...
|
| Insert New row if Column G = "P" | 27 Aug 2007 18:00 GMT | 1 |
I can't seem to get this, but if I wanted to run a macro that would start at cell G50 and move upward to Cell G18 testing for the
|
| How do you get outlook to select from list on a form | 27 Aug 2007 17:54 GMT | 1 |
I want to send an email to a group of people from a listbox that has been populated from selecting from another listbox (and sheet). How does outlook take the new list and send the form or sheet to the people in the selected box?
|
| Help?! Format Cells for ALL CAPS | 27 Aug 2007 17:42 GMT | 1 |
I am setting up a template and need to format some cells/columns to come in all caps for State abreavations. I expected to find the all caps option in the format text menu but did not. The only info I've found gives me a formula to pull in text from another cell and make it ...
|
| Circular Reference | 27 Aug 2007 17:22 GMT | 2 |
I am working on an inventory spreadsheet. I am trying to get a total for each item in a separate column. Each item has multiple rows due to the number of locations. The formula I have tried to use =IF(A2=A3,V3=V2+U3,V3=U3) does not work. (A is my item number column, U is my ...
|
| tough cookie | 27 Aug 2007 17:17 GMT | 3 |
I have readings (hourmeters of water pumps) in random days. In column A i have all days of the year, which means i have holes in my table. column B has the hours when the readings were made and column C has the readings. In column D i have the reading of a certain day minus the ...
|
| Adding Dashes to a 25 digit alphanumeric cell | 27 Aug 2007 17:02 GMT | 7 |
I have a column of 30-5k consisting of a 25 digit alphanumeric code. I need to reformat these to have dashes every 5 characters. example: XXXXXXXXXXXXXXXXXXXXXXXXXX to
|
| Excel background gridlines on worksheet-how do I remove from view | 27 Aug 2007 16:53 GMT | 8 |
How do I get rid of the gridlines that appear automatically upon opening worksheet?
|
| Excel graph legend | 27 Aug 2007 16:52 GMT | 2 |
In Excel 2003 I have created a graph with a legend for 3 x data series but inadvertently deleted the legend for one of them. I have looked everywhere - how can I reinsert this?
|
| linear adjustment in excel | 27 Aug 2007 16:50 GMT | 3 |
I am trying to take a set of columns of numbers and adjust them so they are all the same length. I.e., i have data that looks like 1 0.2454
|
| Daily Averages | 27 Aug 2007 16:44 GMT | 3 |
I would like to have a column with daily averages. Per example, In C25 i have "x" and in C27 i have 30. So, in both D26 and D27, i want 30/2. Because i had 30 in two days interval. B C D
|
| Need Excel formula to separate names into columns, with exceptions | 27 Aug 2007 16:31 GMT | 4 |
I'm hoping this is possible.. What I have is a name column like this: ANTHONY D DE ROSE EDUARDA J DE SOSA
|
| FREQUENCY function clarification | 27 Aug 2007 16:16 GMT | 2 |
Can someone please clarify the difference between the two arrays you need for a FREQUENCY function? Thanks
|
| Re: H E L P * * * Need help with question about protecting a range of cell in workbook | 27 Aug 2007 16:13 GMT | 1 |
I need to know how to protect a range of cell/s in a workbook
|