| Thread | Last Post | Replies |
|
| The active AutoFilter changes property cells (color)? | 14 Apr 2006 06:30 GMT | 2 |
Please, help me with Excel. There is the autofilter (AF) be established on the sheet in 100 columns. It is possible to make on VBA that at use AF a cell in which the
|
| tab bar orientation | 14 Apr 2006 04:59 GMT | 1 |
Is it possible to display the worksheet tabs along the left or right (preferable) margins much like the tabs in a 3 ring binder rather than along the bottom?
|
| Help with Addresses | 13 Apr 2006 22:54 GMT | 8 |
Is this possible and if so how do I go about it. I am typing addresses into fields in excel and I was wondering if I could get excel to fill in the zip code cell once the town cell was typed in?? Somewhere I would tell it what town goes to what zip code??
|
| Moving Chart x Axis | 13 Apr 2006 22:41 GMT | 1 |
How do I move the x axis of a chart? Right now, the chart I am working on has the x axis in the middle of the chart. I would like it at the bottom of the chart.
|
| Excel 2003 crashes when trying ti open a file from the lookdown me | 13 Apr 2006 21:51 GMT | 1 |
Excel opens with no problem but, click on 'File\open' the program hangs.
|
| Highlighted | 13 Apr 2006 21:31 GMT | 5 |
I would like to create a new sheet from an existing sheet, but I only want to see the highlighted rows. Is this possible? Thank you.
|
| Grouping In Pivot Tables | 13 Apr 2006 21:18 GMT | 5 |
I have a pivot table linked direct to an access query. In the pivot table I have grouped the date field by year & month and set the start date as 1 Apr 2005 and end date as 31 Mar 2006. Some of the months have no data so I set the field settings to 'include items with no data' ...
|
| Accounting format | 13 Apr 2006 21:14 GMT | 4 |
I have completed a spreadsheet in accounting format. For transaction that need to be deducted I have entered an '-' thinking that it would be subtracted in the total which is the sum of all the rows, however this does not happen - Double the number is deducted. Does anybody know ...
|
| Array Function Question | 13 Apr 2006 21:09 GMT | 1 |
I have little knowledge of Array Function. I'm updating a spreadsheet developed by someone else. One array formula trying to lookup data in another spreadsheet looks like below: {=SUM(IF([Data]Data!$A$3:$A$70>=DATEVALUE("01/01/2006"),IF(Data]Data!$A$3 ...
|
| Conditional read-only | 13 Apr 2006 20:05 GMT | 2 |
I have a data entry spreadsheet. I want to set the conditional formatting of a series of cells (target cells), such that if a value is entered in a specific cell, no data entry is allowed in the target cells. Any suggestions?
|
| Help: AutoFilter not 'hiding' data from other formulas | 13 Apr 2006 19:29 GMT | 6 |
I'm using AutoFilter on a columns of personal data for which I've set up other calculations (averages, percentiles, etc). I was hoping that if I filtered, say, just for women, then the other calcualtions would reflect only the women's data, but they still seem to reflect the whole
|
| Data Validation from a List | 13 Apr 2006 19:07 GMT | 4 |
I am building a xls sheet for client data entry. For one of the fields, there are a series of choices for which I have a named range in a different sheet. However, I wish the clients to be able to enter ANY value OR the ones from the list..how do I accomplish
|
| Auto Filter | 13 Apr 2006 18:49 GMT | 4 |
In some xls files, when I filter using the auto filter feature, in the lower right hand of the screen I get a message 2 of 300 records (for example) In other xls files, I do not get this message when I apply auto
|
| how do I change the text size of a form check box | 13 Apr 2006 17:28 GMT | 1 |
I am making a large form and I need to know if there is a way to modify the size of text in the check boxes
|
| Cannot get a simple stock price | 13 Apr 2006 16:45 GMT | 2 |
I have a simple spreadsheet in Excel 2002/XP. Column B is a group of stock ticker symbols. I would like (each time I open the spreadsheet) to have Excel put the current (last) price for each of the stocks in column B into another column
|