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: 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: 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: i have 2 users that access the same excel spreadsheet. user 1 will access it make changes save it and email it to the 2nd user and vice versa. however...
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: Whenever i open the Ms Excel files, it will help me to add 1 behind the file name. For example testing.xls ,it will change to testing1.xls. When i ope...
Summary: Whenever i open the Ms Excel files, it will help me to add 1 behind the file name. For example testing.xls ,it will change to testing1.xls. When I clo...
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 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 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 an excel spread sheet with a visual basic script in it. I want to distribute this document but with the excel document there is an Add-in-libr...
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: I’m looking for some direction. I’m a former educator that taught basic computer applications to high school students. It was a one semester cours...
Summary: Hi, Make sure that you are entering dates that Excel recognizes. When Excel recognizes an entry as a date it converts it to a number, and formats it a...
Summary: Im trying to create a Line graph ( with markers) using excel. Ive got my data and got everything ruight except i cant seem to get the origin (for the...
Summary: HI, I have EXCEL 2003 File with three sheets containing data in one sheet and bar charts in other two sheet with some textures and fill effects. in on...
Summary: Hi I have a question regarding highlighting Excel cells. I am designing a quiz whereby I have set the conditional formatting to reveal the contents of...
Summary: I am making graphs using MS EXCEL 2002; while plotting a Mathematical function with the smooth lines option I need to ‘High light’ a few points and pl...
Summary: I don't really understand what you mean by dynamically updated.... The documents that I have are pretty much all text documents, such as resumes and j...
Summary: Another way of doing the same thing is with the AND function This function tests two or more conditions to see if they are all true. And there can be...
Summary: We are GOING CRAZY! We have a column of dates in a HUGE Excel file, and when we copy of paste, paste special, values, Excel is automatically changing...
Summary: Hi there, Could anyone help me maybe with the following. I´m trying to copy paste a lot of graphs from excel to ppt with a macro i found somewhere el...
Summary: When you have a long value in one cell and the cell(s) to the right has no value, Excel displays the text overlapping the blank cells. You can set the...
Summary: I'm trying (and failing) to nest a complex IF and AND formula.. Here are the details: H..................I.................J Rule #1 .......Rule #2.....
Summary: Hi, Here is code that will save to the next file name It has no real error checking, so there is room for improvement. Also I have only tested this on...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
