Summary: I know how to use an IF statement to change the value of a cell in MS Excel (Office XP). But can the color of the text be changed also? Or the backgro...
Summary: I want to restrict number of digit in a selected column in a sheet of MS Excel 2003. Example: I want that on a cell I will type only 123 but not 1234....
Summary: I have made a ms excel sheet,I need to create a way by which when i press enter on a particular cell or just click a button somehwere on the sheet au...
Summary: In MS Excel 2007 the question is, using only a Formula (no VBA), how to determin is the string in a cell contains any key words listed out on another ...
Summary: In an MS Excel document, I have a PDF link that I have no problem to open anywhere else. But on my computer, when I open that link, it opens Adobe and...
Summary: I am trying to code a carriage return within an excel cell using vbscript. When I append chr(10) or Chr(10) & Chr(13) to the string that is being writ...
Summary: While working with MS Excel I was trying to figure a way to automatically open and print a document at a specific time. For example, every Monday morn...
Summary: The other day my wife did something I can't figure out. When ever I open MS Excel now, I get a window pop up that says (Special birthday.doc: file fo...
Summary: Hello, Anybody know how to change the the data from rows into columns or say in the other word is to rotate a table in MS Excel? Thank you very much. ...
Summary: I am trying to assign a user defined VB function to excel cell. I wrote a s simple function called testy() in VB editor that returned a number. Fu...
Summary: Is it possible to have it so that Excel cells/rows/sheets can be edited only once? That is, information can be entered, then the spreadsheet saved, bu...
Summary: Is it possible to have a number overlap the adjacent cell like text does? I want to do this so I can have daily subtotals in a separate column to to t...
Summary: I want to Highlight Excel Cell by Selecting Different Cell. For example: Highlight cell H3 When Cell A3 is selected. But i need to use this method for...
Summary: A couple of posting suggestions first: 1 - Please try to use a subject line that is relevant to the content of the post. If everyone used subject line...
Summary: In MS Excel (Office XP) I want to use a web link that includes the value of a cell. Can this be done, perhaps using concatenation? The link: http://ww...
Summary: Is there anyway that I can referrence a cell in excel in a word doc much like you referrence cells from sheet to sheet in excel? I have search long a...
Summary: Hi everyone, I need some help here. I'm running excel MS office 2007. I have a main file that as a hyperlink to an external word doc. I'd like to plac...
Summary: Hi Guys. I am not good at excel but there is something I want to achieve in excel, I don't know if it is possible but here is what I want. I want a cl...
Summary: Dear sir, This is Ravi .M We have a list of calibrated test & measurement equipments for our testing activity, Presently we are maintaining calibr...
Summary: how to write an VBE macro to automate input to an excel sheet one at a time and can find the nearest empty cell (same colume)to update the cell. ...
Summary: Hello! Please help me a little with Date formulas in MS Excel 2000. I have a Cell (A1) with a 'dd.mm.yy' value, and i wanna make Excel to calculate H...
Summary: Dear Friends, I have a question in microsoft excel.Suppose i have these cells in my microsoft excel sheet-: A 1 Computers 2 Computers 3 Scanner 4 Keyb...
Summary: When viewing a spreadsheet in Excel, if you have one column that has a long string of text how can you hide the text that the next column covers. I k...
Summary: It has been a number of years since I last used MS Excel 2k and feel sure I have not encountered this problem before as I would not use the other date...