You are here:
Excel/Questions Answered by Expert Richard Stephens
| Subject | Date Asked |
| A stickler | 9/4/2009 |
| Q: Can't figure this one out. On one sheet, I have a column of 10 cells. In each of these, the value ... A: Dani This could be accomplished by VBA but I don't know VBA well enough to help. However if you ... | |
| COUNTIFS function | 9/2/2009 |
| Q: the question i have is about the Countifs function. I know it is very help full when you try to ... A: Pelambre You can do it with a static number such as your =10 but not with the > sign as excel ... | |
| Sum Question | 8/27/2009 |
| Q: I have a spreadsheet with about 80 columns and 80 rows. I want to sum the numbers in a column only ... A: John You can use a Sum an If statement to get what you need. Type in the following assuming that C ... | |
| Linking Workbooks | 8/27/2009 |
| Q: I'm trying to link Excel workbooks together, but when I do = and select a cell in another workbook ... A: Lisa Do you have two instances of Excel open? ie do you open one workbook then start another ... | |
| Want to put partial text from cell into another | 7/17/2009 |
| Q: I have cells containing names "Jane Doe", "John Doe", "Jill Doe" in a column. I want to put their ... A: Doug You can copy the column with the full names into the third column then use Data Text to ... | |
| Cell problem in Excel | 7/17/2009 |
| Q: I am using MS Excel 2003 SP3. I have an excel list that has the first name on top and the ... A: sam The simplest way would be to replace the Alt Enter key with a "-" and then text to columns will ... | |
| Sorting data into | 7/16/2009 |
| Q: Richard, I'm using Excel 2003 and I have a sample set containing values between 0.010 and 0.45. I ... A: Mike I can give you an idea using a nested if statement but would have a bettter idea if I could ... | |
| copying cells from one sheet to another | 7/9/2009 |
| Q: I have data that is in row 28 of three worksheets. Worksheet 4 is a summary sheet. Is there a way to ... A: Pat You can put a cell reference into the summary sheet by typing = and then going to the cell in ... | |
| Dividing the information in 1 cell into 2 cells | 7/8/2009 |
| Q: I am using Excel 2004 on a Mac os 10.4 computer. I have a list of 1300 names and address, each ... A: Sarah Since all the names will be different sizes, the easiest option would be to save the file as ... | |
| Average column B based on name in column A | 7/7/2009 |
| Q: I have column "A" with repeating and different names. In column "B" I have a value associated with ... A: Erin Here is the formula for the Average =SUMIF($A$1:$B$38,"CA321",B1:B38)/COUNTIF(A1:B38,"CA321") ... | |
| Excell Times Format | 6/30/2009 |
| Q: I have a text file that i imported into excell with time formats such as 11:58:00a for am times and ... A: Andres Select the cell/s with the times and then right click on the cells and select Format Cells ... | |
| User Form "Button" | 6/30/2009 |
| Q: Hey Richard, Thank you for taking the time to answer all of these questions! My question has to ... A: Katie They may have been from an older version of Excel, which when transferred to a new version ... | |
| question related to excel. | 6/26/2009 |
| Q: how can i change case of fonts in Microsoft excel? A: sapna Assume that in cells A1 thru C14 you have your text. In another part of the worksheet create ... | |
| Averaging Time | 6/25/2009 |
| Q: I have a weeks worth of run times that I would like to get an average for. They are all in the same ... A: Jamie How did you input the times? Are they to the left of the cell or the right, if they are on ... | |
| countif formula? | 5/14/2009 |
| Q: I have a column of dates that I would like to use a formula for, to get the number of dates within ... A: Jennifer You can use the sumproduct function using two extra cells for your dates (easier than ... | |
| conditional formatting?? | 5/14/2009 |
| Q: First I want to thank you for your help in this matter. I have an Excel (2007) sheet in which I ... A: Thomas Nested If statements only go up to 7 Nested if statements. Your best option would be to put ... | |
| Average IF | 5/11/2009 |
| Q: Basically, i have a table of data, of different sets of tyre and how far they lasted during a race. ... A: steve You can use an Average and an If function to get what you want but you will also need to use ... | |
| Stopwatch numbers in a column | 5/6/2009 |
| Q: I'm going to be taking some test measurements timed by a stopwatch. One reading every 20 seconds, ... A: Jim Type in 0:00:00 in the first cell and 0:00:20 in the second cell then highlight both cells, ... | |
| predictive dates | 5/4/2009 |
| Q: i want to add a date in colum A, say 21/01/09 that will automatically add a date in colum G 1,2,or 3 ... A: shirley To get what you need you can use three columns and use the add function similar to the one ... | |
| excel formula | 4/30/2009 |
| Q: is there a way to set a cell up with a formula that would give one number for dates between the 1st ... A: Carol You can use an if statement with a Day option, have a look at the formula below. ... | |
| Save a file with format and values (not formulas) | 4/29/2009 |
| Q: I have a master spreadsheet which contains several formulas pulling in data from different sources. ... A: Lynette If you are saving one day at a time the easiest option would be to copy the entire sheet ... | |
| Excel sorting copy and pasting to another sheet | 3/4/2009 |
| Q: I am working on a workbook containing several worksheets each containing the same column headings ... A: Glenn You can use the Data Filter option, select the code you want and it will show only the ones ... | |
| Excel 2003 - Autocomplete | 3/3/2009 |
| Q: in Excel 2003 - Autocomplete i want to edit/delete some items in the autocomplete list entries - ... A: Janet My apologies. You can't edit the list as it is taken from the preceeding cells, if you ... | |
| summing across columns using a criteria | 2/27/2009 |
| Q: I want to sum for example columns C1 to c100, to S1 to S100 and all columns in between using a ... A: David You can sum across columns using the Ctrl + Shift + Enter which will make the formuala an ... | |
| Excel formula | 2/26/2009 |
| Q: I am trying to create a formula to count the total number of blank and total number of non-blank ... A: Anne You can't use one formula for both as it would give you a total amount not just the blank or ... | |
| Excel - extract data | 2/25/2009 |
| Q: I have a book with a lot of data that I need from one book to a sheet. Then extract data from that ... A: Chad The question is a little confusing, do you want to have two workbooks and extract the ... | |
| Sorting Options | 2/25/2009 |
| Q: I am trying to find a quick/easy way to sort a column with names on it so that it will put them in ... A: Stacy I am assuming that the names are in one cell, the quickest option is to split the column and ... | |
| Prepopulating a calendar in excel using a source table | 2/24/2009 |
| Q: I have a multi sheet workbook that I use track when certain events take place during the year. I ... A: Carolynn I would need to know what version of Excel you are using, how the table is set up and how ... | |
| Excel tabs | 2/23/2009 |
| Q: Hopefully you can help me with this question, how many tabs (maxmium) we can put in a Excel ... A: Jenny The amount of worksheets (tabs) is limited by memory, what you can do your machine may not ... | |
| Overtime calculation | 1/30/2009 |
| Q: In column a i have overtime hrs worked, in column b i have rate, i.e time and a third ,time and a ... A: John Would it be possible for you to send me the spreadsheet with the setup you have as well as the ... | |
| delete links | 1/28/2009 |
| Q: I want to delete all links between worksheets. Apparently I have deleted one direction of the link ... A: Robbin You don't mention what version of excel you are using. Have a look at this link ... | |
| formatting number in excel | 1/28/2009 |
| Q: is it possible to put a number eg 100 in the form of 10to the power 2in excel 2003 thanks in advance A: Kalpana You have two options, you can use the =Power(10,2) or =10^2 which will also give you 100. ... | |
| SUM IF ? | 12/12/2008 |
| Q: I'm trying to add a certain range of value only if the values in another column range from 3 to 4. ... A: Silvia To do this you need to create an array formula. I have created a formula that will sum all ... | |
| Hyperlinks based upon a previous cell | 12/10/2008 |
| Q: I was wondering if you could help me with a little issue I have. I'd like to insert some hyperlinks ... A: Grahame If you are opening up a specific file you can use the hyperlink and if function as shown ... | |
| FORMULA FOR 3 RATE BANDS | 11/24/2008 |
| Q: I need to show the following 1% levy on the first €100,100 2% levy over €100,100 up to €250,120 3% ... A: alex The email isn't coming through in the message. ... | |
| FORMULA FOR 3 RATE BANDS | 11/23/2008 |
| Q: I need to show the following 1% levy on the first €100,100 2% levy over €100,100 up to €250,120 3% ... A: Alex The formula is below, however it doesn't seem right as you only have asked for percentages ... | |
| Date Formula | 11/23/2008 |
| Q: In my invoices spreadsheet I have a column which gives the date of the invoice (column b). I would ... A: Carol You can create a formula using the Array Formula option (Ctrl + Shift + Enter) after typing ... | |
| highlighting | 11/21/2008 |
| Q: this is a very simple question i think, i want to be able to highlight all the data that i have in a ... A: June Ctrl + Home to move the cursor to A1 or place the cursor using the mouse to the first cell ... | |
| Bank statement in Excel | 11/15/2008 |
| Q: I'm trying to replicate a bank statement in Excel. Accruing the sum of D/C is no problem. ... A: Michael This can be tricky because the bank may not use a standard rate, it can be variable every ... | |
| creating a sheet reference cell to work in a formula | 11/14/2008 |
| Q: how do i create a cell which references an external sheet (in another document), so then i can use ... A: Sam Open up both workbooks, in the one that you want the reference type in the = sign then move to ... | |
| Prevent linked cells from changing | 11/10/2008 |
| Q: I have one sheet in a workbook that is linked to another, the first sheet contains raw data and the ... A: Dan This is by default in excel. One way around this is to use the Indirect function. When using ... | |
| creating multiple Excel charts and mail merging into Word | 10/9/2008 |
| Q: I created a "base" chart in Excel for one row of data (out of over 100). I want to use that chart in ... A: Ellen Here are three options from Cindy Meister Word's mail merge does NOT support merging to ... | |
| Conditional Formatting with Excel | 10/7/2008 |
| Q: I have a list of co-workers information, and I would like to set a reminder for upcoming birthdays. ... A: Patricia This formula using conditional formatting on the birthdate will show all active birthdates ... | |
| Opening Excel | 10/7/2008 |
| Q: I would just like to know if there is a way to link to an Excel workbook in such a manner that the ... A: Holly To do this you will need to open the Visual Basic Editor by going to Alt + F11 then follow ... | |
| Unlinking Sheets using Excel 2007 in Vista OS | 10/7/2008 |
| Q: Richard I am pasting the inquiry that I have been unsuccessful at finding any answers.. Please ... A: M You would have linked the files together somehow. If you copied information from one workbook to ... | |
| blank cell to display zero value | 10/1/2008 |
| Q: After trying a lot I still cant find if there is any way to have Excel to display zero '0' in a ... A: Andy This will work for what you need. Enter the number 1 in an unused cell and copy that cell. ... | |
| saving excel spreadsheet at specified time | 9/29/2008 |
| Q: I'm using Office2003 and would like to not if there is a way to set up an auto save function for an ... A: Tony I haven't tried it but this should work (if the link doesn't work get back to me) ... | |
| blank cell to display zero value | 9/29/2008 |
| Q: After trying a lot I still cant find if there is any way to have Excel to display zero '0' in a ... A: Andy In Excel 2003 go to Tools > Options > View and select 0 values (this will only work on cells ... | |
| Linking and Sharing | 9/29/2008 |
| Q: "Dear Mr. Stephens, Good Day! I have made an excel workbook in which various sheets in excel ... A: Amna If you place it on a server then you should be fine as long as you update the links from the ... | |
| MS Excel - formula needed to calculate total using multiple criteria | 9/29/2008 |
| Q: but just can't come up with the correct formula. It is probably so easy that I am making it ... A: Anne The simplest way to do what you want is to use the condition Sum option in the Tools menu. If ... | |
| formula help please | 9/26/2008 |
| Q: I need to enter a formula that for the below information Price of goods (eg: $20) + gst (10%), x ... A: Ellen I Excel if you were to type in the formula as shown A1+10%*.5-35% the formula would multiply ... | |
| Formula | 9/25/2008 |
| Q: I need help with a formula that only counts the entries in column 'A:A' if the adjacent cell in ... A: John If it varies in size you can use the countblank on a Named range. That way everytime you ... | |
| coupon | 9/24/2008 |
| Q: i need to make a printable coupon on my web page that a customer can print off and bring to the ... A: Bill The simplest way would be to create it in Word then publish it to the internet (depending on ... | |
| Search Function in Excel | 9/24/2008 |
| Q: I've a sheet(Ex:Sheet1) of 1000 rows with 2 columns. And the 2 columns are Number and its ... A: Ravikanth If the numbers are in alpha/numerical order you can use a Vlookup to get what you need. ... | |
| add values of similar items | 9/23/2008 |
| Q: i have column A which has names of employes and column B has no. of hours. How do i add the hours if ... A: Naz You can use a few options One is to sort the names alphabetically and use the subtotal option ... | |
| Lookup question | 9/22/2008 |
| Q: I have a very long list of people with associated data which includes, among other things, ... A: Sam You have a few options but I think the easiest would be a pivot table (depending on the layout) ... | |
| Excel formula question | 9/19/2008 |
| Q: I am having trouble converting the format of the way our AS400 is spitting out dates. For instance ... A: Michael There is but the problem you have is that excel doesn't know what year it is 1908, 2008, ... | |
| Excel 2003-Percentage of total | 9/19/2008 |
| Q: this seems simple but couldn't make it happen. Simple column information: Always 27 Sometimes 6 ... A: Rhonda The only way is to add another row or column If you add another row you will have to ... | |
| Subtract Dates & add weekday duration of days MS Excel 2003 | 9/19/2008 |
| Q: please help me!!! in column B I have a list of projects column D, a start date column E, an end date ... A: Ginger The graphic sent is hard to read but if you want you can send a copy to ... | |
| timesheet template | 9/18/2008 |
| Q: I'm glad you aren't a VBA expert, because I really don't want this to get that involved. I'm ... A: Callie The only way to get the sheet name to change to what is in a cell is to use a macro like ... | |
| Populate cell based upon what is selected in drop down | 9/18/2008 |
| Q: I created a list of part numbers and prices on one worksheet,"PriceList" in two columns. (A=Name, ... A: Chris If the list is in Alphabetical order you can use VLookup have a look at this link ... | |
| 2009 Calender | 9/17/2008 |
| Q: I need to make a calendar for 2009. I have already downloaded a form form Microsoft office 2003, ... A: Jessica You could create your own monthly calendar based on a variety of options. Does it have to ... | |
| excel formula | 9/17/2008 |
| Q: How do I insert the word "profit" in a cell once and only once over 4 quarters, even though I made ... A: Sorry not sure if I understand that part. If you are showing a profit it should be in the positive ... | |
| Zip code formula | 9/16/2008 |
| Q: I want to create a formula that will recognize zip codes and assign a pre-determined person to that ... A: Carl Depending on how your spreadsheet is set up will depend on the best option for you. If you ... | |
| extracting data from an array | 9/12/2008 |
| Q: I have two columns. Column "A" has numerous "monthly" dates (3/24/07, 2/12/05, etc), out of ... A: Damian You can us a Sum and If statement using the Array option to get what you need. I will ... | |
| Change cell colour with specific text | 9/12/2008 |
| Q: I hope you can help, I am new to excel, I am using 2003. I am trying to get a cell to change color ... A: Jimi You can use conditional formatting for what you need. Select the cell that you want to change ... | |
| displaying a message when a file opens | 9/11/2008 |
| Q: I know how to set up a simple macro the display a message when an excel file is opened, but in order ... A: Sam There is no way to force the user on the other end to enable the macro (which is a good thing ... | |
| Expressing < value on Excel | 9/8/2008 |
| Q: How do I graph <1 on an excel bar graph? What equation or formula do I use to show <1 on the graph? A: Laurie I am not sure what you are looking for, when excel creates a graph it looks for solid ... | |
| Excel- multiple sheet referencing | 8/22/2008 |
| Q: This is with regards to maintaining time sheet records. I have 100 employees. Each row in the sheet ... A: Ravi You can link the Total hours worked sheet to each individual sheet by typeing and = and then ... | |
| vlookup | 8/22/2008 |
| Q: I'm having an issue with the vlookup formula. I have 2 spreadsheets. One with employee deductions ... A: adam Can you send me an exact copy of the file without the SSN's so I can insert my own and see ... | |
| Printing lables | 8/21/2008 |
| Q: I have created set of data in Excel for entries in a dog competition. I can print one set of labels ... A: John This can be done but it will require either creating extra entries for each label or creating ... | |
| labels | 8/21/2008 |
| Q: I have MS Excel 2002. How do I print labels without one line (the phone number)?/ If you could ... A: Gabe Excel wont print labels, it will only print what is on the sheet. You can set up the ... | |
| Excel 2000 | 8/21/2008 |
| Q: I have a co worker that was trying to watch a video on her computer and all of a sudden the screen ... A: Tracey The view shows 100% means it is at the default, what is showing in the View menu? Normal or ... | |
| labels | 8/20/2008 |
| Q: I have MS Excel 2002. How do I print labels without one line (the phone number)?/ If you could ... A: Gabe You will need to create a mail merge document in Word to get what you need. This link ... | |
| transfering data from excel into a letter format | 8/18/2008 |
| Q: I am trying to see how I can take information such as rebates from total costs (I can do this) and ... A: Melissa The easiest way would be to name each column individually and then mail merge them to your ... | |
| Measure on Time performance | 8/16/2008 |
| Q: Iwanted to measure On Time Performance of our Engineers. The provide a forecast of when the job will ... A: Neetu You can use something like this in the cell that you want to get the finished date. Just to ... | |
| excel dates in one cell | 8/14/2008 |
| Q: I am trying to write a function that reads a cell if it is between certain dates. Such as one cell ... A: aaron The formula will need a date to use for an example but here is a sample of what you will use ... | |
| Change font color of the row based on a cell value | 8/14/2008 |
| Q: Please help me to change the colour of entire row based on the value of one cell of the same row. ... A: Aji I am assuming that you are using data validation and a list for the drop down selection. ... | |
| Question on print sub total | 8/13/2008 |
| Q: If u could answer to my question. you have simplified my work from 1 day to 5 minute. I am working ... A: abdul I don't know which version of excel you are using but have a look at the subtotal options and ... | |
| decimal points | 8/13/2008 |
| Q: I'm looking for a formula in excel such that if a product is "5" it will format as "5.0" -- problem ... A: Pat It isn't clumsy, when you get to 4 or 5 lines of formula then it gets clumsy. You actually ... | |
| Excel 2000 | 8/11/2008 |
| Q: I have a co worker that was trying to watch a video on her computer and all of a sudden the screen ... A: Tracey A possible solutions is that Excel uses the printer to display how it looks, I would suggest ... | |
| excel question | 8/5/2008 |
| Q: This is not a home work assignment - I am a business owner trying to simplify my computing what my ... A: Anne Sorry about that, we get so many of these that we sometimes mistake a real question for a ... | |
| changing cell values according to predetermined criteria | 8/5/2008 |
| Q: Not sure that subject was even close to what I want, but essentially I am trying to do the ... A: Sam This is possible using a Vlookup option that will look at a sheet that has all those options in ... | |
| excel copy and paste clipboard | 8/1/2008 |
| Q: I am constantly copying and pasting data from one excel to another and the clipboard is not useful ... A: Rachel When the Clipboard task pane is active click on the Options, then clear the show office ... | |
| copy file to another location | 8/1/2008 |
| Q: I have a master file used for inputting staff leave etc. How can i setup a command button in Excel ... A: Anwar You can create a macro saving the file with read only properties. I am not a macro expert ... | |
| conditional formatting | 7/22/2008 |
| Q: I am hoping you can help me with something I just can't figure out. I've tried conditional ... A: Pat In cell b2 go to Format > Conditional Formatting and in the condition 1 box select Formala is ... | |
| Convert number to date | 7/21/2008 |
| Q: I have dates in the format 20080612 which means June 12, 2008. How can I convert these cells from ... A: Jay You can use the Text to columns option in the Data menu, select the cell/s/column you want ... | |
| obtaining the average of a set of numbers | 7/21/2008 |
| Q: i want to obtaing the average of the largest 5 numbers in a range of 7 numbers using excel. How do i ... A: You can use this array formula (to enter and array formula type in the formula then press the ... | |
| pie chart - changing colors | 7/18/2008 |
| Q: I created a pie chart and I am requested to change the colors on my pie to look like the same colors ... A: Rachel Make sure you have both charts open so you see the colors being used in the other one, then ... | |
| Unique row combined | 7/17/2008 |
| Q: I am having a problem with Excel concerning the appearance of multiple values. I have on sheet ... A: Jonathan You could use the filter data option under Data menu. You can use the Auto filter if you ... | |
| Importing into excel | 7/16/2008 |
| Q: I am trying to import date from another excel spreadsheet. There is one column that contains both ... A: Todd The one column should only be text (including the numbers) unless the formatting is for text ... | |
| Excel Error Unable to read file | 7/16/2008 |
| Q: I'm trying to open a excel file that after the password gives me an error message: Unable To Read ... A: Ironman There can be compatibility problems between mac and window versions of Excel, they would ... | |
| Drop down list on webpage | 7/16/2008 |
| Q: G'day Richard, Thanks for getting back to me so quickly. I lived in Aussie (first Brisbane and ... A: Tim Is the photo in the excel sheet? If it is then it will also download as long as it is embedded ... | |
| Excel | 7/10/2008 |
| Q: Please help me. I need a help concerning an excel work sheet. In a cell when a date is entered – ... A: Rita You could use conditional formatting in the cells after that one. ie In Cell A1 type in ... | |
| IF & lookup functions | 7/10/2008 |
| Q: I suspect this is a very basic query but I am a complete novice with Excel so here goes! I need a ... A: Tim From the looks of it you just need an If statement (however if it is more complicated than that ... | |
| if cell Ax identical to Ax+1 then copy Bx to Bx+1 | 7/7/2008 |
| Q: The problem: I have many identical A cells. I want to make a function that if Ax=Ax+1 then to copy ... A: Dan I am a little confused by the question. Do you want to copy cells that aren't repeated? or ... | |
| Filtering Time | 7/2/2008 |
| Q: "I have time data like this.... 1:00:00, 1:05:00, 1:10:00, .... 13:00:00, 13:05:00 etc... I need to ... A: Jon I am not a VBA expert so hopefully this solution will work for you In another column (I am ... | |
| Phone numbers formatting | 7/1/2008 |
| Q: I am having an issue with over 2,000 phone numbers so that I can export them into a database. All ... A: Andy You have a few options In the column next to this one =left(10) will copy just the first 10 ... | |
| Excel 2003 compatibility with Excel 2007 | 7/1/2008 |
| Q: I am currently distributing an Excel 2003 shared spreadsheet to 12 individuals for updating and ... A: Gary They can save the file in xls format, they just need to go to file save as and and change the ... | |
| second page | 6/30/2008 |
| Q: I have done both an Excel and a Word document. I typed both of these documents right to the very end ... A: Linda You need to open the template, press Ctrl + End to move to the last point in the document and ... | |
| Excel Issue | 6/25/2008 |
| Q: I have an Excel sheet up and a huge number of hyperlinks to pdf files. Now when I click on those ... A: Will I haven't used jaws but I did find a problem with 2007 but sadly that wont help. If you open ... | |
| increasing all cells by a % | 6/25/2008 |
| Q: I am creating a spreadsheet and I have been asked to set up a formula to increase certain cells on a ... A: Joan If the cells are random then the only way would be to do it manually, you can create the ... | |
| Vlookup | 6/24/2008 |
| Q: I have data sheet that contains the following: BAND SALARY 1 Vlookup 2 3 4 5 6 7 So what ... A: Dominic You need to have a separat sheet/area on the current sheet that has your salarys. Ie A1 ... | |
| monthly dispersements, | 6/23/2008 |
| Q: I glanced through your miriad of answers and didn't see what I needed so here is my question. I have ... A: Ken Without looking at the exact setup you could create a formula that would remove the ... | |
| Using IF to find a product | 6/21/2008 |
| Q: I'm Cell A2 contains number days worked per year (ie. 241) Cell B2 contains number of hours worked ... A: Tim I am a little confused with the question. You don't mention product inthe E2 cell, you are ... | |
| If Command | 6/17/2008 |
| Q: I need an if command to total the number of check marks in a column. This seems so basic, but I ... A: Jennifer You can use a SumIf to total the range (The check marks could be a problem depending on ... | |
| Changing order of rows by date | 6/16/2008 |
| Q: I know next to nothing about Excel, but have been asked to organize information already in a ... A: Chris If the dates are all in one column and the column has headers ie a list at the top of each ... | |
| Excel | 6/13/2008 |
| Q: I am doing an audit for a company, and I have to do a spreadsheet with all the different inventory # ... A: Junior The only way you could do this would be to use a vlookup that would access all the ... | |
| IF THEN macro | 6/13/2008 |
| Q: Screening Coordination Fee Locations 1-5 $10,000.00 6-15 $15,000.00 16-30 $20,000.00 ... A: Jessica For this example we will assume that the cell you are looking at is A2, the formula will go ... | |
| Excel | 6/12/2008 |
| Q: I am currently learning, on my own with the help of a book, how to use an Excel spreadsheet. To ... A: Linda Entering informatin directly in the cell is the usual way to go I just don't understand why ... | |
| deleting rows in a worksheet linked to others | 6/11/2008 |
| Q: I am using information (inventory items) from one workbook while I am building a second workbook of ... A: Elaine How are you linking the sheets? If you are just using cell references then that is your ... | |
| Excel | 6/11/2008 |
| Q: I am currently learning, on my own with the help of a book, how to use an Excel spreadsheet. To ... A: Linda Question 1. I haven't come across this one before. When you enter the new information are ... | |
| Concatenation | 6/10/2008 |
| Q: Richard, I am working with excel 2003 and I am given the full name of someone and need to have it ... A: Jasson Without going into VBA which I am not familiar with you can try this. Split the column ... | |
| Excel | 6/9/2008 |
| Q: I am currently learning, on my own with the help of a book, how to use an Excel spreadsheet. To ... A: Linda You can Select the sheet by clicking on the empty square above the 1 in the row numbers, go ... | |
| Conditional Formatting | 6/9/2008 |
| Q: I wonder if you can help. I have been trying to figure this out with no luck. I have a list of ... A: Henry If you are using Excel 2003 go to this link and have a look at the sample sheet I set up. If ... | |
| Just type the word | 6/7/2008 |
| Q: Sir, how r u hopefully fine sir, my question is in A1-(hardeep kanwar), ... A: Hardeep See if this link is more what you are looking for http://www.mrexcel.com/tip096.shtml You ... | |
| Changing a cel color | 6/7/2008 |
| Q: I have used conditioning to change cell colors when entering a value I can not figure out how to ... A: Eddie That was my error, I transposed your cells. Highlight cells C2 to C82, Format > Conditional ... | |
| evaluate time difference | 6/5/2008 |
| Q: I work at a transportation company and I have set delivery times for my trucks. Some deliver early ... A: JR Excel does not like negative times. To get negative time to show you have to change the time ... | |
| Excel alerts | 6/5/2008 |
| Q: I am setting up an HR related spreadsheet detailing dates of supervision and when ... A: Eve What version of excel are you using? With the version number I can give you the instructions ... | |
| copy in excel | 6/2/2008 |
| Q: How do I copy a number from any row to the same cell. Meaning, everytime I enter a new number to a ... A: Heidi I am a little confused. Do you want A2 and A3 to go into cell D2? If so it can't be done ... | |
| sheet protect | 6/2/2008 |
| Q: Richard Is it possible to protect a sheet as read only, but allowing users access to only one cell. A: John It is possible. I will give the instructions for Excel 2003 if you have a different version ... | |
| Excel IF | 5/28/2008 |
| Q: Is it possible to build a formula that works like this: Column AD AE AF AG AH If there is an x in ... A: Rhonda It does make sense but isn't doable the way you describe. It would create a circular ... | |
| excel & macros | 5/23/2008 |
| Q: I recently created a macro for a specific workbook. This was my first "macro" experience. Now ... A: Deb Start a new document and press Alt + F11 this will open the VBA editor. Go to VBA Project and ... | |
| Find, replace text. | 5/22/2008 |
| Q: I have a list of asset names. Example Burger King, McDonalds, National Money Mart, etc. I get a file ... A: Fernando You could use a vlookup referencing another sheet that has all the clients names and all ... | |
| Update data without links | 5/20/2008 |
| Q: I am running office 2003 on XP SP2. I have a worksheet with sales data, sales enters the quantity ... A: Seth I have been looking at the files and have forwarded it onto a VBA expert that I know. If it ... | |
| excel problem | 5/16/2008 |
| Q: In one column are opening event dates. In the next column is the closing event date. I need a ... A: Trish The simplest option would be add another column that will show a 1 if the events has gone ... | |
| Formula For Subtraction | 5/14/2008 |
| Q: I am trying to deduct 9% from the balance in the total cell. Example: One cell says $100.00 the cell ... A: Casey The formula would be (where A1 has 100) =A1-(9%*A1) You can also link the formula to another ... | |
| excel 2003 | 5/12/2008 |
| Q: how do you insert a formula into a cell from one worksheet that automatically pulls information into ... A: Jacqueline If you want to copy the formula select the cell that the formula is in and go up the ... | |
| Excel stuff | 5/10/2008 |
| Q: in my column A there is a long list of 1000 items in column b there is the price of each item. in ... A: Darill In column D and in cell D2 the formula would be =B2*C2 you can then drag that down the ... | |
| Pivot Table - No Function | 5/8/2008 |
| Q: I am trying to make an event calendar that users can refine based on a number of areas (Region, ... A: Jeff You could try a vlookup but It would be better if I could see the spreadsheet. If this is ... | |
| mark up on top of markup as a percentage | 4/1/2008 |
| Q: I do a mark up of 10% and then on top of that a mark up of another 10% i.e.(10% overhead & 10% ... A: Move to the bottom of the cell with the formula in it and click and drag on the little black square, ... | |
| mark up on top of markup as a percentage | 3/31/2008 |
| Q: I do a mark up of 10% and then on top of that a mark up of another 10% i.e.(10% overhead & 10% ... A: Dan You could create a formula and layout like this The starting amount in A2 The Overhead in B2 ... | |
| EXCEL IF-THEN QUESTION | 3/28/2008 |
| Q: I have a list in which column B has a list of part numbers in use, and column A has a quantity. I ... A: Greg I have set it up two ways, the first uses a cell reference in the formula. For this example ... | |
| Excell Worksheet question | 3/27/2008 |
| Q: I am doing financial worksheets for members of my church and would like to be able to print ... A: Karen You can link the main worksheet to the other ones by inserting a cell reference into the ... | |
| Fixed Tab | 3/27/2008 |
| Q: How can I cause that the Excel will open with specific tab? Example: I have 3 tabs – A, B & C. the ... A: Nir You need to create an AutoOpen macro that will run each time the workbook is loaded. In the ... | |
| excel links with variable addressing | 3/26/2008 |
| Q: I have a number of separate spreadsheets that constitute a data base. I want to be able to call data ... A: Chris You will need to run some sort of VBA i am assuming (as I am not a VBA expert I can't ... | |
| applying filter to all sheets | 3/23/2008 |
| Q: I am a fairly new Excel user and wanted to know if it is possible to link all 5 sheets in my Excel ... A: Charlotte This requires the use of VBA. Sadly I am not a vba expert but this link may help you ... | |
| Excel formula not working except when I hit enter in formula bar | 3/20/2008 |
| Q: My excel stopped working properly recently. I have a formula which is supposed to calculate lbs ... A: Meredith It sounds like the Automatic Calculation may have turned off somehow. In Excel 2003 go to ... | |
| Filling Blank Cells based on another cell | 3/19/2008 |
| Q: I have a spreadsheet of phone calls made that has 8 different columns of data. I have it sorted and ... A: Sara You could create a vlookup that would access a list that has the telephone numbers that you ... | |
| Excel Sum always zero | 3/19/2008 |
| Q: I work with 2003 at my current job and recently my sum function sporadically stops working. For ... A: Tanii Try this first check that setting on the menu Tools->Options->Calculation Tab. If it is in ... | |
| Drop down list and conditional formatting | 3/17/2008 |
| Q: Office Excel 2003 I have a drop down list on WS1. That list consists of 50 text descriptions or ... A: Martha You could use a Vlookup as long as the names on WS2 are in alphabetical order. It would ... | |
| Percentage | 3/11/2008 |
| Q: I need to know how to add a percentage to a number in Excel 2003, like if I were to add GST to a ... A: If you want 10% added to say 68.50 the formula would be =68.50*10%+68.50 or using cell references ... | |
| Turning letters into numbers | 3/11/2008 |
| Q: Do you know of a way to turn letters into numbers in Excel? i.e A is displayed as 10, B as 11, C as ... A: Veer You can create a seperate table for the numerical equivalant and then use a vlookup to access ... | |
| Copy column into sheets | 3/6/2008 |
| Q: I have a list (column) of text that i need to copy into the same cell reference on multiple sheets ... A: Reema This can probably be done using a macro/vba. I am not an expert using vba so would suggest ... | |
| Copy column into sheets | 3/6/2008 |
| Q: I have a list (column) of text that i need to copy into the same cell reference on multiple sheets ... A: Reema You can copy the list,then select the first of the sheets that you want the text to go into, ... | |
| Adding comma after first word in a cell | 2/22/2008 |
| Q: I have a worksheet with the last name first then the first name in the same cell. I want to insert ... A: Suzanne Insert a new column to the right of the last name. In the first cell type in (assuming the ... | |
| Cell protection by password | 2/21/2008 |
| Q: I am after a way in which I can password protect a cell by VBA script or other means which when the ... A: Mark This is a simple way of doing what you need. Assume you wish to password protect cells A1 to ... | |
| uploading spreadsheet problems | 2/20/2008 |
| Q: I update and upload a modestly large spreadsheet everyday and send. Lately it is taking up to an ... A: Anna Theoretically your upload should only take about 3 minutes at around 60 KBps upload which ... | |
| populating list/drop-down menu | 2/19/2008 |
| Q: i have 2 separate questions: 1)i have a worksheet which enables drop down lists. when i click on ... A: Duane When you select the cells for the drop down list are you also selecting blank cells? This is ... | |
| uploading spreadsheet problems | 2/19/2008 |
| Q: I update and upload a modestly large spreadsheet everyday and send. Lately it is taking up to an ... A: Anna The problem is more than likely your internet connection or the size of the file, find the ... | |
| Customizing Paper size for printing in excel 2007 | 2/17/2008 |
| Q: I am using Excel 2007 (Home Edition). I want to print an excel file on a paper size of 5 x 11.5 ... A: Sarfraz Follow these steps. If you can't find the custom option then there is a problem with your ... | |
| excel hyperlink | 2/16/2008 |
| Q: I had a hyperlink in a workbook of an older version of excel that would activate if you were on the ... A: Randy They took this functionality out of 97 and there is nothing to replace it as far as I can ... | |
| Excel - Tee Times | 2/15/2008 |
| Q: I would like to create a very simple spreadsheet that will enable me to list golfing tee times at 8 ... A: Sue In the time Cell type in your start time ie 7:00 In the cell below put in this formula ... | |
| Pie-chart and bar graph shadow color | 2/14/2008 |
| Q: I had a quick question on 3-D pie charts and bar graphs. Is it at all possible to change the color ... A: Rohan If you are wanting to put the shadow around the outside the cell it isn't possible to change ... | |
| Customizing Paper size for printing in excel 2007 | 2/13/2008 |
| Q: I am using Excel 2007 (Home Edition). I want to print an excel file on a paper size of 5 x 11.5 ... A: Sarfaz I have looked at the manual online and it does have that option to customize paper sizes. ... | |
| Background text | 2/10/2008 |
| Q: Its a simple query but unable to solve.How to creat a text at the background of the page. If I am ... A: Vikas I found this question in the question pool. You may want to have a look at these links. As ... | |
| Excel formula | 2/8/2008 |
| Q: I use Excel 2003 in a spreadsheet that I created. Each month I need to get totals for certain rows ... A: Bob You can certainly send me any follow ups or new questions. If you like you can use the ... | |
| Vlookup of a sum product??? | 2/7/2008 |
| Q: or something to that effect I need the value of a field that also has two other specific criteria in ... A: Sarah You could us something like this (without more information on how your sheet is set up though ... | |
| Cell alignment in Excel | 2/6/2008 |
| Q: I am trying to do a spreadsheet with dollar signs aligning on the left and numbers aligning on the ... A: Kathy There must be a problem with how Excel is set up on your system. the accounting option has ... | |
| V-Look UP | 2/6/2008 |
| Q: I am trying to automate the V lookup function since a spreadsheet (1) I work on always requires two ... A: Michelle Using the Vlookup should be automatic. I am a little confused with the question though. ... | |
| Excel Date Copy/Paste Function | 2/5/2008 |
| Q: I'm trying to copy/paste as well as merge a date field from one spreadsheet to another from two ... A: J There must be a calculation error somewhere. Can you send the files to me so I can see what is ... | |
| Excel formula references to another worksheet | 2/1/2008 |
| Q: I am attempting to create the following formula "=Sum(...") However, I want to use data from ... A: adriana There is no reason for what is happening unless you have the cells locked but as you have ... | |
| Excel | 2/1/2008 |
| Q: I have a list of around 1000 values so that would take me forever!!!Thank you. ANSWER: roslyn are ... A: Roslyn The vlookup should work for you, in the cell next to the existing cell in the first workbook ... | |
| Parsing data in cells | 2/1/2008 |
| Q: Some cells in my spreadsheet contain both alpha and numeric data (ie 1 E all in the same cell). I ... A: Steve It works is all that matters, I would have gone a similar route, it may be easier to do it ... | |
| Re: Percentage | 1/31/2008 |
| Q: Richard, I have a spread sheet stored with data on equipment operating hours. I now need to produce ... A: Abe That is the correct way to do it and when I try it I get 95%. Just to make sure though are you ... | |
| Excel | 1/31/2008 |
| Q: I have a list of around 1000 values so that would take me forever!!!Thank you. A: roslyn are the values all unique? Can they be sorted? if the answer is yes to both you could use ... | |
| Index functions and drop down boxes | 1/30/2008 |
| Q: I have what are called cost centers. Each cost center has expenses associated with it for each ... A: Sarah I would set up the table as you have described and then on another sheet create a pivot table ... | |
| excel program? | 1/29/2008 |
| Q: I have a shop and I have a lot of consignors whom i pay a percentage monthly for whatever they have ... A: cara There are quite a few programs out there but I haven't tried any as I used excel when I was ... | |
| functions | 1/29/2008 |
| Q: Can you substitute other characters besides spaces? If so, can you use the substitute function to ... A: Donita You could use the find and replace option but it would take a while depending on how many ... | |
| I'm stumped | 1/25/2008 |
| Q: Can I have a MAX function display the max number and the text that's in the cell next to the highest ... A: Thomas I am using A1:A6 for the text and B1:B6 for the numbers. Change the references to your ... | |
| Conditional Formatting | 1/24/2008 |
| Q: I have a spreadsheet with many contacts on it, as I go through and confirm all details I want those ... A: felicity When you create the conditional format highlight all the cells that the formatting is to ... | |
| question | 1/24/2008 |
| Q: I'm trying to figure out how to put an average time onto excel and sum them all into one. I'm not ... A: Tiffany The easiest option would be to use 0:0:25 when you type in the seconds and format the cell ... | |
| Excel links | 1/24/2008 |
| Q: I have the followingI have no problems linking between sheets in the same workbook. My problem ... A: What version of Excel are you using? Can you send me a copy of the file? The other steps are to ... | |
| works 8,5 xcel | 1/23/2008 |
| Q: I just upgraded to works 8.5 on a Dell vostro pc. I can convert my old .xls files without a problem. ... A: Scott If you are using the spreadsheet in Works 8.5 it is actually a downgrade from Excel not an ... | |
| subtotals using formulas | 1/22/2008 |
| Q: I have a table of bank services with columns that include account #, service#, description, price, ... A: Nathan Have you looked at the subtotal option in Data menu or pivot tables. Here is a link to both ... | |
| Help with formula/frequency | 1/22/2008 |
| Q: I have a quick question. I am working on a sheet and want to calculate daily average sales in $$. ... A: The problem is that you can't divide by zero which is what is happening when you include blanks in ... | |
| Charting | 1/22/2008 |
| Q: I am using Excel 2003. When modifying a chart and adding an item in Series Data > Series Window ADD ... A: Once you have inserted your new series right click on your the New Data Series (or whichever one you ... | |
| Help with formula/frequency | 1/19/2008 |
| Q: I have a quick question. I am working on a sheet and want to calculate daily average sales in $$. ... A: steve Do you have any blanks in the cells? if so then that is what is happening, it can't divide a ... | |
| IF statement in Excel 2003 | 1/18/2008 |
| Q: I wondered if you could help with an IF statement I'm trying to write. Basically, I have a cell, A1, ... A: Kim Here is your nested if formula ... | |
| Help with formula/frequency | 1/18/2008 |
| Q: I have a quick question. I am working on a sheet and want to calculate daily average sales in $$. ... A: Steve As far as I know it can be done only in two steps, the first step will be to count the number ... | |
| excel function formulas | 1/16/2008 |
| Q: I have several different groups of information that I want to write a formula for that is based on ... A: Amanda A vlookup should be able to do this but you would have to set up a seperate sheet with the ... | |
| excel formula | 1/16/2008 |
| Q: I'm struggling with a formula in Excel 2003. simply put, I'm trying to calculate the sum of a row ... A: Ollie I am a little confused as to where the date goes but I am assuming the date is in its own ... | |
| Re: UPC Scanner with excell | 1/16/2008 |
| Q: ... i understand you cant directly link a scanner to excel but i do have a scanner hooked up to the ... A: Kevin It should, depending on how the table is setup, if you have seperate sheet that accesses the ... | |
| #value! | 1/16/2008 |
| Q: I have a spreadsheet which reads in data from another sheet. It then checks the date to make sure ... A: Keith The permissions given to the account should affect a formula in Excel as far as I know, but I ... | |
| Tab Key in Excel | 1/16/2008 |
| Q: I have a spreadsheet made with Excel that has 6 columns. After I finish entering data for each row, ... A: Roger You can only do this by selecting the columns and rows before entering the information, this ... | |
| Exporting Excell data to MS Access | 1/15/2008 |
| Q: I want to ask how to export data (e.g. customer and product data) to M.S. Access? A: Dan Create a blank database in Access and then go to the (2007) External Data tab and select Excel ... | |
| Sequential numbering. | 1/15/2008 |
| Q: I have an excel template for invoicing. I would like to have a field auto populate with a sequential ... A: Jason Have a look at this link, it has a zip file that has what you need. ... | |
| #value! | 1/15/2008 |
| Q: I have a spreadsheet which reads in data from another sheet. It then checks the date to make sure ... A: Keith This generally indicates a problem with one of the cells the formula is looking up. Is it ... | |
| Countif between two specified dates | 1/11/2008 |
| Q: I need a formula that will count the number of times a date is listed between two specific dates. ... A: Andrew You have two options. You can type the formula with the date or use two reference cells (I ... | |
| excel | 1/11/2008 |
| Q: "i want to return a date for text or numbers entered into a cell ex: if cell "e3" you enter number ... A: Kimberly This needs to be done using vba. Right click on the sheet that you want the code to be ... | |
| leading zeros | 1/10/2008 |
| Q: I am using Excel 2000 and have a column with numbers with 6 leading zeros. I want to remove the ... A: Nancy You can format the cell to show just numbers. Go to Format Cell and choose number, the ... | |
| Excel Subtotal for a specific page | 1/10/2008 |
| Q: I am using Excel 2000 and am currently working on my company's Inventory report, is there a way to ... A: Josh You can definitely run a subtotal, but I would need more information on how the table is set ... | |
| Populating multiple forms from one set of data | 1/9/2008 |
| Q: I am wondering if you can help me out. I need to know how to populate multiple excel forms with one ... A: Leigh This sounds like a Word question but I will give it a go in Excel. You can link each cell ... | |
| Excel | 1/8/2008 |
| Q: I am having trouble figuring the formula to show Markup percentage not just percentage of items. We ... A: John This formula will give you the markup percentage. We will assume you have the Cost price in ... | |
| Combining Bar Charts | 1/8/2008 |
| Q: I am trying to combine a single bar chart with a stacked bar chart so that I have three bars per ... A: Jenna This link has all the possible options (as far as I know) for combining charts. I am not ... | |
| Excel limit. | 1/5/2008 |
| Q: I read Microsoft Excel has a limit of 65,535 samples or rows per page? Is that still the case for ... A: Richard I would back up important files to (1) a second hard drive, (2) a DVDRW, and (3) zipped and ... | |
| Excel limit. | 1/4/2008 |
| Q: I read Microsoft Excel has a limit of 65,535 samples or rows per page? Is that still the case for ... A: Richard this link explains most of the changes in your area ... | |
| Excel ques - function or formula help | 1/3/2008 |
| Q: As part of a simple estimating worksheet we would like to have a list of items (say Outlet,Switch, ... A: Ken Create a seperate table with all the information you want and then use a vlookup to fill in the ... | |
| adjusting column width | 1/2/2008 |
| Q: Is there a way you can "cut the page in half" and have the the width of a certain column in the top ... A: Bre You can either use a table with one column and 2 Rows and expand it to cover the entire page or ... | |
| pasting html into another excel spreadsheet | 1/1/2008 |
| Q: I'm trying to copy an html description from one excel spreadsheet to another, however it cuts all ... A: Michael If you have a cell next to the one you are copying it into it will cut off the information ... | |
| Golfing tee sheets | 1/1/2008 |
| Q: I have been asked to create a Golfing tee off time sheet. Currently the tee off sheet that is being ... A: Samuel Unless you want to print them in advance why do you need all the dates? If you want to get ... | |
| IF and MAX Statements | 12/31/2007 |
| Q: I have a row of numbers, say for instance 1234567. I want to find the highest score from those ... A: Rob Lets assume that column A has the figures then the formula would be ... | |
| Dropdown boxes | 12/29/2007 |
| Q: I am attempting to make a spreadsheet to enter all sales from each day. I think I need to create ... A: Igor Depending on how the original table is setup ie alphabetical with no duplicates you could use ... | |
| Excel | 12/28/2007 |
| Q: When using Excel (2000 and 2007), I noticed that when I entered a 16-digit number ending in a 5, ... A: Heather Excel's number precision is limited to 15 digits, which basically means that any digits ... | |
| custom format-excel | 12/28/2007 |
| Q: I have a report that requires a format of S000, with various departments and may end with a t,v or ... A: Mel Is it listed anywhere in the spreadsheet. The reason I am asking is that if it is you can use ... | |
| Excel changing the tab names and file names | 12/22/2007 |
| Q: Richard, I am using Windows XP at home and I believe it's Excel 2003 at the office. When I send ... A: John How do you send the files to your home? If it is in a link make sure you are attaching the ... | |
| Mode of a list of combinations | 12/22/2007 |
| Q: Is there any way of getting Excel to return the number of occurances of a certain combination of ... A: Kim The simplest way would be to concatenate the cells like this in E1(assuming we start in A1) ... | |
| Shared Workbook | 12/21/2007 |
| Q: I am using these same spreadsheets on a network drive and I have multiply people using them at the ... A: Eric apart from recreating the entire thing in Access the earlier way is the safest at the moment. ... | |
| Advanced IF Statements | 12/17/2007 |
| Q: I need a formula that will return a Letter grade for a range of numeric grades. For example A = ... A: Jeremy The If statements will only go to 7 nested ifs generally and changing the ones that go ... | |
| text adding to excel | 12/15/2007 |
| Q: I have a column of .jpg image names that I need to add the url to. In other words, I have 1000 rows ... A: Michael That can be done by adding the address to another cell next to the graphic then adding them ... | |
| Can you remove the 30 character limit? | 12/14/2007 |
| Q: It seems I've hit the limit to the number of cells I can include in a calculation. From what I ... A: Katherine 30 is the limit for 2003 and below. In 2007 you can have up to 255 arguments. As far as ... | |
| Comparing a Cell Value to a list | 12/13/2007 |
| Q: I've created a calendar in excel(well pinched)and am trying to add some conditional formating to ... A: Anthony Using the Conditional Format option from the Format Menu select formula is and using your ... | |
| How to get Excel to calculate a more accurate date | 12/13/2007 |
| Q: I have an a worksheet where I need to calculate the difference between 2 dates, excluding weekends ... A: Dan The network days is correct in the above formula, it is 4 days. The reason for this is that ... | |
| formulas using miltary time | 12/12/2007 |
| Q: I work in a small office. Our timeclock uses miltary time, and we need to come up with a formula ... A: Deb You can still type in 27:00:00 and it will change to 3:00AM and still work out the hours ... | |
| Merge Excel Files | 12/11/2007 |
| Q: Can someone help? I am trying to emrge 3 workbooks on excel, each with 2 common identifiers ... A: Sam It was supposed to merge under one another from reading the macro. If that isn't suitable the ... | |
| Merge Excel Files | 12/11/2007 |
| Q: Can someone help? I am trying to emrge 3 workbooks on excel, each with 2 common identifiers ... A: Sam Without knowing the exact setup have a look at these links, remember to use copies of the files ... | |
| character limit formula | 12/10/2007 |
| Q: I am formatting a spreadsheet that will be uploaded into an oracle application and I have a 30 ... A: Eric Select the Cells you want the limits on and go to Data > Validation, select Text Length and ... | |
| Programming Excel Based on Cell Value | 12/10/2007 |
| Q: I am working with a spreadsheet that divides titles based on a column A. Column A will have 2 ... A: Dustin You could use Data > Filter > Auto filter and select the one you want (this would be quicker ... | |
| Excel-copying formulas and conditional formatting | 12/10/2007 |
| Q: 1. Copying Formulas. -When I copy a formula from one cell to another, is it possible to have one ... A: Raj 1 You can lock the cell references you want by placing a $ sign in them ie your formula =B6+C4 ... | |
| Help with Macro | 12/10/2007 |
| Q: I have a simple excel Macro editing question which I hope you can help me with. I want to be able to ... A: Raj The simplest way is to create a name for the last cell on sheet two then create a macro like ... | |
| Excel Dashboards | 12/10/2007 |
| Q: I want to learn how to create excel dashboards.I have been through the templates at ... A: Gautum See if ths link helps ... | |
| Moving info between 2 different spread sheets | 12/10/2007 |
| Q: I'm pretty new at this excel stuff. I have created 2 spread sheets for my business. (rental ... A: Lowell Go to sheet 3 and put the cursor in B12 and type in = then click on the P&L sheet (or sheet ... | |
| Moving info between 2 different spread sheets | 12/10/2007 |
| Q: I'm pretty new at this excel stuff. I have created 2 spread sheets for my business. (rental ... A: G'day Lowell Depending on how the sheets are setup will depend on how to get what you want. If you ... | |
| excel | 12/9/2007 |
| Q: I would like to know the formula for calculating the coverage of concrete. Lets say I have an area ... A: Bob Set up a table similar to the following A B C D E ... | |
| excel | 12/9/2007 |
| Q: I would like to know the formula for calculating the coverage of concrete. Lets say I have an area ... A: Bob If you use feet as your base the formula would be (assuming the width and length is 50 x 40. 1 ... | |
| Difference in cents | 12/6/2007 |
| Q: My worksheets are quite often out by a few pennies but appear to be adding correctly. Do you know ... A: Kathy If the formulas you are using to figure out the costs are multiplaction or division then ... | |
| Comparing 2 Spreadsheets | 12/6/2007 |
| Q: Sir, I need some assistance comparing 2 spreadsheets. I have basic knowledge of excel but I have ... A: Saulo It isn't easy no matter which way you go but it would require a lot of VBA experience. To be ... | |
| Tracing excel history. | 12/5/2007 |
| Q: I'm an school teacher, and I prepared a project for the students, they have to type a list in excel, ... A: Andy You can look at the properties of the file to see if it has been shared, this will give you ... | |
| Linking If/then Statements | 11/28/2007 |
| Q: I have four unique number ranges, i.e. 2-50, 51-200, 201-500, 501+ when a specific value is ... A: Kiran You can use a nested if statement like the one following. I am assuming that the variables ... | |
| Excel summary sheet | 11/28/2007 |
| Q: Richard, Currently i have an excel workbook that i have created for construction estimating. The ... A: Richard You can reference the sheet name by using this formula ... | |
| Excel 2000 | 11/28/2007 |
| Q: I am running excell 2000 on two machines, one a tower is running on XP the othe a laptop running ... A: Peter I have tried a variety of different op systems but it opens on all of them here. I would ... | |
| zero values in pivot tables | 11/27/2007 |
| Q: The data source has columns for income and expense, so when I run a pivot table, I get an income ... A: Timothy This may work but I haven't tried it You can use a filter within the pivot table by ... | |
| Summing | 11/27/2007 |
| Q: I have a column of numbers. One cell has a superscript letter indicating a footnote. It will not ... A: Paul It wont do it while there is a superscript in the actual cell. You can change the format of ... | |
| dde share use | 11/27/2007 |
| Q: I wish to get the data in excel sheet from one PC excel sheet to another PC excel sheet with real ... A: rao The easiest option is to use a link, this will update when the original is updated if both are ... | |
| Wide paper print in Excel | 11/25/2007 |
| Q: I use XP and Office 2003. My only printer is an HP3310 which uses 8 1/2 by 11. I need to create a ... A: John One way is to get a printer driver that has 18" paper. Something like the hp designjet and ... | |
| Sorting Sheets | 11/23/2007 |
| Q: Richard, how would I go about sorting the "sheet tabs" according to date? All tabs are given a date ... A: Keith Nothing that comes with excel but you may want to look at these links and I am not sure it ... | |
| Count If Help | 11/23/2007 |
| Q: I'm trying to do a count if formula that has an if statement that includes two ranges and two if ... A: Adam Countif doesn't like more than one statement. You can use the sumproduct to do a better job. ... | |
| daily compounding interest | 11/21/2007 |
| Q: I would like to know the formula if i wanted to add say 1% to my starting bank of £750 and then 1% ... A: Ian In A1 put your starting amount 750.00 in B1 put 1% In A2 type in this formula =A1+(A1*$B$1) ... | |
| Excel Goal seek | 11/21/2007 |
| Q: I am working on an excell sheet. I think whoever used the sheet b4 me used goal seek to convert ... A: steve Not sure how they got that monthly rate it should be 0.00486929 without the percent, if it ... | |
| Macro/Input Boxes | 11/21/2007 |
| Q: I need to edit a macro i have recorded where it totals a range of numbers then adds a percentage to ... A: Tori I am sorry but I don't do VBA but I would think you would need to copy the information in the ... | |
| split cell values | 11/19/2007 |
| Q: My problem is: I have a list of 7 items ItemOne ItemTwo ItemThree Itemfour Itemfive Itemsix ... A: Hari Are the cells with the information seperated with spaces? if so you can use the Data Text to ... | |
| Replace #DIV/0! with value of Zero | 11/16/2007 |
| Q: I am using the following formulas to average a set of values from another worksheet and then average ... A: Karen I am not familiar with this type of problem (I see that aidan is helping you though which was ... | |
| Excel chart equation | 11/15/2007 |
| Q: I'm making x-y scatter plots in Excel (I'm using Excel 2007 primarily, but also Excel 2003 almost as ... A: Meghan Well I have to say I don't work with trendlines but you may find the following to be ... | |
| LAST COST ANALISIS | 11/15/2007 |
| Q: OK, IM WORKING ON A INVENTORY SPREADSHEET. ONE WORKSHEET IS WHERE IM ENTERING "INVENTORY IN". AS I ... A: Chad You can link the formula tothe Invent in sheet and this will give you the last cost for each ... | |
| PRINTING IN EXCEL | 11/15/2007 |
| Q: i open up ms money plus and go to print my portfolio, it automatically opens up excel and prints my ... A: Pete It sounds like the file has been associated or saved as an excel file. I don't know money so ... | |
| Excel time accumulation problem | 11/14/2007 |
| Q: I am using excel to make a time sheet. Evereything works until the time accumulation reachs 24 ... A: Al You could create the macro using the =today() function and the =Now() function for the date and ... | |
| converting data on mass | 11/12/2007 |
| Q: I've got a huge spreadsheet with currency all in shortened form i.e £3,600,000 is 3.6 I need to ... A: Susan Are the numbers all the same format ie if the cell has only 170,000 it would show as .17? ... | |
| Linking sheets | 11/7/2007 |
| Q: I have made an excel spreadsheet for a business my father works for. It is used for inventory and ... A: Tod You can link each page with the previous days figures if that is what you mean, if you want to ... | |
| Calculating a due date | 11/5/2007 |
| Q: I am running excel 2003. I have a start date in my first cell and wish to have a due date in the ... A: Scott To use this option you have to load the Analysis toolpack (unless it already is loaded) which ... | |
| print non-consecutive columns on one page? | 10/30/2007 |
| Q: I have Excel 2003. One of my coworkers asked me if there is a way to print columns that are not ... A: Dawn The Camera option will allow you to place the columns you want onto another sheet and then ... | |
| Paste Link / Paste Special | 10/30/2007 |
| Q: I have 6 spreadsheets in one workbook which are all identical in format for 6 company divisions. I ... A: Alan If you are just getting totals the formula in the totals sheet would look something like this ... | |
| Copy/paste macro | 10/27/2007 |
| Q: I have about 31 columns [representing days] and about 20 thousand records [representing rainfall and ... A: Rick This link has a few macros that will do what you want, you will need to change the amount of ... | |
| Copy/paste macro | 10/24/2007 |
| Q: I have about 31 columns [representing days] and about 20 thousand records [representing rainfall and ... A: Rick Without having to create a macro (which I would ask and expert who is into VBA for) I would ... | |
| Compare Columns to Find Missing Users | 10/23/2007 |
| Q: Mr. Stephens, I have been struggling with this for a few weeks, and been doing a lot of very sketchy ... A: Mitch I think this is a vba problem but thanks to Nick Hodge in England this may be what you need ... | |
| XCEL sort question | 10/19/2007 |
| Q: Greetings, I'm trying to change the order of column A based on the value of column B. I've ... A: Kris I don't think excel can do what you want. If you hightlight both columns then sort on B then ... | |
| Copy Column of Hyperlinks to Another Sheet | 10/17/2007 |
| Q: On Sheet 1 I have a column of employee names. Each name is hyperlinked to a Word document related ... A: John With the sheets you want to copy the linked names too showing, select and copy the names, move ... | |
| Excel function | 10/13/2007 |
| Q: I am interested to know, how i can change number format EX: 140 to 100 190 to 200 999 to 1000 ... A: Lee You need to use the Mround function. You can access this function by installing the Analysis ... | |
| Formula | 9/3/2007 |
| Q: I need help. For example if I want to type a number into a cell and have it so if that number is ... A: Robert Select the cells that you want to highlight if they go above 300 then go to Format > ... | |
| Turning a column of postive numbers into negatives | 8/22/2007 |
| Q: I have a column of positive numbers that I need to turn into negatives. I do not want to go into ... A: Anita The only way is to use another column and type in the following formula =A1*-1 where A1 is ... | |
| Check Boxes | 8/18/2007 |
| Q: This is probably a duh moment, but I've got a check box set up, linked it to a cell and have my ... A: Shawn If you use the form check box it must be locked so that it will work and if unlocked it can ... | |
| reg Excel (Office XP) | 8/17/2007 |
| Q: sir, while I enter a 20digit number in a cell. I was shown as 1.111111E+20 in (general mode), ... A: Sorry misread You need to also change it to text, excel is limited to 15 digits then it shows as ... | |
| Help | 8/15/2007 |
| Q: If I have two excel sheets having same work then is it possible that while working on one sheet ... A: Balwinder You can link the cells from one workbook to another by either copying and pasting as link ... | |
| saving files | 8/2/2007 |
| Q: I have an excel spreadsheet with three tabs of data. At the end of the work day, I have to give one ... A: Mike Try this macro Sub SaveOnlyOneSheet() Dim SheetName As String SheetName = ... | |
| using excel to find gaps in a collumn of numbers | 7/31/2007 |
| Q: I have recently discovered how to use conditional formatting to highlight duplicates in a column of ... A: Greg This can be done with reference to another column that has all the numbers that you are using. ... | |
| Random Selection | 7/30/2007 |
| Q: I have a sample size of 539 and I would like to pick 100 items in this sample to review. I used the ... A: Natasha All you have done is create a random number from 0 to 539 and each instance is another ... | |
| Speed of Macro's in Excel | 7/28/2007 |
| Q: I have a problem with the execution of macros in Excel. I use macros which i created in older excel ... A: Leo Removing and adding rows is changing the page layout for printing purposes. Why the change, ... | |
| charts | 7/28/2007 |
| Q: I am using a simple bar chart with the folowing x axis ... A: Brian One option is to revise your formulas to show the 0 answers as N/A, excel wont pick those up ... | |
| Copying in excel | 7/24/2007 |
| Q: I am using a formula(A1=" text " &I51 &" another text ") where in the i51 field is a number( for ... A: Lubo The easiest way is to Round the column using another column or adding to the formula that ... | |
| Excel (font colors) | 7/23/2007 |
| Q: For an example, I have a spreadsheet that consist of 4 rows and 4 columns. The cells consist of ... A: Young When you click on the cell it highlights the cell which then changes the color of the text. ... | |
| calculating military time | 7/23/2007 |
| Q: I'm working on a spreadsheet to determine the wait time in our ER. I have the time the patient was ... A: Kathy The military time is showing as 2100 for 9:00pm look for Entry of Military Time without ... | |
| If,then | 7/22/2007 |
| Q: I am trying to solve what I thought is a simple if,then formula. I am having problems. if B2>E2 ... A: Richard You need to use two formula In the cell you the text to appear you can use an if function ... | |
| calculating military time | 7/20/2007 |
| Q: I'm working on a spreadsheet to determine the wait time in our ER. I have the time the patient was ... A: Kathy Assuming that the times are in A2 for the admit and B2 for the time the phys saw the patient. ... | |
| find a name corresponding to a top mark | 7/19/2007 |
| Q: Let's say I have 5 student names in column A with their 5 marks in column B, is there a way to ... A: You can use a function that will show the highest mark and get the corresponding student. As long ... | |
| isolating values | 7/15/2007 |
| Q: I am trying to find a formula for Excel that will isolate the final 20 values entered in a ... A: Tj It will be a two step option involving a macro and then a formula. Will the answers be on a ... | |
| track changes in excel | 7/14/2007 |
| Q: Richard, How do I change my highlighted color when I save with the track changes on? A: Amber I am not sure that you can in Excel. I Know it is different than Word though. It may be a ... | |
| Excel | 7/13/2007 |
| Q: Here goes: I have a complete list of names and associated IDs in one database (Database A) and a ... A: Chris You can use a variety of options but I would need to know if any of the names are duplicates ... | |
| Linking multiple excel spreadsheets into a weekly summary spreadsheet | 7/13/2007 |
| Q: Is there a way to link 4 spreadsheets into one summary spreadsheet using Excel 2004? The data ... A: Soraya You can create a linked summary spreadsheet by setting up your summary sheet with links like ... | |
| Inserting Row In Linked Worksheets | 7/13/2007 |
| Q: I have an excel workbook with 3 sheets. Column A on all the workbooks contains the same ... A: Pam You can select the worksheets that you want the extra rows added to by holding down the Shift ... | |
| Remove last 2 digits from a cell | 7/12/2007 |
| Q: I have rather lengthy columns of 10 digit numbers. I need to remove the last 2 digits from each of ... A: Charles Insert a new column to the right of the id column and use this formula =Left(A1,8) assuming ... | |
| excel | 7/11/2007 |
| Q: I need a formula to retrieve the Sum of the following. I have names in column C and numbers in ... A: Dennis If you are only doing this once then this formula will do it =sumif(A3:B8,"Barry",B3:B8) ... | |
| Rotating schedule | 7/11/2007 |
| Q: I am sorry to bother you with what you may consider a very basic question. I created a ... A: Eric You would have to have columns of data within the workbook showing what days they work ... | |
| formula for sum | 7/6/2007 |
| Q: I have some numbers typed in one column (a1:a2). In those numbers some are even numbers & some are ... A: Santosh Rearrange this formula to suit your setup Assuming the cells are in range A1:E1... In ... | |
| Conditional Formatting - possibly? | 7/5/2007 |
| Q: is it possible to enter a number which returns a letter, eg by entering a "1" I want to display a ... A: Jackie You would use an if statement as long as there are not more than 7 nested if statements. ... | |
| download excel | 7/5/2007 |
| Q: I was sent information on an Excel spreadsheet that used Excel 2003. I have Windows XP , Microsoft ... A: Jackie The view will open automatically (at least it should) when you open the xl file After you ... | |
| Excel formula question | 7/5/2007 |
| Q: I have a long formula =IF(AR11=C53,D53,)&IF....etc. It's quite long, is there a shorter way to do ... A: Mike This tip should do it for you http://articles.techrepublic.com.com/5100-10877_11-6130286.html ... | |
| download excel | 7/4/2007 |
| Q: I was sent information on an Excel spreadsheet that used Excel 2003. I have Windows XP , Microsoft ... A: Jackie Excel doesn't have any free downloads that will enable you to work on the spreadsheet. ... | |
| Calcuation for Turnaround time | 7/3/2007 |
| Q: I work in a medical setting and I need to calculate turnaround times for various procedures. For ... A: Connie Assuming that the table is set up like this Registration in Column A Exam column B an ... | |
| Sorting problem | 7/3/2007 |
| Q: Sir: I am having sorting problems with Excel 2003. I had two separate 6 column by 50 row ... A: Jim are there any blank columns in the table? This can sometimes cause excel to miscue. Try this ... | |
| Writing over picture | 7/1/2007 |
| Q: Richard, I need to create an excel sheet in which I have a picture subdivided by the cells. I need ... A: David Hopefully this will work but it depends on how accurate you want it to be. You may have move ... | |
| Writing over picture | 6/29/2007 |
| Q: Richard, I need to create an excel sheet in which I have a picture subdivided by the cells. I need ... A: David In respect to the first question have a look at this link ... | |
| Excel 2003 | 6/27/2007 |
| Q: When I sort a list, for example, a list that has: The Apostle Aposse The Best Bessy I want the list ... A: austin You cant unless you remove them, Excel sorts on the first character in each cell. You can ... | |
| Linking workbooks | 6/26/2007 |
| Q: I'm running excel 2003 with windows XP. Our business has a few spreadsheets with basically the same ... A: Lori It would be much simpler and safer in the long run to only allow queries to be run from the ... | |
| Linking sheets | 6/26/2007 |
| Q: I've created a quote system in excel and a macro which copies the date into a 'Quote History' sheet. ... A: Paul First off I would suggest having a look at Access to create your (what is basically a ... | |
| removing characters | 6/25/2007 |
| Q: I have a list of data with a number/alpha identifier then the title. I need to remove the ... A: Dan You can use these steps Text to Columns under Tools 1) Insert new column to right of column ... | |
| DCOUNT or counting age groups | 6/24/2007 |
| Q: I have a Excel table with one column of ages, which i am using as my database D$33:D$42, (D33 has ... A: Don Looking at your example I am not sure Dcount will work because of the limited criteria range ... | |
| Go to method | 6/20/2007 |
| Q: .. I want the Goto (Control-G) not only take me to the specific cell but that cell be the first cell ... A: Guillermo You can create a goto macro that will do what you need, just record the macro and then do ... | |
| excel | 6/19/2007 |
| Q: I would like to know if this is possible. I have one excel spreadsheet which is a master list that ... A: Bob It isn't really possible due to circular reference problems, ie, you update one sheet and it ... | |
| Calculating Dates with Durations | 6/15/2007 |
| Q: I would like to generate an end date by adding together a start date and a duration. The adding is ... A: Connie You can use the network days function, you will need a column with the starting date and one ... | |
| filters in Excel 2003 | 6/14/2007 |
| Q: I have to filter based on more than one column at the same time i.e first select a filter and then ... A: Deepak You can use the autofilter, make sure that you select the entire table then activate ... | |
| Tables | 6/7/2007 |
| Q: I want to have two tables on the same worksheet, one under the other. The top table has more columns ... A: Dionne The only way I know of doing this is to insert a space between the tables so they are ... | |
| Recovered Excel file less than half the size | 6/2/2007 |
| Q: When I had two Excel files open and I was trying to close out one there was an error and excel went ... A: Mark Generally the recovery will remove all the previously saved information that Excel uses to see ... | |
| linking several spreadsheets | 5/29/2007 |
| Q: This is the question someone asked in 2004 to Jeff Kamps on this site: I have created a master ... A: stefano You cannot have a link to a Password protected workbook. However, when Excel recalculates ... | |
| Excel Sort/Filter | 5/19/2007 |
| Q: I am new to using Excel 2003 with Windows XP, as a volunteer for a club. From the member database, I ... A: Sonny The easiest option without going to VBA would be in insert a new column next to the dates ... | |
| issue with date to create field for conditional format, birthday comming | 4/11/2007 |
| Q: D2 is the Date of Birth cell Q1 is the "NOW()" cell E2 is the "Age" cell using formula ... A: Paul As far as I know you will have to add another column (which can be hidden or not) that will ... | |
| capturing directory entries in excel | 4/2/2007 |
| Q: I hope you can help me with a problem I am having. I need to be able to enter the directory entries ... A: Bill There isn't a way for you to do it directly using Excel as far as I know, however you can ... | |
| auto chart | 3/29/2007 |
| Q: i am studying statistics and i have something to do but i don't know. i want to make a work book ... A: Evagoras This link gives you the basic creation of a macro. ... | |
| formula in excel | 3/26/2007 |
| Q: I have a stock list that I am trying to reference different cells together. Here is an example of ... A: Melissa You could use an if statement such as =if(A1=1,"2 x 4inch fittings","") this will only ... | |
| auto chart | 3/25/2007 |
| Q: i am studying statistics and i have something to do but i don't know. i want to make a work book ... A: evagoras You can do this with either a macro which will have to played whenever you make changes or ... | |
| Excel column matching | 3/22/2007 |
| Q: I have 2 questions if you have time: 1) I have 2 excel spread sheets. One if a maintained xls that ... A: Sadie for #2 you will need to upgrade to Office 2007 and Windows live which will enable you to do ... | |
| Excel help | 2/21/2007 |
| Q: i have been trying to form a graph/chart for the variables i have. These variables are in different ... A: Rachit The relationship between each variable is too large for it show all of them on one graph. ... | |
| VLOOKUP and Cartoon Cusswords | 2/21/2007 |
| Q: Richard - I'm using VLOOKUP to fill a cell. The information in the cell it looks up is 12345". ... A: Fred The formula should look like this =VLOOKUP(E11,A1:B3,2,2) There should be no quotes as this ... | |
| coping formulars | 2/13/2007 |
| Q: How do i copy a formular in excel? A: Mary It depends on what you want to do with the formula, this link will give you a few options, ... | |
| Probably simple | 2/9/2007 |
| Q: Using Excel 2002. Hopefully an easy one for you. When in Excel normally when I use; CTRL+Shift and ... A: mike The only thing I can think of is that you are using a laptop and have activated the secondary ... | |
| ms excel: combining data of many worksheets to one | 1/29/2007 |
| Q: sir, i am using excel 2003... i want to transfer all the contents of particular rows from a sheet ... A: abby You can use the copy paste option if it is a one time option, this would then leave the ... | |
| SUM IF In Excel | 1/25/2007 |
| Q: I am trying to add items in one column that meet criteria specified in two other others. In this ... A: Julie Your formula will work if you make it an array formula. To do this put the cursor anywhere ... | |
| Retrieve data from a web page | 1/19/2007 |
| Q: Richard, 1) How can I open a web page, pass information to it, retrieve required data, and ... A: Raymond There are options using a macro that will do what you need however I haven't created one so ... | |
| Can Excel do it? | 12/31/2006 |
| Q: I'm working on a questionnaire in Excel 2002 that will be used repetitively. There are lots of ... A: BJ Data validation is the only way I know of doing this, excel doesn't allow you to insert text or ... | |
| Excel formula | 12/30/2006 |
| Q: I have to write a monthly travel report. I will like to find out how do i can format a cell or write ... A: Roberto If I read it right you can use a Vlookup (if the project numbers page is in alphabetical ... | |
| printing | 12/30/2006 |
| Q: I have a spread sheet that column A is number of items col. B is cost col. C is markup D is item and ... A: Eric The easiest option would be to create a new sheet in the same workbook and link it to your ... | |
| conditional links from one worksheet to another | 12/15/2006 |
| Q: I have out all of my inventory on to an Excel workbook so I can keep track of orders and inventory ... A: Allen There is an option using formula that will do this, but it depends on how many lines you want ... | |
| Simultaneous changes to an excel spreadsheet | 12/13/2006 |
| Q: I am looking to do simultaneous work on one excel spreadsheet between two computers, two monitors. ... A: Sean You have an option to share work book in excel. Have a look in the help menu for excel as ... | |
| filter and send chose one email | 12/12/2006 |
| Q: I have rows with columns consist of Ship Details, such as Ship Name, Operator, Owner, Operator ... A: Shah I don't think you can do that and have it automatically sent to the email, you would need to ... | |
| Excel charts | 12/6/2006 |
| Q: I use excel 2000 In charts, I want to know if it’s possible to use two sub types of graphical ... A: Chris Chris Have a look at this link for combining two charts ... | |
| Excel 97 SR-2 - date format getting changed | 12/1/2006 |
| Q: I have had two instances where I've come into work, powered up my PC, opened up Excel, then found ... A: Bob Well that takes the easy answer away. The only other option I can think of is that your ... | |
| Excel 2003 | 11/20/2006 |
| Q: Yes, I can have them both open at the same time.I am trying to do something in excel that I just ... A: Jeanne In the Second sheet you can use the Vlookup function, which means that the Students need to ... | |
| Excel Can,t Find | 11/18/2006 |
| Q: I am retired and now working for a small business. I took over the computor inventory filing system. ... A: Bill It should be finding the item numbers the same all the time, the only differences that can be ... | |
| Formulas | 10/25/2006 |
| Q: I am trying to create a formula. Ex. In Sheet1 I have a table with the names up top (row 3) and ... A: There are a few options available for this problem, the best solution would be to use a Pivot table ... | |
| Excel 2003 Question | 10/23/2006 |
| Q: I have a spreadsheet with seven columns of data. Four of those columns contain numbers. What I'm ... A: Steve You can use the Conditional Formatting option from the Format Menu. Select your cells that ... | |
| Formulas not calculating | 10/17/2006 |
| Q: I forwarded an Excel Spreadsheet through email and when I opened it from the email, the formulas do ... A: Go into tools options and calculation and see if the manual calculation is selected, if it is then ... | |
| Excell formular | 10/2/2006 |
| Q: Richard, I hope I'm not duplicating this email. I'm responding to your reply. When I tried your ... A: L Go to Tools Options and View and make sure that Formulas in the Windows Options isn't selected. ... | |
| tooltip on CommandButton | 9/29/2006 |
| Q: Richard Stephens: How do you add a tooltip to a CommandButton? Thanks, Rodney A: Rodney It can only be emulated by using a VBA solution, if you are familiar with VBA I can send you ... | |
| How do I make a complex formula in Excel? | 9/25/2006 |
| Q: I am trying to make a spreadsheet that will track timing at work. For example, if I am handed a ... A: G'day Anna To do this the easiest option would be to use an If formula which will check to see if ... | |
| Footers | 9/22/2006 |
| Q: I'm working in Excel 2003. I am currently making a book with 134 pages. I need to put the same ... A: Kim You need to select all the sheets to put the same footer or header on them all. 1. Click the ... | |
| Deleting Data | 9/22/2006 |
| Q: It's been year since using excel and I'm trying to automatically delete lines that contain any of ... A: Mark You would have to create a macro that would loop through each row looking for the specific ... | |
| Auto push info out of Excel to a report | 9/12/2006 |
| Q: Excel 2002: I have a spreadsheet with 705 rows of GPS test data (each row is a GPS observation on a ... A: Ken The easiest (but a long startup) would be to create a macro that does all the steps you want ... | |
| IF formula | 9/6/2006 |
| Q: I am working an IF formula for the NZ tax bands but am missing something. My whole formula must ... A: Karen When creating an If formula like this one it is best to work your way up through the values ... | |
| Adding Additional Info to Column | 8/16/2006 |
| Q: I'm downloading information into a excel spreadsheet. I need to insert additional wording into the ... A: stacy If it is the same text all the way down the column you can use this formula in a new column ... | |
| Looking up the last occurrence of data in a column | 8/15/2006 |
| Q: I have a spreadsheet documenting all sales within a company (hundreds of rows). Included is a column ... A: Shannon You can do it with an index and match formula but it would require you to change the name ... | |
| Formatting numbers for merge document | 8/15/2006 |
| Q: I am using an excel spreadsheet as a database for a merge document. I have formatted the numbers to ... A: Dolly See if these steps work 1. With the main document open, click the Tools menu 2. Select ... | |
| sorting | 7/25/2006 |
| Q: Using Excel 2002. When I sort by clicking a cell in the column, the header row gets sorted too. I ... A: Sandra I think this is by default in Excel, one option is to highlight and change the header row to ... | |
| Preventing changes to an Excel spreadsheet | 6/30/2006 |
| Q: After I've created an Excel spreadsheet, I need to send it to another person via an email ... A: Marty Activate the worksheet to be protected, then choose Tools - Protection - Protect Sheet. You ... | |
| missing database record numbers | 6/29/2006 |
| Q: is there a way to extract the missing Rec numbers from a database using vba(info already imported ... A: greg you can do it with VBA however I am not an expert with VBA I would suggest trying Aidan ... | |
| Excell 2003 and macro's | 6/28/2006 |
| Q: Richard, I am an end user that uses Excel 2003 and I access many workbooks throughout the day. We ... A: Kevin It sounds like it could be a rights problem or a memory problem with the server. I haven't ... | |
| Sort and align routine needed | 6/28/2006 |
| Q: Sort and align routine needed- An excel file contains multiple columns of different data- lets say ... A: john there could be a variety of ways to do this but it would be easier if I could see a copy of ... | |
| Need a macro to update Excel spread | 6/12/2006 |
| Q: I hope you can help me with this? Here is the issue. I need a macro to update a spreadsheet. this ... A: Norm You need to create a name for a cell immediately below the current end of the table, something ... | |
| keystoke command for 'dragging out' in excel | 5/20/2006 |
| Q: I use the 'drag out' feature quite often in excel. Whether it is a date that I am 'dragging out' to ... A: Edward To drag across you are still limited to the Fill handle or you can try the Fill Series from ... | |
| drop down menus for sorting | 5/18/2006 |
| Q: I have seen an excel spreadsheet that had drop down menus that were used for sorting. My question ... A: Donnie Do you mean a filter option that will only show a particular brand etc? If so Data > Filter ... | |
| Excel | 5/17/2006 |
| Q: I have an issue with MS Excel when I try to open a file, it takes forever to access the directory. I ... A: Jacques It could be one of many things, to little RAM ie 256 ram as opposed to 512 ram. Or you may ... | |
| Dates / Number of Days | 5/16/2006 |
| Q: Asked to devise a Excel formula that will, if given a number of work days, and a start date, figure ... A: steve The function you need is called networkdays. This returns the number of whole working days ... | |
| recurring payments in budget | 5/2/2006 |
| Q: I'm fairly new to excel. I am building a budget and I am looking for a way to have excel ... A: Ed There are a few options you can use, an if statement would probably be best and it would go ... | |
| Excel linking sheets | 4/17/2006 |
| Q: I'm trying to link information from two spread sheets. One sheet contains a column of names. The ... A: Lou This can be done using a vlookup. It will only work if the names are all different ie. no two ... | |
| Excel2000 XP home | 4/13/2006 |
| Q: "I have downloaded data from internet with IE edited with MS excel. On spreadsheet column of ... A: Gene Excel should recognise the download format, one option is to select the column and go to Data ... | |
| Shared Workbook | 4/12/2006 |
| Q: Excel 97: I have an Excel Shared Workbook that I developed for our office to use as a ... A: Karen I haven't any experience with this problem but you may want to check that all the versions of ... | |
| Protection of cell | 4/8/2006 |
| Q: I have made an Excel file in which I created a formula. Let's say that the formula in C3 =C1+C2. My ... A: Sy The first step is to select the entire sheet, then go to format cells and protection, remove the ... | |
| I'd like to put the year (only) in a header | 4/4/2006 |
| Q: Richard, I am aware of VBA, but I am have not used it at all. If you could give me guidance on ... A: Joan Hope this helps To put in this macro, from your workbook right-click the workbook's icon and ... | |
| round function | 3/31/2006 |
| Q: I have a spreadsheet i am working on in excel, and have come accross a problem. I have a column ... A: Joel Is the final answer a decimal? ie for 80% it will show as .8, if this is the case then we ... | |
| saving constant changing data in a differant cell | 2/20/2006 |
| Q: i have 54 prefixed cells A1 to F1 times 9 rows down I enter data in 6 cells then differant data in ... A: Clive One option would be to copy and paste the information into a new sheet, you can create a ... | |
| charting | 2/18/2006 |
| Q: i would like to chart prices of options(vertical) and strike prices horizonal. i would like to get ... A: David Excel doesn't do streaming when it is linked to stock market symbols, you have to continually ... | |
| consignment software? | 2/16/2006 |
| Q: I have a consignment shop and wanted to see if you knew of an easy program that I could use to take ... A: Cara I am sorry but I haven't used any consignment software products, I have looked to see if there ... | |
| moving files from micrsoft office excel 2003 | 2/3/2006 |
| Q: I have always saved my files onto floppy disc,but Ihave now decided to save them to a cd/rw disc I ... A: Clare This link will explain what you need to do ... | |
| Multiple Worksheet Referencing | 1/27/2006 |
| Q: I have 13 sheets in one workbook. One for each month of the year plus a Main sheet. Every sheet is ... A: Ian You may be able to do this using Pivot Tables, I haven't tried it but it should work if all ... | |
| disadvantages | 1/26/2006 |
| Q: i have a collge assignment due 1-27th,by noon,can you please help me ,i need to write down teh ... A: Rosemary I dont usually do homework questions, in this case though you haven't given enough ... | |
| excel program | 1/21/2006 |
| Q: this is my format to add my time card and every week when i turn in my time card i always off by ... A: Veronica If you are using the decimal point as shown this doesnt give you time, you need to use the ... | |
| Excel Form | 1/20/2006 |
| Q: Office 2000. I am trying to create a Excel form for multiple users that will allow you to enter ... A: Michaela To start a form like this you would need to create a macro/vba that would copy the text, ... | |
| Excel Spreadsheet | 1/12/2006 |
| Q: I am running Microsoft Office 2000. I have a spreadsheet that I took from my computer and put on a ... A: Christi When you opened the file in Works it truncated the spreadsheet, works will only open one ... | |
| IF function | 1/10/2006 |
| Q: I really appreciate it. My quandary. I need to write an IF function. I want to have a cell (C1) ... A: Gary If you are only using 5 insurance companies then the if is what would be easier if you go ... | |
| Excel, reduce number of rows | 12/23/2005 |
| Q: I have a column of data 3,000 rows long (3,000 numbers). The data doesn't vary that much, so I would ... A: Charles You can use an Add in called Sampler. It's in the Analysis Toolpak Add-in. To load that, ... | |
| using "if " function | 12/16/2005 |
| Q: In cell B3, a number from 1 to 10 will be entered. That number just stands for how many years. Each ... A: You could use a vlookup option that will show only those rows but it would have to be on another ... | |
| I could make them all the... | 12/16/2005 |
| Q: I could make them all the same number of rows, if that makes a difference. Otherwise, no... the row ... A: Debbie There is no simple solution, if you want to send me the file I will try and create a macro ... | |
| Deleteing Repeated Cells | 12/14/2005 |
| Q: I am trying to perform a mail merge using an excel file. On the file, there are several repeated ... A: Arthur The easiest way is to use the Data Filter option. Backup your file first then select all ... | |
| Printing | 12/14/2005 |
| Q: When printing a spreadsheet that was emailed to me, I am getting ##### in some 'total' fields. Why ... A: Debbie This usually indicates that the cell contents are wider when printing, this can be because ... | |
| Date formula | 12/14/2005 |
| Q: I would like to enter the dates automatically. In A2, I enter 12/04/05 (Sunday), and I want the A3 ... A: Sy In A3 type in =A2+7. Go to the fill button on the bottom right of cell A3 and drag down the ... | |
| validation | 11/30/2005 |
| Q: I have several lists in a workbook(call it book1) that I would like to use in a different workbook ... A: D. It is possible but both workbooks have to be open, if this is suitable have a look at this ... | |
| Excel | 11/23/2005 |
| Q: ..BUT i need more! here a few more questiuons. Plaes and thanks . How do you format a cell to ... A: Abby How do you format a cell to have dollar signs next to the numbers? Select the cells you want ... | |
| formula with text and numbers | 11/21/2005 |
| Q: Richard, In column A I have names of employees. I have text in column B of different temp agencies ... A: Terry The easist solution would be to use either a Pivot Table or use the Data Filter options to ... | |
| Incrementing a relational reference within a formula | 11/10/2005 |
| Q: =SUM('Daily Totals'!B6:B12) I need a quick way to drag this formula down a column and for it to ... A: Richard I haven't been able to find a simple solution, the only ones I have found so far (and they ... | |
| Counting time with Excel | 11/10/2005 |
| Q: I am trying to make a timesheet for my work in which I enter the starting time, ending time and make ... A: Huynh If midnight falls between your start time and end time, you must account for the 24-hour time ... | |
| functions | 11/8/2005 |
| Q: Okay, here is what I am trying to do. I have a bunch of regions in column A and I have percentages ... A: Afton Have you looked at Pivot Tables? These can be quite easy to use for the exact options you ... | |
| Cell Value | 11/7/2005 |
| Q: Can a cell have both a number whihc can be used in a calculation, and a text value which can stay ... A: Amogne You can do this by adding a helper column which will add the text and the numbers together ... | |
| simulation | 11/4/2005 |
| Q: Can you answer questions on simulation in excel 2003. regards A: Perry Sorry about the delay, my laptop's harddrive fried itself and since I am on the road a lot I ... | |
| Excel help | 10/24/2005 |
| Q: I am trying to build a database. My intention is that I have the name and reference number for all ... A: Michael Go to the cell that you want the link for and right click, then select hyperlink, it will ... | |
| linked objects and images | 10/21/2005 |
| Q: My knowledge of excel is quite basic to say the least. I know nothing about writing macros and ... A: Roger I found this vba script awhile ago and think it will work for you very well. You'll need to ... | |
| insert worksheets | 10/21/2005 |
| Q: Is there a way to automatically insert a worksheet based off of another? Ex. I have on worksheet ... A: Angie You could create a macro to run from a button off the cell that a new employee is in. You ... | |
| Excel Sort Command | 10/17/2005 |
| Q: At work we have an excel spreadsheet that is comprised of 3 worksheets. We are constantly updating ... A: Michelle I haven't come across this before, but it may be that it is either too big or has become ... | |
| I wonder if you can help me.... | 10/12/2005 |
| Q: I wonder if you can help me. I am doing up a small report and I have three columns . Sub Total. HST, ... A: Paula This should do it, however you will have to limit the cells to two decimal points to get the ... | |
| blanks | 10/11/2005 |
| Q: i need a particular cell to show '1' if two other specific cells are equal, but '0' if they are not ... A: Michael I am assuming you are getting one when there are two blank cells being referenced, this ... | |
| Graph formula | 10/11/2005 |
| Q: Using Excel 2000 9.0.3821 SR-1 Inserted a linear trend line on a graph. Trend line formula is y = ... A: Tim I am not sure if this will work or is even what you need as I don't do much in the way of ... | |
| Using symbols within Excel | 10/4/2005 |
| Q: I am trying to show a simple image when a cell meets a certain criteria. For example if cell A1=1, ... A: Jim The first thing you need to do is format the cells where you want the checkmark to go in the ... | |
| Linked datasheets | 9/27/2005 |
| Q: I have MS Office 2000. In my company we have different datasheets with all the data of the staff ... A: Fotos You can only update one way otherwise it causes a circular reference which causes excel all ... | |
| sorting numerically and alphabetically | 9/20/2005 |
| Q: in excell example; a list of names "yahoo.com" "google.com" "allexperts.com" and etc... and sort ... A: Chris I am assuming you have something like this allexperts yahoo google 2345 1234 5432 Excel ... | |
| Windows 2000 | 9/14/2005 |
| Q: I was working on one file (Excel)called NI 184 and then I opened another excel file to view it not ... A: Sharon It looks like you saved the original file with the NI when you closed, that is about the ... | |
| Creating a MTD total | 9/6/2005 |
| Q: Column A is the current total. Column B is the MTD total. How do I keep a running total in column ... A: Maryann If the office salaries is in column A and each day is exactly the same then you could use ... | |
| Calculation between two dates | 9/6/2005 |
| Q: Can you help me with a calculation? I use my excel spreadsheet as a bird log and have two columns ... A: Birderfrank There are a few variables that can be used here but I will need to know if the colums ... | |
| Creating a MTD total | 9/5/2005 |
| Q: Column A is the current total. Column B is the MTD total. How do I keep a running total in column ... A: Maryann If the spreadsheet is set up simply you can use this formula in B3 assuming that the first ... | |
| Returning most recent results. | 8/23/2005 |
| Q: Microsoft Excel 2003. Is it possible to return the 5 most recent results in a field? Or the most ... A: Simon It is possible but I would need to know the layout of the page, you can create either a ... | |
| excel program | 8/16/2005 |
| Q: i know the basic stuff but i'm having trouble with some of it first of all at my job have to add up ... A: Veronica The easiest way is to insert the time like this in the in column 7:45 (the : indicates to ... | |
| formula | 8/9/2005 |
| Q: I am using xp professional - I need to put a letter value in on column (A or B = 1 year, C = 3 ... A: Ruth This can be done with an if statement in the needed cells, the only problem I can forsee is ... | |
| Excel 2000/merging data from 2 worksheets | 8/5/2005 |
| Q: My question is in regard to merging selected information on two worksheets into one (Excel 2000). ... A: Les Sorry it took so long, been a little busy up here, anyway without looking at the layout a bit ... | |
| Merging data | 8/4/2005 |
| Q: I have sent one template to 10 people to fill out their own information. I don't want others to see ... A: Amita If you are familiar with access you can use that to import the information into a database ... | |
| Saving formatting as .CSV | 8/3/2005 |
| Q: MS Excel 2000 VERSION: 9.0.2720 Hi! I want to save cell formatting when saving as a .CSV ... A: Nathaniel This is a common problem with Excel and CSV's, when you open the file in word it shows ... | |
| access to cell formatting | 7/27/2005 |
| Q: Using Excel 2000 v 9.0.3821 SR-1 Kind of hard to explain. I've been using Excel for some years, but ... A: Tim Have you tried copying the entire sheet and pasting special into a new sheet and seeing if that ... | |
| excel repairing | 7/17/2005 |
| Q: I seeking for a help. I have a deleted excel file for a week. Then I recover my file using Recovery ... A: None of the programs I use can repair the file, you might want to look at this program ... | |
| printing to ledger size paper | 7/13/2005 |
| Q: How can I set up an excel spreadsheet to print to 11 x 17 in. paper. There is no option under paper ... A: Deb This depends on your printer driver, if your current printer can't print to 11 X 17 it wont ... | |
| Summing Between Worksheets | 7/5/2005 |
| Q: Is there a shortcut to sumif 20 worksheets? If so, what? A: Bryan There isn't a shortcut that will do it automatically, you will need to create and select each ... | |
| Removing Xtra pages in Excel | 7/1/2005 |
| Q: WindowsXP - Excel - How do I eliminate xtra pgs in a document used as an attachment for an email? ... A: John If you mean the sheets the right click on the sheet and delete it. If you mean that you are ... | |
| CHaracter Count | 6/20/2005 |
| Q: How do i find out5 how many characters are in a certain field? I have a list of approximatly 3000 ... A: Rob If you mean all 3000 rows in one field then try this formula {=sum(len(A1:A3000))} A1 to ... | |
| very basic!!! | 6/13/2005 |
| Q: you said no question was too basic, so i'm here to test that! i am an excel novice, to put it ... A: Sonya Not as basic as you might think, this will involve creating a master list of all your items, ... | |
| Excel 2000 - Trendline in chart | 6/6/2005 |
| Q: Richard, Have an Excel Bar Chart that has Quarterly Data. Want to add a Trendline. The problem is ... A: Richard As far as I can tell there isn't a way to do this using the existing data for the current ... | |
| Pivot Tables - show/hide details | 6/3/2005 |
| Q: I have a pivot table which is based from an external source - an MS Access db. There are 2 ... A: Al This is by design from memory, but I haven't used Access in a long while, you can't drill down ... | |
| computer shut down, data not saved | 6/3/2005 |
| Q: My computer shut down and i was not able to save the data. when i started the computer again, i ... A: Vaibhav Usually there is a backup that automatically opens when you restart the pc, however ... | |
| Comparing Workbooks | 6/1/2005 |
| Q: My employer produces a weekly workbook of sales figures in a consistent format. The workbooks are ... A: Jonathan I have been looking for a macro that will do what you want but can't find one suitable, I ... | |
| Deleting Macro | 5/31/2005 |
| Q: but alas, a) I couldn't really follow how to do what you suggested [for example, there was nothing ... A: Marshall In the VB editor make sure you have the module selected and select remove module, this ... | |
| Deleting Macro | 5/30/2005 |
| Q: I have Win 98 and MS Excel 97; every time I open one of my files, which I'll call File A, [which I ... A: Marshall It sounds like you have the macro for all workbooks, I would open up the file you want the ... | |
| Warehouse spread Sheet | 5/25/2005 |
| Q: (USA) I'm looking for a spread sheet I can modify to my own needs. The comany I work for have too ... A: Mike There are few available that I can send you, I will send them to your weekday email address ... | |
| Summary quantities | 5/20/2005 |
| Q: I have another problem that I hope you can assist with: If I have a selection in col B and a ... A: Emmar You could remove the summary column and use subtotals, this would allow you to add to the ... | |
| INDEX problem | 5/19/2005 |
| Q: Is there any way that I can define a range in an INDEX function based on the selection made in ... A: Emmar I am a little confused as to what you exactly need, if I read it correctly I would suggest ... | |
| Page subtotals | 5/18/2005 |
| Q: Is there any way that I can configure a spreadsheet to give me a page subtotal without having to ... A: Emmar Sadly there is no answer for this question that I have ever come across (going back to 97). ... | |
| Cant save formula | 5/10/2005 |
| Q: I have 3 sheets in an XLS workbook. now sheet1 has information, sheet2 has information and sheet3 is ... A: Rob Highlight the entire spreadsheet and then paste it into a new spreadsheet using the paste ... | |
| Cascading lists | 5/9/2005 |
| Q: I have a spreadsheet where I want to use cascading (or filtered) lists. In the first (column A) I ... A: Emmar You have the Filter option which will do exactly what you want available from the Data menu. ... | |
| How can I track all related... | 5/6/2005 |
| Q: How can I track all related cells to this cell for exemple on "a1" I will wire 100 "a2" 100 "a3" ... A: Joseph When you type in the formula =A1+A2 in A3 and change the numbers in either A1 or A2 it will ... | |
| MS Office Pro 2000. I have... | 4/6/2005 |
| Q: MS Office Pro 2000. I have a number of EXCEL cells that have text strings in them. When they start ... A: Tony Excel does have limits and you are correct about the 1000, there is no way that I know of ... | |
| row height the same | 4/3/2005 |
| Q: i am trying to get the row height to come out the same on different worksheets, on the first sheet i ... A: June Excel will automatically adjust the margins for each column when you remove the page margins, ... | |
| Command Button | 4/2/2005 |
| Q: I know but I want to build the button directly into the sheet so its present no matter what computer ... A: Kevin The first step is to create a macro that will automatically do the refresh, this can be done ... | |
| Command Button | 3/31/2005 |
| Q: I have a file that reports my stock portfolio holdings. It uses the built in msn stock quotes to ... A: Kevin When you insert the Stock information, a small toolbar should appear called external data, on ... | |
| copy automatically fields from another sheet depending on user input [XLS 97] | 3/30/2005 |
| Q: I got 2 Sheets in one Document: Sheet 1 got the following A - - - B - - - C Mr. Smith Charles ... A: Marcus The only way to do this is to use a vlookup, however that will run into problems as you are ... | |
| changing columns | 3/28/2005 |
| Q: Just started with Excel 2002 and I'd like to know - 1 How do I move a whole column from say, D ... A: Gabe Click on the column heading ie the D and then right click and if you want to move it click on ... | |
| Using spreadsheet to do account reconciliation | 3/22/2005 |
| Q: I have a huge clearing account to reconcile and would like to automate the process using Excel. I ... A: Devyn A macro will insert the new data for you as long as the text data file is always named the ... | |
| Macro | 3/15/2005 |
| Q: I'm using Window XP. I track daily figures and would like to store these in a seperate sheet every ... A: Royston As far as I know it isn't possible to run a macro from a cell, however you could run one ... | |
| Interpolation | 3/9/2005 |
| Q: Stephens I was wondering if you could help with something I am trying to do in Excel 2003 (I don't ... A: Victor Sorry about the delay but there is a family emergency and I wont be able to get back to you ... | |
| Payroll Timesheet | 3/8/2005 |
| Q: I hope this is a really easy question for you. Thank you so much for your help, in advance. Just ... A: Linda To do this you will have to create another column where you can apply functions or formulas ... | |
| Work Sheet Tab Size | 3/7/2005 |
| Q: Here's a good one for you. Do you know how to change the view size of the work sheet tabs at the ... A: Patrick The default settings for the window view in Excel are determined by the Windows operating ... | |
| EXCEL FORMULA | 3/7/2005 |
| Q: I am using the formula: ... A: Dennis If it works for text then the problem could be that the numbers are mixed, ie text or ... | |
| Sorting troubles | 3/6/2005 |
| Q: I've been using MS Excel 97 for a couple/few years now and done many data sorts. There are times ... A: Marshall If the data is imported click on the column you are going to sort on and go to Tools> text ... | |
| Excel Page Setup | 2/23/2005 |
| Q: I have mostly HP LaserJet 4100's and 4200'sExcel 2000 I want to print the text "Draft" going diag. ... A: Michael I looked at the information on the printers and couldn't find a watermark option, however I ... | |
| excel function | 2/21/2005 |
| Q: Can you when referring to a cell, put in a function to represent the number part. That is, if you ... A: Matt Sorry to say but I haven't come across this one and the research I have done doesn't lead to ... | |
| Listing numbers in excel | 2/21/2005 |
| Q: Excel 2003 (i think) Dear Richard, I hope that you can help me! I am making a table in excel and ... A: Junilla There are a couple of ways to do this that don't involve using VBA (of which I am not that ... | |
| Inserting Images using filename in cell | 2/19/2005 |
| Q: Yes. Insert an image into a new cell based on the data in another cell.How can I insert an image ... A: ron have a look at this vb it should do what you need Sub test() Application.ScreenUpdating = ... | |
| Headers | 2/18/2005 |
| Q: Excel 97 I put a title header on every page. The title does not show up on computer while I am ... A: Joan As far as I know you can't view headers from within the workspace as excel can't show you how ... | |
| Excel Checkbox Captions | 2/10/2005 |
| Q: excel 97 G'day, I am wondering how to go about getting the caption on a checkbox to display a ... A: Rob The validatin option will be better for you I think. The validation option will only allow you ... | |
| Excel help! | 2/10/2005 |
| Q: 2000 SR-1 Professional I want to have the numbers at the end of this string count up while the ... A: Christy Move your mouse to the bottom right corner of the cell that is say BLC0003, you will see a ... | |
| Excel Checkbox Captions | 2/9/2005 |
| Q: excel 97 G'day, I am wondering how to go about getting the caption on a checkbox to display a ... A: Rob It will require some VBA programming, however there may be a simpler way to do what you need ... | |
| Combo Box Formating Text | 2/3/2005 |
| Q: How can I format the text that is inserted into a form by a combo box control? Also I want an easy ... A: Pat For a combo box in the Forms toolbar you can't change the text as this is a standard in Excel, ... | |
| Best way to forecast individual sales territories? | 2/3/2005 |
| Q: I have a spreadsheet with twelve months of sales data per territory (100 territories.) I need to ... A: Bill The best method is what works best for you, I would suggest looking at either forecast ... | |
| Excel 97 | 2/1/2005 |
| Q: I have an excel table which correlates with data for my different sites. My question is "is there a ... A: Luis The easy way would be to use Access which would allow you to create one table and then queries ... | |
| Adding a continuing total | 2/1/2005 |
| Q: To make my worksheet more automatic for others to use I have two cells, cell A (current week) and ... A: Jim There isn't a simple way to do this as you are updating cell A everyweek and would need a macro ... | |
| Get rid of unwanted list in Excel | 2/1/2005 |
| Q: We have an Excel file (Excel 2000) that we use as a schedule for our employees. But there is someone ... A: Carmen If by list you mean validation list ie there are drop down arrows in each cell when you are ... | |
| Excel 2000 | 1/27/2005 |
| Q: Do you know if there is a way to use the IF Function to turn the number in a cell a different colour ... A: Mark Have a look at conditional formatting in the format menu, you can do exactly what you want ... | |
| Time Conversion | 1/25/2005 |
| Q: I am using Excel 2002 and need to convert time data exported from our student information system ... A: Deb I have been trying to find a way to do it globally but can't get a solution, there are too many ... | |
| percentages | 1/24/2005 |
| Q: using Excel 2000. trying to enter a percentage formula or a quotient. I keep getting circular ... A: Rhonda Are you caculating in a different cell using the other two cells for you figures, if you are ... | |
| Changing Cell/Text Format When Time Past | 1/20/2005 |
| Q: Excel version 2000 (Home)/2003(Work) Is there away to change the colour of text i.e a date or other ... A: Ian if you use =IF(E1-C3>60,"yes","no") in the cell next to the date of the stock where E1 is ... | |
| Drop down boxes in escel | 1/20/2005 |
| Q: Richard, How do I do drop down boxes in excel (version 5.0)? Thanks A: Barb Go to the View menu and select Forms from the toolbar list, this will give you the drop down ... | |
| VLOOKUP function | 1/20/2005 |
| Q: An answer to your question " I've got a list of data with some repetitions in it in terms of serial ... A: Mike Vlookup will only work if the lookup cell is in alpha numeric order and is unique otherwise ... | |
| CIRCULAR REFERENCE | 1/17/2005 |
| Q: Excel 2002 Will you please help to define a Circular Reference. I'm trying to understand how to use ... A: Irena have a look at these links http://office.microsoft.com/en-us/assistance/HP052002851033.aspx ... | |
| Excel - Join Feature for Excel Tables | 1/12/2005 |
| Q: I have a list of customers and their cell phone numbers. I also have a monthly usage detail listing ... A: Scott If the tables are set up in the same spreadsheet and you can sort the customers ... | |
| Links | 1/12/2005 |
| Q: Excel 2000 At the end of every month I need to finish a file linked to other files. This is a file ... A: Hannah There is an option that will allow you to update all the links at one time in a document ... | |
| Adding Sheets | 1/10/2005 |
| Q: I'm trying to add a cell from sheet 1 to a cell in sheet 2 and I'm not sure how to do it. Basically, ... A: Richard You are almost there. Click in the cell you want the total in type in = move to the cell ... | |
| Daverage | 11/4/2004 |
| Q: My spreadsheet contains data in the following fields(A16:Y6997). Each record has a Priority (F ... A: bridget You need to use an if statement to call for only those priority's you want to use. If you ... | |
| Links to Other Files | 10/27/2004 |
| Q: I work on Excel 97. I have two links to two different external files. I have tried everything to ... A: Go to Edit->Links and write down the name of the linked files. if there aren't any there then you ... | |
| Formula for time | 10/18/2004 |
| Q: .. Is there a formula in excel that will add 30 minutes to a time slot? I would like to go from ... A: crystal If you have 8:00 in cell A1 this formula will add 30 minutes to it, drag the formula cell ... | |
| Filter & Subtotal | 10/14/2004 |
| Q: Ok let say i've created a list in a sheet. So what my questions are: 1) Is it possible to create a ... A: You can create a subtotal on another sheet by going to the other sheet(assume it is sheet2), typing ... | |
| delete columns in excel | 10/8/2004 |
| Q: Hai I downloaded a txtfile and i import it into excel.It contains 3000 records with some blank ... A: Ramya Click on the Column Header (a or b or c etc) and then go to Edit and click on Delete, if you ... | |
| moving file with linked graphs | 10/6/2004 |
| Q: I have 40 PPT's linked to a spreadsheet, I need to move the file to another location. How can I do ... A: K In stead of moving the files from outside excel, open the file that contains the links, then open ... | |
| Sending E-mail to different e-mail acct | 10/4/2004 |
| Q: Could you pls tell me if I can change the e-mail account to a different program instead of Outlook ... A: Cheri Excel uses the default mail server that is on your system, if it is Outlook you need to go to ... | |
| slope a curve - to plot | 7/26/2004 |
| Q: we make a curve through excel chart. Now how can we add another curve which displays the slope of ... A: Rajeesh I haven't tried it but you should be able to drag another set of numbers describing the ... | |
| excel | 7/23/2004 |
| Q: is there any method to hide only one cell data in excel please reply? A: Usman You can't actually hide a cell, you can make the text white so it doesn't show and then ... | |
| Msg Box Options | 7/22/2004 |
| Q: I am working on a userform that allows employees to click on a specific word and a message box pops ... A: Mark You can't change the text for a message box and I haven't tried changing any other options on ... | |
| Hyperlink | 7/8/2004 |
| Q: I am trying to creat a hyperlink to a cell within the same workbook and sheet (lets say A100). My ... A: Kevin I have been looking to see if anything is applicable to your problem, the only option I can ... | |
| MATH IN MILITARY TIME IN EXCEL WITH A DATE CHANGE | 7/6/2004 |
| Q: EXCEL 2003 I AM TRYING TO OBTAIN AN AVERAGE FLOWRATE BASED ON A CHANGING INTERVAL(IN MINUTES), IN ... A: Jerry I haven't used military time so am not sure of the answer, but I will look into it some more ... | |
| How to determine the last row | 7/2/2004 |
| Q: I recorded a macro and it works fines except now that I want to run it again on different files that ... A: Tc This macro goes to the last active cell and then down 1 cell and home Sub lastrow() ' ' lastrow ... | |
| formula | 6/25/2004 |
| Q: I have a combo box and inside I have about 19 different obtions including a blank one. I have that ... A: I know the number vs text is initially confusing. The number represents the nth item in the list. ... | |
| formula | 6/22/2004 |
| Q: I have a combo box and inside I have about 19 different obtions including a blank one. I have that ... A: Jessica I am a little confused, do you want the combo box to show the list or the cell to show all ... | |
| Spelling Dictionary | 5/28/2004 |
| Q: I'm not sure as to how to identify the version of Excel that I have. It came preinstalled on my ... A: Dave These steps should do it for you. To add, delete, or edit words in a custom dictionary: On ... | |
| SPLIT A CELL | 4/30/2004 |
| Q: I AM REALLY HAVE A TIME TRYING TO FIND OUT HOW TO DIAGNALLY SPLIT A CELL. I KNOW THAT IT CAN BE ... A: Stormy You can only give the appearance of a split cell, you can't actually split the cell. To ... | |
| Excel 2000 | 4/27/2004 |
| Q: I am using a VLookup formula in my spreadsheet. Some of the cells are showing #N/A which is ... A: Adrienne Try this conditional format For all the cells that *could* show N/A set the font color to ... | |
| 'Copy from' vs 'Send to' a cell | 4/26/2004 |
| Q: Richard: Does Excel 97 SR-1 have a function to allow you to send data to a cell, as opposed to ... A: JC The short answer is no, if you could do that excel would freak. (something about circular ... | |
| sub tabs | 4/26/2004 |
| Q: I am using excel 97. Can I create sub tabs? I am trying to make a workbook with 3 categories that ... A: Josh As far as I know it isn't possible. You basically want to have 3 workbooks open in the one ... | |
| lost file | 4/23/2004 |
| Q: I am using Excel 97. I lost a file that is my senior research project... I had it on a floppy disk, ... A: Katie It may still be on your floppy if you haven't placed anything else onto it or it could be ... | |
| Keeping a cell yellow | 4/21/2004 |
| Q: I am a teacher and I have created a large spreadsheet for a grade book program. To help keep the ... A: Luke You can make your own template but you will still come up against the copy paste and fill ... | |
| Formatting hours and minutes | 4/20/2004 |
| Q: Sorry, I think I have not made the question clear. What I mean is if in a calculation involving ... A: Peter If you mean showing it as - 10.00 pm 2/3/2004 then no. Excel can't handle negative dates. ... | |
| Formatting hours and minutes | 4/19/2004 |
| Q: If the difference between two times (eg 20:00 and 08:00) is a -ve number, is there a way to display ... A: Peter You can get around Excels negative time problem by entering a full date and then subtracting ... | |
| I want to set up a logical... | 4/15/2004 |
| Q: I want to set up a logical test so that if the last cell equals "yes" then the whole row changes ... A: Danny If the cell is always in the same place then you can use conditional formatting. Go to ... | |
| Averages | 4/15/2004 |
| Q: This seems like a basic function but I can't seem to find how I can get the average function not to ... A: Mark The following formula will do what you want, it is an array formula. ... | |
| Merge for matched data | 4/15/2004 |
| Q: You have been very helpful before and your turn around time is great! - thank you! Using Office ... A: Lori Without actually seeing your spreadsheet I can't give a definite answer, but you should look ... | |
| Excel - plots (Chart) | 4/13/2004 |
| Q: I am trying to plot several series of data in Excel on a single chart (so that they can be visually ... A: Joan As far as I know it can't be done with Excel, this option is only likely to be found in High ... | |
| down loads for excel | 4/13/2004 |
| Q: Bunny A: Bunny What type of downloads are you looking for. Office Excel would be the same Excel you have on ... | |
| date | 4/11/2004 |
| Q: it really worked, but which number should I change in case I need to calculate oher weekday ... A: Haytham I am sorry I should have explained better. This formula works from the start date. In the ... | |
| Removing a - from a number | 3/30/2004 |
| Q: I'm using excel 2002. I need to remove all the hyphens in a number. When I do a replace – with a ... A: TC It should pick up the - and then replace with nothing, the only option I can think of is that ... | |
| Excel 2000 | 3/29/2004 |
| Q: the option is on Automatic, do you have another suggestion? Please feel free to call at at ... A: Sara That was the only option I had for you, I can't think of another reason it isn't working ... | |
| Charts | 3/29/2004 |
| Q: I am using Excel 2002 on Windows 98. I am creating many simple 1-D horizantal bar charts to be ... A: Jane You can resize the main window and then click on the chart and resize it as well (ie when you ... | |
| Restricting cursor to unprotected cells. | 3/25/2004 |
| Q: I have designed a spreadsheet that requires the user to input 6 numbers into six different cells. I ... A: Robert The simplest (and the hardest sometimes) is to tell the users to use the tab key, but since ... | |
| Need Formula | 3/3/2004 |
| Q: I'm using Excel 97 and would like to multiply a number in cell A1 by another number in cell B1 and ... A: Tim You can use and if statement for this question. =IF(A1*B1<=6.97,6.97,A1*B1) This multiplies ... | |
| Comments | 2/26/2004 |
| Q: Mr. Stephens, I am using Office XP Pro. In an application I devised I included comments in some ... A: John From what I have found it isn't possible to move the comments, you can move them to view them ... | |
| Excel XP | 2/26/2004 |
| Q: Can you show me how to use "And" and "Or" function with "If" function with any example. Thank you ... A: Amita here are a couple of examples from the help file A Data 1 15 2 9 3 8 4 ... | |
| Excel macro | 2/20/2004 |
| Q: Richard, Excel 2000. I recorded a very simple macro (copy a column to another sheet and then sortit) ... A: Kevin Yes, for excel 2000, use the Change event of the worksheet. Tip: a quick way to get to any ... | |
| Currency rate conversion | 2/19/2004 |
| Q: If a spreadsheet has been done in Pounds, in terms of the financial figures, how can you convert all ... A: Eric The easiest option would be to create a duplicate spreadsheet, on a different sheet with the ... | |
| Password | 2/15/2004 |
| Q: Please apprise me the best program to break the password of Excel and Word files? Best regards, ... A: Haytham The ones I use for Excel are Advanced Excel Password recovery and Accent password recovery, ... | |
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Answers by Expert:
- Nathan Head
- Chad Welch
- Philip Buckley
- Tushar Sakhalkar
- Bhaskar
- Amal
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bob Umlas
- Edward H. Mori
- Jessica L.
- Jan Karel Pieterse
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- Craig
- Adelaide carvalho
- Miguel Zapico
- JP
- Douglas M. Smith
- Richard Rost
- Ken Marron
- Victor Lan
- Bill
- Anne Troy
- Claire Blinman
Richard Stephens
Top Expert on this page
Expertise
Can respond to questions up to and including advanced (very rusty on VBA) Currently using Excel 2003 and Xp (can still remember some of the earlier excel programs. No question to basic.
Experience
Teacher and business trainer for 5 years. Run my own small business Current on all versions of Excel
©2009 About.com, a part of The New York Times Company. All rights reserved.