Threads Replies Last Post 125 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  >>   Editing menus in Excel 2007 beta 2 How do I edit the "right click menu" in Excel 2007 Beta 2?... 6 02.08.2006 12:47:18 Excel with an embedded Word Doc I have a workbook that has an embedded word document on one of the worksheets. This worksheet can be visible or invisible. I have a print macro that prints out all necessary worksheets, it then checks to see if this worksheet with the embedded doc is visible, and if so, it launches the document. What i need the macro to do then is to print the document and close the application. Can anyo... 1 02.08.2006 10:14:09 Conditional Formatting Is there a way to format a cell as a condition of an other? Expl. Format Cell A1 if Cell A2 meets certain criteria. ... 2 02.08.2006 08:51:31 Conditional Formula to indicate Formula in cell I've got a formula in a column, but in certain circumstances I may = overwrite this formula with a number (too rare a special case to bother = = covering) What I'd like though is to use Conditional Formatting to alter cell to = Bold or something to show that this is *a manual override* Can't see how you can check for formula present ? Any ideas ? -- = Steve (3)... 10 02.08.2006 00:12:01 example in the help topic I put in a wrong formula and then I went to the function help and it said to open a blank worksheet, Select the example in the Help topic. I can't find the example in the help topic. Do I open a blank worksheet and then press CTRL +C to opent the examples? I was in the ATAN function. -- Lois Ann... 5 01.08.2006 23:16:03 Problem with criteria for DSUM (Excel XP) I'm having a problem with the criteria for a DSUM formual on a worksheet; the workbook is a budget worksheet I got from a large non-profit that I'm learnign and (hopefully) going to adapt for our use. The worksheet in question is named Cash Budget. One of the expense items is named "Conf./Training/Meeting". The column names come from another sheet called "Chart of Accounts" and are labe... 3 01.08.2006 21:25:24 Cot How do I divide one number by another and then multiply answer by the cot? Example 896.96/115.74 *cot -- Lois Ann... 9 01.08.2006 20:35:02 SUBTRACT COLUMN A FROM COLUM B =? I want to subtract Column A from Column B and Column C be the result. I've been doing each row calculation and I know there is an easier way.... 2 01.08.2006 19:32:59 Paste Link I know that if you "paste special" an Excel worksheet object into a Word doc, the pasted sheet will mirror the data that is input in the source document - however, I was wondering if anyone knows if it is possible to link such documents whereby you create formulas that link across the 2 embedded worksheets i.e. as if you were working in Excel itself and where you can create formulas across multip... 2 01.08.2006 15:57:00 Help The problem I am having is when I open the workbook in question a message appears and states "The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook" Yes....... No. If I click No the workbook opens, however if I click yes the workbook just hangs and I have to go into task manager to ... 2 01.08.2006 10:48:23 Hyperlink or Other Method To Return To Previous Location (Sheet) Possible? Hi, Just wanted to know if it is possible to have a command (Hyperlink etc.) return you back to the previous location (sheet)? Kind of like the Back button on Web Browsers that returns you back to the Page you recently left... Thanks In Adavance for any help here.. -- Mhz ------------------------------------------------------------------------ Mhz's Profile: http://www.excelforum.com... 5 01.08.2006 10:39:34 How do I use addins with the excel spreadsheet? -- Lois Ann... 9 01.08.2006 10:28:02 I have two columns 1 & 0 and want to choose those cell with 1 by . Dear friends: I have two set of data only 1 & 0. and want to use countif function to choose those cells with only 1. my data is here: 1 0 0 1 1 1 0 1 1 0 1 1 I want to count the cells containing only 1 1 please helpme. thanks.... 11 01.08.2006 08:35:48 how to change format of several dates entered in an Excel column I have several dates (in fact over 100) already entered in the Date column in "1 Jul 1854" format. This makes it impossible to run a meaningful sort by Date. Is there a way to change these dates to a diffirent format like "1854-07-01"? Of course, I'm not asking how to change every date manually. I'd like to highlight this column and change all the dates at once. All suggestions will be ap... 3 01.08.2006 04:34:02 How do I print selected rows? I want to select some rows from two different worksheet pages and have them print out on the same piece of paper ( I get one row printed out per sheet of paper right now?) I want all selected rows to print out on the same piece of paper. Thanks -- kmf... 3 31.07.2006 17:53:16 xml excel 2003 how do i get the xml option in the data dropdown of excel 2003... 4 31.07.2006 13:51:03 transpose data between columns, rows or cells Hi, How can I switch data between cells, rows or columns in one step? For instance, if I want to switch the contents of cells A1 and B1, how do I do that without having to retype everyting, and without having to use a third column (that's what I do now: first I copy B1 to C1, then A1 to B1, then C1 to A1, then delete C1 - this method is obviously very tedious...). Tnx, John -- jonnel --... 2 31.07.2006 13:24:05 Syntax for IF function I would like to average the values in column B that lie between 2 values in column A. What I have so far is =average(if($A3:$A100, ...value in column A is less than 46 and greater than 34..., "" ""). I have been unable to express the second term with the correct syntax. I assumed that it would be ,<46>34. So what is it? Thank you in advance. -- Sarah... 2 31.07.2006 12:57:23 How to delete unneeded colums in a sheet I created a book for creditcard management and I need only so much colums. How to delete the other colums? ervinke -- ... 7 31.07.2006 10:53:01 Help needed is there anyway you can see what links to other workbooks are associated with the workbook you have open. The problem i am having is when i open the workbook in question a message appears and states "The workbook you opened contains automatic links to information in another workbook. do you want to update this workbook with changes made to the other workbook" Yes....... No. if i click N... 2 31.07.2006 08:40:10 Beginners Question setting up spreadsheet Hello, I have a spreadsheet and the top roll has information that I need to be able to see when I scroll down. How do I set it up so when I scroll down the top roll or top couple of roll remain in place. Thanks PappyJoe -- PappyJoe ------------------------------------------------------------------------ PappyJoe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3693... 5 31.07.2006 03:33:33 specific cell Hi, In my worksheet, can I make a set-up that I can only go from 1 cell to another specific cell by just pressing the tab or enter key? like, in a spreadsheet, there's a lot of cell, so what I did was, I locked & protect some cells but I have to run through every cell, it doesn't skip. Please help. thanks aynrand1964 -- aynrand1964 -----------------------------------------------------... 2 31.07.2006 00:15:44 Cell fill color Hello, Can I fill color a cell but will not show the color when i print it. thank you -- aynrand1964 ------------------------------------------------------------------------ aynrand1964's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36933 View this thread: http://www.excelforum.com/showthread.php?threadid=566450 ... 3 30.07.2006 23:56:04 100 equal squares on standard paper I want to fill a standard size paper with 100 equal squares... 4 30.07.2006 19:42:44 Import File I have office 2003 excel. There is no "Import File" commands in any of the menus. Is that normal or do I have something set up wrong? I have open workbook. Click on blank sheet 2. Then I want to import another excel sheet from another workbook. John... 4 30.07.2006 16:38:37 125 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  >>