| Thread | Last Post | Replies |
|
| how do I change column width in the middle of an Excel sheet? | 16 May 2008 15:36 GMT | 4 |
Is it possible to change the widths of columns from a certain row down in an Excel worksheet?
|
| monthly opening and closing balance in pivot table | 16 May 2008 15:33 GMT | 4 |
have a pivot table that gives a bank statement: 1-apr opening bal 5000 dr 2-apr withdrew cash 2000 cr 3-apr chq to creditor 1000 cr
|
| Logical statement for 'contains' ? | 16 May 2008 15:33 GMT | 1 |
Is there a logical statement to return 'True' if one cell contains the contents of another (and maybe more). E.g. Cell 1 = 12345
|
| Automatic Display of ApproveIt Menu upon Excel Opening | 16 May 2008 15:30 GMT | 2 |
How do I eliminate the ApproveIt Menu from automatically appearing every time I open Excel?
 Signature Bonnie
|
| Can u add cells in Excel without pressing "shift +" one by one? | 16 May 2008 15:27 GMT | 1 |
I'm trying add a bunch of cells together, but it seems I have to press "shift +" everytime inbetween selecting cells. Is there an easier way to do this? When I DO try to select a bunch of cells (from top to bottom) in a column - it puts colons between the cell numbers ":" - does ...
|
| More Page Setup | 16 May 2008 15:18 GMT | 2 |
Same situation, next level: is there a way to 'save' the setup so that I can apply it to the read-only file each time I view/print it? I especially like to add date/time and my initials, but I realize I can't set that up in the 'master'.
|
| Conditional Values | 16 May 2008 15:15 GMT | 1 |
I am trying to figure a way to make the following happen: I have a list box in cell A1. If the person chooses say "car" from the list in A1 I want the value of cell B2 to be a formula such as =(2*c2). If the person chooses any other value from the list in A1 I want them to be ...
|
| Adding more information to a column of cells? | 16 May 2008 15:13 GMT | 2 |
Is it possible to add more to a cell? For example, I have one column of cells numbering from 1 to 10. I want to add a prefix or suffix to the number therefore I get: 1rabbit
|
| Vlookup or Index/Match | 16 May 2008 15:12 GMT | 3 |
I have a worksheet of data (cells named PV_Data), extracted from a d/ b, column A contains a "week commencing" date (cells named "Week_Of") and column B contains a list of names (cells named "Resources"). I have a second worksheet that I am trying to populate based upon the
|
| Selected cells do not show animated border | 16 May 2008 14:52 GMT | 5 |
When selecting non adjacent cells with CTRL button and cursor the cells are not being highlighted with flashing dashes like they used to. where can I look to turn this feature back on?
|
| Results into one cell | 16 May 2008 14:47 GMT | 1 |
I am trying to put the results of 3 cells into one cell. Here's what I am trying to do: e7 will equal either "" or 30, f7 will equal either"" or 36 and g7 will equal "" or 48. When any one of the cells has the appropiate number in it, 30, 36, or 48 the other two cells will be
|
| Is graphs goal seek still available in Excel 2007? | 16 May 2008 14:43 GMT | 1 |
If it is I can't find it! I can use goal seek on the source data, but I would like to use it within graphs as well.
|
| Chrt Line formats | 16 May 2008 14:39 GMT | 2 |
I have a monthly report, in which I bring in information from different work books. In the compiled workbook, I have quite a few charts in which I like to show lines with a certain format that is consistent across the sheets. e.g., line 1 is aways solid blue with solid blue ...
|
| Excel fails on Save/Save As | 16 May 2008 14:36 GMT | 11 |
I have an Excel application that I took over writing from another programmer who left the company. It's a full app -- not just a bunch of spreadsheets. Excel will frequently fail on a Save or Save As. So I go back to the
|
| How to show the figure of the filtered records ? | 16 May 2008 14:34 GMT | 1 |
Sometimes the total number of filtered records can show in left hand corner of the Excel spreadsheet but sometimes it just show the word "Filter Mode"
|