| Thread | Last Post | Replies |
|
| Formula to connect cells in different worksheets? | 04 Mar 2005 17:53 GMT | 2 |
How do i link an employee to their wage automatically? Is it possible to enter in my employee's name and hours, and have it automatically calculate their wage? I have all my employees wages in another worksheet right now. At this time I
|
| formula help | 04 Mar 2005 16:55 GMT | 2 |
The following formula queries and totals information on a specified sheet. In this case the specified sheet name is 2003 I have several sheets (2001, 2002, 2003, 2004.....) I would like to have the value for the sheet name in the formula reference a
|
| covert quattro pro to excel with microsoft office xp ? | 04 Mar 2005 15:39 GMT | 2 |
i am using microsoft office xp and have some quattro pro files i would like to convert to excel. but have not bin able to find away
|
| Conditional formatting of text | 04 Mar 2005 14:35 GMT | 7 |
Greetings, all - I am creating a simple spreadsheet template to be distributed to users for data entry purposes. The first column contains the names of the desired data elements. The second column contains the definition for
|
| Help - Controls Shift after print preview? | 04 Mar 2005 12:45 GMT | 8 |
I have an excel sheet with some standard controls such as buttons and combo boxes on it using Excel 2002 SP3. The problem is that after I do a print preview and closed the print preview window. There are page break dotted lines displayed on the sheets and all the controls on on ...
|
| how do I add times in Excel and result in hours & mins | 04 Mar 2005 11:57 GMT | 1 |
I want to insert a time when I start work and a time when I take a break, then a time when I leave work. Following that I want to be able to add up the amount of hours that I have worked.
|
| Drop-down arrow only visible when cell selected | 04 Mar 2005 11:40 GMT | 2 |
I created several drop-down lists using Data, Validate,... The drop-down arrows are not visible unless the cells are selected. Is this the default and can it be changed or am I stuck with the "invisible" drop-downs? I would like to have all the drop-down arrows visible at all ...
|
| Computer Club Template | 04 Mar 2005 07:32 GMT | 2 |
Need computer club template
|
| Automatically delete rows | 04 Mar 2005 05:14 GMT | 5 |
I have a spreadsheet that was created in and exported from QuickBooks. Before manipulating data in the spreadsheet, I want to delete all rows that contain anything in column C. What function or code could I use to do this? Could it be done using a macro? I have to do this many ...
|
| Trouble copying and pasting a formula | 04 Mar 2005 04:12 GMT | 6 |
This happens every time and really is annoying: 1) I try to copy a formula to another cell or to a Microsoft Word doc. 2) I go to the cell, and then highlight the formula in the data entry bar on the top of the spreadsheet.
|
| printing using macro | 04 Mar 2005 03:38 GMT | 2 |
I assgined a macro to a "text box" using "record new macro". This macro prints a certain range of cells on a laser printer. When I replaced the printer with a colored one: HP deskjet and run the macro it didn't print.
|
| Fill a cell with a character | 04 Mar 2005 03:24 GMT | 4 |
In Quattro I can place a backslash (\) followed by a character...say = and the character will fill the cell regarless of column width. Is there a process in Excel to achieve the similar outcome?
|
| Change rows to columns and vise versa | 04 Mar 2005 02:25 GMT | 2 |
I have a worksheet that has a list of cities as row headers, and dates as column headers with numeric values for data. It shows the # of new construction permits issued in each metro area per month. I need to select all the values for a city which are in a row, and paste
|
| Excel Graphing With Widely Divergent Values | 04 Mar 2005 02:04 GMT | 4 |
I searched but couldn't find anythign about this problem. Here's the basic premise: I've got two dollar variables I want to graph over time. The first variable is in the $10 range over the period. The second variable is
|
| Generate number NOT using a form | 04 Mar 2005 01:21 GMT | 2 |
I've searched hi an low on this site and others, and the nearest match was a question from Galaxykid in November. I'm running Office 2000 and have used the Template Wizaed to create a template that is used as a form to input data into another spreadsheet. I
|