Threads Replies Last Post 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   how can i get %. like 100+85+75+96=89.0% I want the pecentage like 100+85+75+96=89.0% ... 5 04.09.2006 07:06:01 email colored background Plz step by step colored background for Office Outlook and XP. I need it for an Afrocan AIDS Relief Charity. www.ahcip.org... 3 04.09.2006 01:23:01 Help with fomula & calculations I am trying to duplicat a paper form used in my work. It involves tracking sales, adding them and calculating commissions. Let me try to put this briefly. A customer may purchase ads in multiple books. My problem is figuring out how to make the spreadsheet 1) determine that there is multiple book sales 2) calculate all of them into one total field 3) how to place them on the sheet to wor... 5 04.09.2006 00:35:19 how do I input text into excel worksheet cell? All I want to do is type text into an excel worksheet cell. How do I do this so that ithe line of text stays within the cell and does not continue into the columns to the right? It can't be that complicated!... 3 03.09.2006 16:26:31 How can i modify document and unlock After installing microsoft office 2003 I used it a few times, now when I go into type a document I get a message at the bottom of the screen saying the modification of the document is not allowed as it is locked. Please can anyone help I am falling behind in my assignments. A reply for someone not that great on computers would help. Thanks... 5 03.09.2006 15:36:01 Information Rights Management Running three independant PCs and laptop on microsoft workgroup network. Will IRM work - what must I load to right protect a shared exel workbook? (Workbook loaded on one computer and share with others ). Must I load onto all 4 computers? Sorry I'm not as computer literate as some but learning. Want to prevent copying, emailing, etc.... 2 03.09.2006 15:30:01 Need help with max and if formula I need to create a cell entry that displays the name of the salesperson who sold the most cars in the quarter. Use a combination of the “IF” and "MAX" functions to do this. Hint: you will need to use these functions function multiple times in the same formula to do this. ... 9 03.09.2006 15:09:01 OptionButton. Reset to 0 Readers, Can OptionButtons be set to 0, using something like For each - Next ?? Up till now I know no better way then Me.OptionButton1 = 0 Me.OptionButton2 = 0 Me.OptionButton3 = 0 Me.OptionButton4 = 0 Thanks, Eef ... 8 03.09.2006 11:14:57 Formula Help (If it's Even Possible To Do) It's for a football pool and I told the guy I;d research and play around to see if it's possible. The spreadsheet looks like this: NAME 16 15 Bob Pitts New England Joe Seattle Minnesota It goes 16 through 1 Say Bob gets them all right except 15 (which he picked New England to win) he gets 121 (possible out of 136 points). Bob is in row 2 and takes up 16 c... 5 03.09.2006 06:09:51 Excel row height In Excel how can I keep row height when pasting?... 2 03.09.2006 00:58:24 Is a transparent color fill possible? When I fill a rows or columns with color, the gridlines running through them disappear. Is there a way to make the fill "transparent" in order to see the gridlines? (I'm using Excel 2003). Thanks ... 5 02.09.2006 23:13:37 Search for data in a column bring all related items in other colum I have data in the excel sheet with .A column for OrderNo and B Column for items for that Order. A B ORD001 ITEM1 ITEM2 ITEM3 ORD002 ITEM4 ITEM1 ITEM5 There are more than thousand orders.I want search for an Order so that it brings all items with it. I cannot use filter in A c... 3 02.09.2006 21:39:35 writing on an excel file my employer emailed me an expense report and i downloaded excel. i can't seem to write on this document. is it because its a read only fiel? how do i convert it to be able to edit and write in my expenxes? HELP!!!!!!... 4 02.09.2006 20:44:53 Merging Cells Hi I have a list of a couple of thousand postcodes in a column in a spreadsheet. Each postcode occupies its own cell. Examples of each postcode might be AB10 or AB11 or AB12 etc. I want to cut and paste these postcodes to another sheet, many codes to be pasted into single cells. I tried to merge the cells as they stand so that I could collectively copy and paste them but excel says t... 25 02.09.2006 19:36:02 Limit the rows in a column that repeat on the second page? File, Page set-up enables one to detail the columns that can be repeated as row headings on subsequent pages. If one is using a few columns that need to be repeated but has notes further down the page that are to be printed on the first page but not on following pages how is that specified?... 2 02.09.2006 15:42:01 Invoice Hello all.. I am currently using an invoice template in excel and inputting the info directly onto the invoice in excel. How would one create a user interface that would ask for the desired information and once completed would print the invoice including totals/costs etc without displaying the excel UI. I hope this makes some sense. I am brand new so I am not sure of the terminology or ... 4 02.09.2006 15:29:03 How do I adjust picture resolution? I have been asked to post a picture that is 72-96 dpi and no more than 6 inches on any one side. I have no idea how to do this.... 3 02.09.2006 07:46:01 Please help with finding correct functions!!! I am trying to configure Excel to balance my checkbook. Column A is Trans. Type, Column B is Date, Column C is Description of Trans., Column D is Debits, Column E lists if items are posted, Column F is Debits and Column G is Balance. I'm trying to get Column D (debits) to subtract from Column G (balance) and get a new balance (new column? H?) and get Column F (credits) to add to Column... 6 02.09.2006 07:26:01 is there a spreadsheet for class lists? I am trying to use a Microsoft Works spreadsheet to set up class lists and what the students have paid or owe for their class participation. Is there a spreadsheet template for something like this or a suggestion of how to set up a spreadsheet to do this?... 4 02.09.2006 07:20:01 Control Tool Box Hi, I want to learn how to use the elements (e.g. command button, option button, combo box etc.) in the control tool box. Can someone point me to some articles/tutorial? Don't seem to have much luck with help? What is the control tool box for anyway? Thanks. Epinn ... 5 02.09.2006 07:14:02 How to printout only selected rows and columns Hi all. here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reas... 9 02.09.2006 06:46:01 Creating combo boxes This is how I have my spreadsheet set up: in Sheet 1, the leftmost row has every date between 7-1-06 and 6-30-07 in descending order, with the corresponding day of the week next to the dates. Columns to the right of this have numeric information pertaining to this date/day. I would like to make a combo box that has me select a day of the week, searches the spreadsheet, finds info for t... 3 02.09.2006 05:22:01 How do I get dates recognised as annual quarters? I am using a spreadsheet as a KPI planner. I need to report quarterly. Each KPI has a day month and year assigned to it. I would like to automate this so that when a date is entered in a cell, the annual quarter in which that date falls automatically appears in the adjacent cell. Does anyone know how I can do this?... 2 02.09.2006 02:41:01 Converting imported hr/min/sec to excel I am trying to convert time entries from an external source (hh/mm/ss) to calculate in excel. What is the easiest method of doing this? I am not sure of the properties of the external report but is seems to be very similar to word pad. Thanks, Gerry -- Gerry St... 2 01.09.2006 21:52:23 how can i import worksheets from multiple workbooks Hi, I have a bunch of workbooks that all used the same template and were filled out for each week of the year. They all have a "totals" sheet the collects all the important data within. What i want to do is create a macro that imports that totals page, or a section of it from a bunch of these different workbooks, say all the ones in january or maybe the entire years worth so i can do so... 2 01.09.2006 19:49:10 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>