Threads Replies Last Post 2139 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>   How to change shapes for Cell Comments In Excel 2000 you can insert a comment in a Cell, mark the Comment border and then chose from your Draw menu/Change AutoShape/Basic Shapes. Then the Comment change from a square to any shape you chose. Is this also possible to do with Excel 2007? Any help is very much appreaciated. Regards Jan ... 4 12/15/2008 11:10:17 PM How to rank I am using excel 2003. I need to know how to rank the following? results 10 -2 -5 25 31 ranking i would like 1 2 3 1 1 I want all results >0 to get a ranking of 1. and the ones that are <0 i want stack ranked with the first result to get a ranking of 2. Can someone help? -- John... 10 12/15/2008 10:59:43 PM Is there a way to insert images into unlocked cells Trying to figure out how to insert images into unlocked cells on a protected sheet. Have been able to insert some drawing shapes, but not images.... 2 12/15/2008 10:51:01 PM Lookup through a range of numbers If I enter a number in a cell, lets say 1500. I need some sort of lookup to find a number on another sheet that either is equal to, or larger than the 1500. What I need it to bring back exactly is, the first instance of either 1500, or the next largest number it finds. Although I have used Vlookup for many things, I can't seem to make it work for this one. Anyone have any ideas????? ... 3 12/15/2008 10:32:16 PM Number Text Format I have a column of numbers formatted as text such as: 099.600 '101.550 102.000 '104.430 105.500 Some numbers have an apostrophe in front and some do not. I would like to make all the numbers in this column consistent without the apostrophe. I would also like to keep them as text since converting them to numbers would likely get rid of the first character for numbers less than 100.... 3 12/15/2008 10:21:43 PM DDE links slow opening in Vista? Hi, its a long time since i last visited this site, hope everyone is ok. I've a problem with Vista and DDE links, in my main spread sheet i have around 300 - 350 links, i only purchased Vista Business last week, the spread sheet works fine, but when i open it and clic on update links, it takes about 3-4 minutes for the links to start to update, ie i have to wait that long for anything t... 1 12/15/2008 10:13:01 PM folder permissions with a macro good day, i am using the following code in a macro to make a folder (EmpName) before saving a file into the folder... EmpName is referenced from a cell in the excel file On error resume next mkdir "C:\Operations\HR\EmpName" On Error goto 0 when the folder is created, the folder permissions are not correct, so the user cannot save the file directly to the folder. technically, the... 1 12/15/2008 10:07:03 PM Page Breaks to force new worksheets Hi, I used the subtotal feature to force page breaks after each of my subtotaled groups. Works fine and in Print Preview I see each set of data on its own page. Is there a way to have Excel create multiple worksheets where there are page breaks and force the data between breaks over to the new sheet? Either manually or via macro or other means. I know I can copy/paste the data between... 1 12/15/2008 10:02:05 PM Change color or type size in an Excel TEXT function I want to be able to change the color and font size of the TEXT function in an Excel equation as follows: ="The following number is red "&text(a1,"##")... 4 12/15/2008 10:00:01 PM Sharing with older version I have Excel 2003 and need to send a form to someone using an older version. How do I alter my form so they can view it?... 4 12/15/2008 9:46:48 PM take out #VALUE! Here is the formula: =IF(AE56>0,IF(AG56>0,IF(AE56>0,IF(AG56>0,(AE56+AG56)-AG56,""),""),""),"") As a result, in the cells it shows: #VALUE! How can I have the cells not show #VALUE!, instead leave the cell blank if possible. Thanks for all the help al619 ... 4 12/15/2008 9:35:01 PM Linking I need to link one cell (contains words) in one workbook to a cell in another workbook. In the first workbook I have an picture (pasted)into the same cell as the words. How can I link the words and the embedded picture to the one cell in the second workbook ... 5 12/15/2008 9:17:01 PM Re Post I posted this the other day but got no replies. Can any one give me any information Thanks Stew Hi all If there is a figure entered in D10 it prompts, in B11 a hyperlink to become active with the the following =IF(SUM(C10:E10)>0,HYPERLINK("C:\Program Files\Canon\CanoScan Toolbox Ver4.9\CSTBox.exe","Scan And Name"&" "&ROW()-1&" "&"To Income Receipts")," ") This opens the scanner ... 3 12/15/2008 9:16:02 PM AND & OR Functions I would like to combine AND and OR in an IF statement. What is the code? For example, IF(......AND(a1=1, a2=2) OR(a3-"Yes",a4<>0). Thanks ... 6 12/15/2008 9:03:52 PM Map Template I am trying to find a template to use to color in States of the USA for a school project. I am looking for something like was used by the networks when they were coloring the states to mark Democrat and Republican. Is there a template somewhere that I can import? ... 2 12/15/2008 8:57:56 PM Excel I'm trying to create a calendar vacation spreadsheet but I want to avoid having certain department managers/supervisors from taking the same days off. Is there a way to create a spreadsheet that will help me do that? For instance, if I enter a date, and a manager already has that scheduled off, is there a formula that I can create that will give me a pop up message that says "date alre... 5 12/15/2008 8:56:12 PM Limit the number of characters entered in a single cell I am building a form and: 1. need to limit the text response to 500 characters in a single cell. 2. need to protect all the cells except those I want the user to enter information in Can anyone help me? -- Regards ~ tates... 5 12/15/2008 8:46:33 PM How do I turn off high contrast setting?? I cn't see the color fill in cells except in print preview and found an answer that said to turn of high contrast. How do I do that?... 3 12/15/2008 8:44:01 PM Sheet Tabs Was asked about hierachical sheet tabs, for example, two tabs 'A' and 'B' where when you click on 'A' you then get a series of sheets just for that group, and clicking on 'B' you get a different series of sheets. I know all this is easily within the grasps of VBA but if programming is not pursued, is this function resident in the program? Thanks!... 3 12/15/2008 8:31:42 PM Adding to a drop down list I have created a drop down list and it shows up where I need it. I now need to add entries to that list, sometimes I can and sometimes I can't. I'm not sure what I've done differently when it works, what is the proper procedure to add items to a drop down list that is already created?... 3 12/15/2008 8:23:02 PM Pivot Table: Summing Average Values I am doing a pivot table where the values are displayed as averages. The subtotal line is then taking the average of all of the rows. I would like for the subtotal to be the sum of all of the rows but cannot figure out how to do it. Thanks!... 5 12/15/2008 7:57:29 PM open word doc is it possible to open a word doc using a button that i have put onto a excel worksheet... 7 12/15/2008 7:57:01 PM Conditional Formula / Logical Function In our employee performance evaluation workbook, page 1 (the Leadership Talent Assessment worksheet) contains a list of nine (9) performance attributes. Managers must rate an employee’s performance of each attribute as “Yes”, “No” or “In Part” by placing an “x” in a box next to the appropriate rating level. If the manager types an “x” in the box next to “Noâ... 1 12/15/2008 7:36:04 PM CONCATENATE multiple cells in a column I know the short way to concatenate two or three cells, but how can I do a concatenate job for a column of 500 cells in an easier way instead of keying in the statement one by one? -Chris... 5 12/15/2008 6:38:13 PM how to Permanently change default font for comments Can anyone please tell me how to permanently change the default font for comments?... 3 12/15/2008 6:27:08 PM 2139 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>