General
in [Excel]
|
cursor highlights more than on cell - change back Press the F8 key Jasper wrote: Cursor is highlighting more than one cell 11-Feb-10 My cursor is highlighting more than one cell at a time. How do I fix it so that it highlights only one cell? Previous Posts In This Thread: On Thursday, February 11, 2010 11:18 AM Jasper wrote: Cursor is highlight... 20 May 2010 11:40
Formula to reference another cell in a worksheet Column G is filled with numbers which represent Rows in my worksheet. I want Column H to equal the contents of Column A Row ? which is referenced in Column G. Example: G1 is 1043, I want H1 to be equal to A1043. What formula can I use to fill column F to do this automatically. Thank you! Heather ... 20 May 2010 11:40
SUM IF: How do I sum the data in a column based on 2 other col It worked, Thank You Very much! "Abnerz" wrote: try sumproduct -- Abner "jharoy" wrote: Can someone help me? I would like to know how to total the # of persons who have "Scheduled Appointments" and need "Housing Assistance. I am extracting this data from a separate spreadshe... 20 May 2010 11:40
Extract workbook information I want to programmically extract certain information from all workbooks in a folder, always in the same place on the same sheet in each workbook. The result will look like this: Bookname Sales Profit Book1 999 999 Book2 999 999 etc. assuming Sales and Profit are in cells c10 and g1... 20 May 2010 12:48
Save print settings How do I save print settings in an excel file. I have created a form for co-workers to use and want it to automatically print to a particular printer and to print two-sided. Unfortunately I can't count on most of them to know how to do that, so I would like the file to have those print settings saved. -- Jul... 20 May 2010 10:34
Formulas not calculating periodically I have Office 2003, this started a couple of weeks ago that simple formuls like Sum or =A1+A2, etc, will not calculate. These are worksheets that work when I have them open and then a little while later will not work when I open them again. I can close and not save and then try to open them again and the form... 21 May 2010 15:03
while opening excel attachment getting repair error When I open the Excel file from my vendor using Excel 2003, I get a message box that says "Errors were detected in 'ExcelName.xls', but Microsoft Office Excel was able to open the file by making the repairs listed below. Save teh file to make these reapis pernament." Renamed invalid sheet name. But his w... 20 May 2010 09:28
Data, Text to Columns, has commas in the text, plus as a delimeter Using XL 2003, I want to import data from another program. I can do so with the Text to Columns feature, but, the program uses exclamation points and a comma as a delimeter ( !,! ). An example is below: !Visit Arizona, Eat Mexican Food!,!1!,!1.000!,!N!,!50!,!50!,!0!,! 2229!,!547!,!188!,!0!,!0!,!0!,!0!,!0!,!0!... 20 May 2010 09:28
Autosum doesn't work. How do I get column total? I am doing an excel spreadsheet at work. The column I need to total seems to have a fault, and autosum doesn't work. What can I do? ... 20 May 2010 10:34 |