| Thread | Last Post | Replies |
|
| Convert date field to month in Pivot table | 23 May 2007 14:50 GMT | 9 |
I have a Table wich has date fileds, Date Order No. Qty Shipped 01-27-07 03-19-07
|
| Revised Dropdown list not applying to some rows | 23 May 2007 14:26 GMT | 5 |
I revised my original dropdown list to include new data. I then tried to apply it all cells with the same settings by checking the box in the Data Validation dialog box. Most rows in the column got a blue autofill to show that these were the rows to which the new dropdown list ...
|
| Will a Pivot Table Do This? | 23 May 2007 14:24 GMT | 3 |
I have a large database consisting of about 40 columns and several hundred rows. The headers of the columns denote the stages of a production project: let's say, "To Design," "To Production," "To Marketing," "To Distribution," etc.
|
| i want to enter more then 16 number in one cell without text forme | 23 May 2007 14:11 GMT | 3 |
i want to enter more then 16 number in one cell without text formet
|
| excel file opening problem | 23 May 2007 12:52 GMT | 1 |
When I open any excel file, the only excel program opens with blank screen. Even without work sheet. In case of opening excelprogram by clicking the excel shortcut icon, it opens with work shet as "Book 1". How can I make it posible to open excel file easily. Your help will be ...
|
| When i open excel file it takes time to open | 23 May 2007 12:50 GMT | 1 |
I have a PC with Windows XP installed on it. In that Office Xp is also installed, now the problem that I am facing is that when i try to open an excel file by doubleclicking it takes about 1-2 mins to open but when I do the same by opening excel.exe & then open the particular ...
|
| Control ToolBox OptionButtons Printing? | 23 May 2007 12:47 GMT | 3 |
Excel2003 ... I have a WorkSheet with Control ToolBox OptionButtons ... I want them to print ... However, I just want the sunken button to print ... not the object square around them ... Is there a way to prevent this? ... Thanks ... Kha
|
| Importing data using a date as the condition | 23 May 2007 11:44 GMT | 2 |
I need to design an excel model which will import data from an external database when I enter a date into a cell in the worksheet. This is to avoid having to manually key data each month i.e. into a profit & loss report.
|
| auto text entry | 23 May 2007 11:41 GMT | 1 |
Excel on a one machine appears to have an auto text type entry but i dont know where it is or how to remove it Whenever I type BRD the full name of the company appears in the cell. it is not selecting from entered text as this happens in every new workbook.
|
| Summings cells in Italics | 23 May 2007 11:03 GMT | 3 |
Is there a way to sum ONLY the values in Italics in a column of data? Any help would be most appreciated
|
| Count IF Q. | 23 May 2007 10:59 GMT | 1 |
I have two columns F & G Column F has the Vacation Status of group of employees “Processed” or “Scheduled” start from F7 to F83 Column G has the date of vacation starts, start from G7 to G83
|
| Macro | 23 May 2007 09:58 GMT | 11 |
Just a simple question regard Macro. I have a file that whenever i opens, it prompts me on Macro, 1) what is macro. i have checked macro, it stated security level, virus prevention.
|
| How change worksheet axis to alpha numerical not both numer | 23 May 2007 09:51 GMT | 1 |
the axis/titles/names of my excel worksheets have changed from alpha numerical to both numerical. The top left hand cell reads R1C1 not A1. I'm using Excel 2000. As something of a novice user this is confusing for me. How do I change it back?
|
| How to change rows, columns to alpha numerical | 23 May 2007 09:40 GMT | 2 |
The column and row labels/titles in excel are now both numerical instead of alpha numerical. The top left hand cell reads R1C1 instead of A1. How do I change it back?
|
| converting to Kg | 23 May 2007 08:06 GMT | 8 |
i have a program that is in pounds. i has wondering if there is an easy way to convert the majority of the program to kilograms
|