| Thread | Last Post | Replies |
|
| making a buget | 25 Feb 2008 19:44 GMT | 2 |
when I recieve a bill I want to enter the bill in my budget lets say in A1 then when I pay it I would like to put an X in B1 and would like the number in A1 to copy to C1 showing it was paid
|
| Top X% in Pivot Tables | 25 Feb 2008 19:41 GMT | 1 |
I created a Pivot Table and want to display only the Top 20% of Customers. I go to the Pivot Table Field List and open the filtering drop-down list for a field. Then I select "Value Filters". But the only filtering option available is "Top 10"; all other filtering options are ...
|
| How do I make the home key return to the beginning of the row? | 25 Feb 2008 18:43 GMT | 1 |
All of a sudden, when I use my home key, it returns the cursor to the beginning of the worksheet. I need it to go to the beginning of the row. I can't seem to find where to change the function or why did it all of a sudden change. Also when I
|
| Copy and Paste | 25 Feb 2008 18:32 GMT | 3 |
I am trying create a macro at the push of a button to copy data from a certain cell or range of cells and then paste into another cell, however if that cell I am pasting into has data in it I want it to go down 3 cells and paste it, and so on and so on. I would imagine using the ...
|
| format number | 25 Feb 2008 18:29 GMT | 4 |
Is is possible to format cells to drop the last digit of a number yet keep the value? If I have a cell that contains 220, I want the cell to display 22, yet I want to be able to chart the value of 220.
|
| How do you turn off the Autofill Options box when dragging cells. | 25 Feb 2008 17:55 GMT | 1 |
After I do a 'drag to copy' the Autofill Options box appears and is always in the way for my next 'drag to copy'. I have to click a blank cell off to the side and hit the space bar to get it to turn off (temporarily).
|
| Can a "what if" statement be used to insert cells? | 25 Feb 2008 17:30 GMT | 3 |
I have side by side reports of thousands of lines of similar data. There may be multiple lines pertaining to the same id#--one side may have 3 transactions for an id#, where the other may have 4, causing me to need to bump the cells down on one side to keep matching id#s lined up ...
|
| PLEASE HELP | 25 Feb 2008 17:29 GMT | 1 |
I am trying create a macro to copy data from a certain cell or range of cells and then paste into another cell, however if that cell I am pasting into has data in it I want it to go down 3 cells and paste it, and so on and so on. I would imagine using the loop function would
|
| short date format not working while i try to excel afte | 25 Feb 2008 17:17 GMT | 1 |
I want to get the result as 2-Feb after typing 25/2 in excel after i login on my domain. I can get the result in local admin login. Why?
|
| Streamlining sort | 25 Feb 2008 17:10 GMT | 6 |
I have 2 reports (approx 8000 lines) with similar data that I need to match up and find differences in. I copy and paste them side by side onto one sheet (1 has 5 columns--the other has 12). I insert columns with formulas to find the differences between the items that should be ...
|
| Access/Excel | 25 Feb 2008 16:55 GMT | 1 |
How do I open an Excel workbook from an Access switchboard?
|
| Text Thread "Return" Without Leaving the Cell | 25 Feb 2008 16:31 GMT | 1 |
This has to be simple, but how do you "return" at the end of a line of text without the Enter key taking you to the cell below? I'd like to have: Point 1..................
|
| Opening and reading a higher version of Excel | 25 Feb 2008 14:41 GMT | 2 |
How can I open and read a higher version of Excel? Do need to update my version? I have Windows ME and really need some help. Thanks.
|
| Clear zeros from a graphic | 25 Feb 2008 14:27 GMT | 4 |
I have built a graphic with some data that comes from a condition. When a condition is true I dont want to have any value in the graphic but the if() condition writes a zero in the cell and the graphic display a zero instead of nothing.
|
| merge formulas? | 25 Feb 2008 14:20 GMT | 2 |
I have a particularly tricky function that I'm troubleshooting by splitting the parts into different cells. I have the various cells adding up correctly, but still i have a typo or some problem in the original cell formula.
|