You are here:
Excel/Questions Answered by Expert Jessica L.
| Subject | Date Asked |
| Adding a sroll bar in a chart in Excel 2007 | 9/1/2009 |
| Q: I got stuck in a problem. Its adding a scroll bar to a chart containing multiple columns with two ... A: So sorry - I accidentally clicked on the automatic "Thank you" note option instead of emailing you ... | |
| Cell above for formula | 8/30/2009 |
| Q: I'm trying to use the date difference formula but I have over 2000 dates that I want to count the ... A: If I am understanding your question correctly, you want to find the number of days between today and ... | |
| Logical/Nesting functions | 8/29/2009 |
| Q: I am trying to make a formula using IF and AND functions nested together so that there are a ... A: Hey Sandy, I believe the following formula is what you are looking for: ... | |
| formula help | 8/28/2009 |
| Q: I am trying to figure out a formula. I need to figure out gross profit but the selling price must ... A: Hey Michael, In order to subtract a percentage from another number, you can use the following ... | |
| HH:MM:SS | 8/27/2009 |
| Q: To enter time in excel we use Ctrl+Shift+; keys. Here we are getting time in HH:MM. Instead of this ... A: Unfortunately the shortcut does not provide the seconds. Here are some options that might be ... | |
| Time calculations | 8/26/2009 |
| Q: Just following on my previous questions I am confused here with the vlookup bit plus how can I ... A: Here is more of an explanation on how to use the formula I wrote for the VLOOKUP. This will ... | |
| Time calculations | 8/25/2009 |
| Q: Just following on my previous questions I am confused here with the vlookup bit plus how can I ... A: In Step 2, each time would be in its own cell. So 12:00:00 AM would be in the first cell, 12:00:00 ... | |
| SUMIF (Array) | 8/24/2009 |
| Q: This is my result via a pivot table SERVICE Delivery Times 73 75 76 712 Grand Total 12.00am to ... A: In order to categorize the times, please follow these steps: 1 - Insert a column in front of column ... | |
| Conditional formating | 8/23/2009 |
| Q: I'd appreciate some help in conditional formating cells based on the following three conditions. 1: ... A: Hey Ian, Please follow these steps to solve your problem: 1 - Select cell A2 2 - Click on Format ... | |
| Two formatting questions - workbooks & worksheets | 8/20/2009 |
| Q: You said you were cool with the simplest of questions so hopefully that extends to these: 1 - page ... A: Question 1 - I am assuming that you want the page numbers shown when you print the document. If so, ... | |
| dependent validation lists with dynamic ranges | 8/19/2009 |
| Q: I am creating a spreadsheet, with three columns. In column a the cells are validated and tied to the ... A: I think that the dynamic ranges you refered to will help you in your solution. If you use a dynamic ... | |
| Date Calculation | 8/18/2009 |
| Q: I am trying to build an event spreadsheet. Within this spreadsheet I wanted to enter the date of ... A: If the date is in cell A1, and the shipping date is to be in cell B1, you would need to enter this ... | |
| SUMIF (Array) | 8/17/2009 |
| Q: This is my result via a pivot table SERVICE Delivery Times 73 75 76 712 Grand Total 12.00am to ... A: I used the cell reference to note the time ranges you wanted to search in. So, A1 and A2 refer to ... | |
| Assistance in excel | 8/16/2009 |
| Q: In sheet, 1 have date in col. A and value in col. B. I could get in sheet2 the total of the values ... A: For your first question, you can use the following formula: =SUM(IF(MONTH(A1:A10)=4,B1:B10,0)) You ... | |
| Conditinal Formatting | 8/14/2009 |
| Q: I am making a room booking system and have two tables: 1 Current Bookings, 2 Gantt chart. On the ... A: You could probably achieve the solution you want by creating a macro, but I was not sure how ... | |
| SUMIF (Array) | 8/13/2009 |
| Q: This is my result via a pivot table SERVICE Delivery Times 73 75 76 712 Grand Total 12.00am to ... A: I believe the following formula would solve your problem: ... | |
| Adding a Constant value to Time in Excel | 8/12/2009 |
| Q: I am stuck.. I would like to add a Changing value to a specific time. e.g.: If I wanted to add ... A: If I am understanding your question correctly, I believe that this solution will help. Say you have ... | |
| excel no's validation | 8/9/2009 |
| Q: Pls help me Iam having a column, and each cell of that column has some phone no's . I need to check ... A: If I am understanding your question correctly, you want to notate which cells have more or less than ... | |
| Formatting Excel | 8/8/2009 |
| Q: I have an excel table with the following in one cell, listed out horizontally, separated by commas. ... A: I am not sure how much data you are working with, but here is a quick solution to get it done: 1 - ... | |
| drag number with substract | 8/6/2009 |
| Q: I need to drag 016622-2009 keeping -2009.. example are 016622-2009 016623-2009 016624-2009 A: In the first field type the following formula: =TEXT(ROW(A16622),"000000")&"-2009" What this does ... | |
| is 8000 a limit for the Solver? | 8/5/2009 |
| Q: In our company we try to solve a task of optimization that requires matrix of about 20 colomns and ... A: In viewing the website for www.solver.com, I came across the following information that may be ... | |
| Excel spreadsheet | 7/27/2009 |
| Q: I would like to have cells change color to flag up due dates. For example cell is currently green ... A: If I understand your question correctly, you want to change the cell color as the actual date ... | |
| ShortCut to insert date | 7/26/2009 |
| Q: When I do CTRL + :, date is inserted in a cell in a format as like 7/26/2009. I need to change this ... A: To change the date format, follow these steps: -Click on the Start button and select Settings, then ... | |
| Filter By Month | 7/22/2009 |
| Q: Jessica, I have a excel sheet containing of expenses report on daily basis. I want to filter the ... A: In order to filter expenses by month (or a date range) please follow these steps: -Select the ... | |
| Week Numbers Over Dates | 7/22/2009 |
| Q: My macro currently searches, copies and pastes dates. I need to stop using dates and start using ... A: I saw your question in the Question Pool - not sure if you got your answer already or not, but I ... | |
| Pivot Table Top 10 based on only one of many columns | 7/21/2009 |
| Q: I use Excel 2003 and have a pivot table that shows customers (rows) and their sales in units and ... A: If I understand your question correctly, you want to change the field that you use to sort the data. ... | |
| Text to column by vba | 7/21/2009 |
| Q: hai jan, i had recorded one macro to text to column my delemated data. my data contains two columns ... A: I saw your question in the question pool...not sure if you got your answer already or not. But I ... | |
| Excel | 7/16/2009 |
| Q: I have two rows of data that are not equal in legth with a bunch of part numbers in each. I want to ... A: Hey Brooke, I saw this question in the answer pool, not sure if you still need an answer, but maybe ... | |
| Filtering 2 kind format data with changing | 2/20/2007 |
| Q: Could I have an answer for filtering just the number format, if the data contains xxx123xxx i will ... A: To do this follow these steps: 1 - Select the column that contains your data 2 - On the top menu, ... | |
| TimeSheets 15 min Increments | 2/19/2007 |
| Q: I haven't heard from you for a yr. Did you find that new job??Me too I have a timesheet works ... A: Hey Dave, Sorry I didn't respond sooner! I didn't notice I had a question waiting :o) I did get ... | |
| macro + button | 9/26/2006 |
| Q: I want to run a macro from a button on an excel spreadsheet (Office 2003), but can't. Help says to ... A: Hey Rodney, I think you maybe created your button using the Control toolbar? Try using the Forms ... | |
| Missing Information | 9/25/2006 |
| Q: I presently maintain a company spreadsheet with several pages & file/tabs. Recently information, ... A: Does anyone else have access to your desktop? Also, it is possible you could have accidentally ... | |
| excel | 9/22/2006 |
| Q: Im not a great excel user,but use excel (Basic Stuff)and am self taught so far, I work in ... A: Hey John, I think I have a solution that may work for you. It's actually a little confusing and I ... | |
| excell | 9/21/2006 |
| Q: Im not a great excel user,but use excel (Basic Stuff)and am self taught so far, I work in ... A: Hey John, Let me make sure I understand what you are trying to do... Say column A is start time, ... | |
| Anchoring columns on different sheets | 9/20/2006 |
| Q: That's exactly what I was looking for. However, there are a few "quirks" with it. The biggest one ... A: Hey Andrea, Here is a fix for your problem: 1 - Select the Column that has the values, 0 and U. 2 - ... | |
| Anchoring columns on different sheets | 9/19/2006 |
| Q: This might be a very simple question, but I am wondering if there is a way to "anchor" or "lock" 2 ... A: Hey Andrea, I'm pretty sure that this is what you are trying to do: -Select Column A in Sheet 1 (do ... | |
| Please modify VBA | 7/19/2006 |
| Q: I am new to VBA. If you could help me modify the following VBA code, I would grately appreciate it. ... A: Hey Norm, Would it be possible to email me the spreadsheet so I can make the change and test it? ... | |
| excel probelm | 5/18/2006 |
| Q: i have following problem with excel when i try to open an excel file from my desktop or from my ... A: Hey Wolfgang, One reason why this could be happening is that you have the "Ignore Other ... | |
| pie charts from spreadsheets | 5/17/2006 |
| Q: I have a spreadsheet that includes sub-totals in list of expenditures for budget. I want to make a ... A: Hey Joyce, It would probably be easier to explain using your specific spreadsheet, but let me see ... | |
| V Look Up | 5/16/2006 |
| Q: Im using excel 2000 and Im trying to put data from 1 excel sheet into an invoice on sheet 2 of the ... A: Hey Adam, You can definitely use VLookUp to solve your problem. I found a pretty good tutorial on ... | |
| counting seconds | 5/15/2006 |
| Q: I have a sheet with the column for time the format should be h:mm:ss, the time begin with 0:00:00 ... A: Hey Shah, I think easier than making the macro you could do something like this.... If you type ... | |
| Split Screen | 5/13/2006 |
| Q: I am trying to do 2 different panes on 1 screen. I was able to split the screen and scroll on ... A: Hey Matt, It sounds like you split the screen instead of freezing the panes, which I think it what ... | |
| separation of words in an excel colunm | 5/12/2006 |
| Q: I have a technical question about creating walking lists, as those used by canvassers. Can ... A: Hey Jerry, You can follow these steps to seperate house numbers from street addresses. These steps ... | |
| copy specific cell to all sheets | 5/11/2006 |
| Q: my problem is that. I have an excel workbook that contains more than 120 same sheets. sometimes it ... A: Hey haplo, You can definitely change the same cell in all sheets. Just follow these steps: 1 - ... | |
| Shade a cell | 5/10/2006 |
| Q: Microsoft Office Professional Edition 2003 I am trying to lock and Shade a cell in Excel 2003 and I ... A: Hey Remon, I am not sure if I am understanding your question. Are you saying you want to recreate ... | |
| opening excel files in LAN | 5/5/2006 |
| Q: a client machine can see excel files on the server but when it tries to open any of them we receive ... A: Hey, Can you give me the exact error message you are getting? If it is the one I am thinking of, ... | |
| Formating Date | 5/4/2006 |
| Q: I am trying to create a spreadsheet and get the date to repeat with the next date in the next ... A: Hey Tonya, To get the date to repeat in all cells without typing it in, you can follow these steps. ... | |
| Columns - letters instead of #s | 5/3/2006 |
| Q: I'm sure there's a simple fix but I can't figure it out. Would you tell me how to change my column ... A: Hey Steve, Follow these steps to change the column headings from numbers to letters: 1. Click on ... | |
| formula to convert number to text | 5/2/2006 |
| Q: I print a LOT of checks using an Excel spreadsheet, am looking for a formula to convert a dollar ... A: Hey Carl, You can add a Custom Function to Excel to convert currency to text without using a ... | |
| Excel- Locking link to info and not cell | 3/12/2006 |
| Q: I have a workbook that I periodically place info into. It has numerous worksheets and I want to link ... A: Hey Jesse, Sorry for the delay in getting back to you. Would you be comfortable using macros to ... | |
| Comparing lists in excel | 3/11/2006 |
| Q: I use bothExcel 97 and excel 2003. I have two lists of serial numbers, one in column A and the other ... A: Hey Malcolm, The following formula should help you: =IF(ISERROR(MATCH(A1,$B$1:$B$4,0)),"",A1) Put ... | |
| countif(and | 3/9/2006 |
| Q: I want to write a excel formula using countif and and. it looks like this when I write it. ... A: Hey Mark, Adding an open parenthesis like this will fix the formula, but I don't know if it is ... | |
| split 2 words in one cell to 2 cells | 3/8/2006 |
| Q: I have a first name + family name in colomn A1 (for example, Bill Clinton). I wish to split the two ... A: You can split the cells by following these steps: -Select column A -From the top menu, select Data ... | |
| Summing values between 2 numbers | 3/6/2006 |
| Q: I have two parameters, namely Q and r. I +1 and have to find the sum of all values between r+1 and ... A: Hey KK, I'm not sure exactly what the Excel question is? Can you maybe reword the question for me ... | |
| excel userform for editing individual cells | 3/5/2006 |
| Q: . I Have a 51x51 grid i created using excel.. what i want is multiple users to fill out a form to ... A: Hey Scotty, If you need help getting started creating Userforms, this is a great site: ... | |
| How can I switch names in a column? | 3/4/2006 |
| Q: I have 1 excel column containing the person's first name and last name. I need a formula that ... A: Hey Sunny, This formula should solve your problem. It assumes that your cell containing the ... | |
| Extracting characters from excel cell | 3/2/2006 |
| Q: I have text in cell A2 in the format of lastname_firstname (e.g. robinson_john). I need to extract ... A: Hey Bridget, I have come up with a formula that I think will work for you. Also, I have noticed ... | |
| Advance charting | 3/1/2006 |
| Q: 2005 System I Performance detail Stock Date Buy Price Buy Date Sell Price Sold Result RIMM ... A: You can use Pivot Tables to do this. I think it would be a good solution for what you are trying to ... | |
| Delete selection from a listbox | 2/28/2006 |
| Q: Using Excel 2002 I have a listbox that is populated from several worksheets. I am using option ... A: Hey Bill, I apologize for the delay in getting back to you. I think your macro works sometimes but ... | |
| Formatting a spreadsheet | 2/28/2006 |
| Q: The file is actually being downloaded from Crystal Reports into excel and it puts the "Page" number ... A: Hey tcvb, This macro should solve your problem. It searches column A for the word "Page" and ... | |
| speaks Spanish | 2/27/2006 |
| Q: it speaks Spanish, wanted to learn but of Excel A: Yo no hablo español, pero encontré estas páginas en el web que pienso que le pueda ayudar: ... | |
| Formatting a spreadsheet | 2/27/2006 |
| Q: I have a number of excel sheets that are not formatted and they vary in the number of pages. I ... A: Hey tcvb, There is one part of your question I am not sure I understand....are you using the ... | |
| I am trying to make a newsletter... | 2/27/2006 |
| Q: I am trying to make a newsletter with pictures and writing that I'm pasting onto a background. I ... A: Hey Kayla, To remove an outline around a picture follow these steps: -Right click on the image and ... | |
| excel link to word | 2/26/2006 |
| Q: how do I link selected row to word document A: Hey Girlyn, I found these steps that I believe answer yourLinking to an Excel Worksheet To insert a ... | |
| Finding the sum based on adjacent cell | 2/26/2006 |
| Q: I'm using Excel 2002. I am trying to find the sum of a column based on the value of adjacent cells ... A: Hey Chris, You can use the SUMIF function to solve your problem. You will just need to change the ... | |
| How to delete certain rows. | 2/25/2006 |
| Q: I have a excel spread sheet with @ 1500 rows with 7 columns. In column A is the first determing ... A: Hey Rick, It sounds like you would need a fairly lengthy macro to solve your problem. You should ... | |
| printing in PDF | 2/24/2006 |
| Q: ------------------------- Hi Jessica, This was close, I had copied your code and pasted it into a ... A: Hey Dave, Did you have any luck with checking out the SendKeys method? I can take a better look at ... | |
| printing in PDF | 2/24/2006 |
| Q: It's been a while! Do you know of a way to add to this code: 'Print workbook ... A: Hey Dave, I was taking a break from Allexperts while I have been on the hunt for a new job...but I ... | |
| Formatting worksheet tab | 2/23/2006 |
| Q: Is it possible to change the formatting of the worksheet name on the tab at the bottom of a ... A: I'm not sure what version of Excel you are working with, but in Excel 2002 you can do this by ... | |
| Excel question | 2/23/2006 |
| Q: I have an excel worksheet with a lot of data but only four field SysID alphanumerical ... A: If I understand your question correctly, you can use the RANK function. Here is an example of how ... | |
| subtotals | 2/23/2006 |
| Q: I have a spreadsheet with 7 columns the first one is the date the second is the order number then 4 ... A: Hey Mike, You can insert subtotals pretty easily using the steps I found in the help file: 1 - Make ... | |
| Alternate rows | 2/21/2006 |
| Q: I would like to pick alternative rows and put them into another spreadsheet. I have a whole log and ... A: Hey John, I can definitely write a macro to do this for you. I just want to make sure you are ... | |
| pulling info from a database | 2/21/2006 |
| Q: I am trying to pull information from a database, that has to meet several criteria. I tried using ... A: Hey Alan, I'm not sure if this is the type of solution you are looking for..let me know if it is ... | |
| Eliminating Duplicate Rows | 2/20/2006 |
| Q: I have two tables. Each table has three columns of the same name. I want to create a table that ... A: Hey David, I think using a macro would be a good solution to your problem. I don't know your ... | |
| Held down the Shift Key too Long | 2/20/2006 |
| Q: I accidently held down the shift key on my keyboard for over eight seconds while I was distracted by ... A: Hey Jeff, I'm not sure what version you are using, but I found the following solutions to your ... | |
| Help in pivot needed! :) | 2/19/2006 |
| Q: I am working with an Excel-sheet consisting of both articles delivered and articles sold. One row ... A: Hey Anette, Would you be able to email me your spreadsheet so I can take a look at it. I'm not ... | |
| ? | 2/18/2006 |
| Q: .. can i please ask you... I have an excel spreadsheet with email addresses scattered all over it, ... A: Hey Greg, Sorry for the delay in my resonse. What version of Excel do you have? If you have Excel ... | |
| Subtracting Dates IF | 2/17/2006 |
| Q: =IF(H180;E180-now();0) H180 = empty cell with a formula in it.the formula is =INDEX('New ... A: Hey Paul, The explanation was a little confusing. Would you be able to email me your spreadsheet ... | |
| What is [group] | 2/16/2006 |
| Q: when working on a worksheet I suddenly noticed the chart icon and many other icons became ... A: Hey Steve, Group is actually a mode in Excel that allows you to edit several worksheets at once. ... | |
| Typing numbers in Excel | 2/16/2006 |
| Q: For example when I type numbers into the individual cells such as 1, 2, 3, 4, 5,6, 7, 8, 9, 10--it ... A: Hey Erica, I think I understand your problem now :o) I think you need to set the Format of your ... | |
| Typing numbers in Excel | 2/16/2006 |
| Q: When I type in the number 4 in Excel 2002 a 6 appears. But if I type a combination with 4 in it ... A: That is really strange. Is this only happening with the number 4? Can you give me an example of ... | |
| query about excel | 2/14/2006 |
| Q: Q1. How to merge two excel fiel ? Q2. What is consolidation ? Q3. What is pivot table ? A: Here are the answers to your questions: Q1. How to merge two excel fiel ? ANSWER: Select both of ... | |
| copy paste | 2/5/2006 |
| Q: I want to copy the formula in cell A1 and paste it to all cells A2-A8760. The conventional method of ... A: Hey William, You can do this with a macro. Here are the steps you would follow. I don't know if ... | |
| formatting cells | 2/2/2006 |
| Q: I'm running Office 2003. In Excel, if someone sends me dates that are formatted in this manner: ... A: Hey Jercel, Are the dates all in one column? If so, follow these steps: -Select the entire column ... | |
| macros/colour | 11/16/2005 |
| Q: I am using Excel 2003 and have been given a problem with one of the people i work with that has ... A: Hey Jody, I think I understand your question and I think that Conditional Formating will solve your ... | |
| excel command scripts | 10/17/2005 |
| Q: i've been searching for a way to write a script in excel that will allow me to create a number of ... A: Hey Nick, You can definitely use a macro to do this. I couldn't tell from your question if you are ... | |
| excel scroll bars | 10/16/2005 |
| Q: I made a schedule in Excel 97 and sent it to a colleague by e-mail. When she received it and opened ... A: You should check if the horizontal scroll bar property has been de-selected. Here are the steps to ... | |
| Max function | 10/15/2005 |
| Q: i wud like to know how to max function will work with text for example a101 b102 c103 a104 kindly ... A: Unfortunately, the MAX functions only work with numbers. As soon as you put a letter in to a cell ... | |
| sort | 10/14/2005 |
| Q: On occasion when I sort a spreadsheet for some reason the sort function works except for the very ... A: An explanation for what could be happening is that when you are in the Sort window box, you have ... | |
| back up files | 10/12/2005 |
| Q: I have a file that backs up when the user closes the workbook it goes something like this: Private ... A: Hey Dave, Try this code if it is ok for you to have the date added before the filename. If this is ... | |
| Excel Protection | 10/12/2005 |
| Q: but I beleive that excel 2000 does not have an 'Allow all users of this worksheet to:' option - when ... A: Sorry, I did not notice that you were working with Excel 2000. You are right, this feature does not ... | |
| hide a cell | 10/11/2005 |
| Q: I want to hide a cell. In the past, I click on "Format", "Cells", and click on "Custom" in the ... A: I am not sure why it has left the list, but you should be able to add it back. Follow these steps ... | |
| Excel Protection | 10/11/2005 |
| Q: I need to Protect a sheet in excel (2000) whilst being able to change the format of one cell in that ... A: If I am understanding your question correctly, these are the steps you need to follow: -Select the ... | |
| values that make a sum | 10/10/2005 |
| Q: I want to find the values that make a sum in a range. Eg : values 7, 8, 9, 107, 108, 90. Sum I'm ... A: Unfortunaltey, I don't know of a formula in Excel that will give you the results you are looking ... | |
| Graphs | 10/10/2005 |
| Q: I tried to reply to your answer to me but it said you were maxed out so I deleted it and I still ... A: Would it be possible to send me the spreadsheet so I can take a look? My email address is ... | |
| manual page break | 10/7/2005 |
| Q: I do not know which version of Excel I am using, but it is not too new. Exploring "options" ... A: Let me make sure I understand your question. Do you mean you forgot how you selected page breaks in ... | |
| Excel database to outlook mail | 10/7/2005 |
| Q: ..I was recently asked to put some business cards into a database. Can i create the database in ... A: Not sure if I met your deadline (was it AM or PM?). But I only check the allexperts.com emails ... | |
| listbox | 10/7/2005 |
| Q: I have created a multiselect userform creating the listBox in vba, ie .addItem . How can I create ... A: Hey Dave, Try this code: Private Sub UserForm_Initialize() Dim ListItems As Variant, i As Integer ... | |
| Transpose | 10/6/2005 |
| Q: Can you give me an idiot's guide to using the transpose function? I just want to turn a long row of ... A: Hey Richard, Definitely! Follow these steps: -Select the row that you want to transpose -Right ... | |
| How to learn excel and evaluate my skill? | 10/6/2005 |
| Q: What is the best way you were recommend for learning Excel? I've taught myself quite a bit just by ... A: I too have taught myself in Excel. I ALWAYS use the help files provided and I am constantly ... | |
| Protecting, Grouping and Greetings | 10/5/2005 |
| Q: Which Cell(s) does this sample protect? How do I 'start' this macro and how can I end it? Does it ... A: Hey Dan, Sorry! I should have put more detail :o) You put this code in the Worksheet Change Event. ... | |
| Remove "old" links in an excel file | 10/5/2005 |
| Q: I have built an excel file over timt that once was base on some old excel files. Now I have a ... A: I think this will help you...it is steps on how to break a link from one sheet to another: Break a ... | |
| Spatter Plot | 10/5/2005 |
| Q: -------------------------First of all THANKS for your response. I still have a question about this. ... A: Hey Ed, The formula to solve for Y is called the linear trendline calculation: y=mx +b where m is ... | |
| Conditional Formating | 10/4/2005 |
| Q: Using a conditional formatting allows to add only three conditions. What to do, if you want to add ... A: It is possible to use conditional formatting with more than 3 conditions, but you will have to use ... | |
| Spatter Plot | 10/4/2005 |
| Q: My grandson has to make up a Spatter Plot on a decrease of population for the county we live in. No ... A: The part of the formula "+2E + 06" can be translated to "2 times 10 to the 6th power" which would ... | |
| Auto Resize Cells | 10/4/2005 |
| Q: ------------------------- Thanks for your reply, I understand how to rap the text - but the size of ... A: Hey Bruce, There are a couple of reasons why the text could not be showing. -Excel can only have a ... | |
| Auto Resize Cells | 10/3/2005 |
| Q: I am trying to create an electronic form using excel 2000, where the user will enter data only into ... A: To set text to wrap in a cell, follow these steps: -Click on the cell you want the text to wrap in ... | |
| replacing formulas | 10/2/2005 |
| Q: I have made an Excel spreadsheet which contains many lines. Each line has cells for data input and a ... A: Hey David, Is there any way you can send me your spreadsheet so I can see the exact formula you are ... | |
| Opening Excel | 10/1/2005 |
| Q: I cannot open an excel spreadsheet that was saved in"my documents". I have to go to excel and then ... A: Double check that the spreadsheet was not accidentally saved in two different places. To see if it ... | |
| Restricting toolbars | 9/30/2005 |
| Q: how can I make it so that anyone who opens my spreadsheet would have to view the normal toolbars? I ... A: Hey Dan, To make your custom toolbar appear when the spreadsheet is opened, this is what you would ... | |
| Mailmerge | 9/29/2005 |
| Q: My girlfriend is trying to do a mailmerge of mailaing address for her wedding. She needs to know ... A: Tell your girlfriend I said Congratulations! I got married last year, so I know how stressful it ... | |
| using the countif function | 9/29/2005 |
| Q: 527.56 500.36 528.00 523.81 521.33 527.72 529.01 518.01 529.02 526.05 528.32 527.42 526.65 528.59 ... A: I think this formula will help you: =COUNTIF(A1:A38,">500")-COUNTIF(A1:A38,">520") You will just ... | |
| Excel linked cell data disappearing | 9/28/2005 |
| Q: My goal is to reformat many similar word documents into excel so that if I need to make a change, ... A: Do you mean that the cell width is too narrow for the cell contents to appear? If this is the case, ... | |
| Negative numbers | 9/28/2005 |
| Q: I have a column that has a formula in with a number, this number can be positive or negative. In the ... A: For my example, assume that column A has the numbers (both positive and negative) and that your ... | |
| 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: Unfortunately, you cannot link formats, just values. To link a value from another sheet..you just ... | |
| OR function | 9/27/2005 |
| Q: I'm trying to test input cells to meet specific criteria, i.e. whether a "y" or "n" has been inputed ... A: Hey Sean, You can use Data Validation to solve this problem. Here are the steps: -Select the ... | |
| Excel (in MS Office 2000 | 9/27/2005 |
| Q: This problem has occurred on two different PC's Both running Windows-98 SE. EXCEL works fine for a ... A: Hey Trevor, Wow, that sounds pretty annoying :( Unfortunately there could be a few reasons why this ... | |
| SUMIF Criteria | 9/26/2005 |
| Q: Excel 2003, Windows XP Hi Jessica My problem is with the SUMIF formula I currently use the ... A: I am not sure if I am understanding your question correctly...but if I do I think this will solve ... | |
| Filtering I think | 9/22/2005 |
| Q: Two column list, the date being column A. Title and brief description of legal ordinances in column ... A: I hope I understand your question...you want to search for a word and display the corresponding cell ... | |
| Excel link and copy | 9/20/2005 |
| Q: I am trying to copy data from one sheet to another sheet within the same workbook, but i need the ... A: To have the data linked from one sheet to another in the same book, you will just need to reference ... | |
| Countif | 9/19/2005 |
| Q: It worked. It also gave me an idea using MONTH. I had column A giving dates of matches, column B ... A: Hey Alan, The reason why this, =COUNTIF(B1:B300,1:3), does not work is because the 2nd parameter of ... | |
| Excel spreadsheet | 9/18/2005 |
| Q: I have two prize lists (Series & HiGame) of bowlers. Bowler can win only once, with Series taking ... A: Hey Jerome, I think this will solve your problem: Since the top set of winners takes precedence, ... | |
| Countif | 9/18/2005 |
| Q: I have Excel 2002. I have a column of dates of matches (bridge games) from 1 April in one year to ... A: Hey Alan, I'm not sure what you mean by the range (12345:23456). Is this what you are trying to ... | |
| change tab reference in formula | 9/16/2005 |
| Q: Jessica. I am developing a large register (of leases) that has one lease per worksheet (tab). At the ... A: Hey Lawrence, I believe you could use a User Defined function to solve this problem. If you want ... | |
| typing a number into a cell | 9/16/2005 |
| Q: I am trying to type in 2003-04 into a spreadsheet. The number keeps changing to 2003-05. I have gone ... A: Hey Paula, I'm not sure why that is happening for you, I was unable to recreate this problem. If ... | |
| Charting | 9/15/2005 |
| Q: I have a simple chart with a date in one column and a number in the other. Every day I add another ... A: Hey Guy, Would it be possible if you could email me your spreadsheet? I can try to make a change ... | |
| IF function | 9/14/2005 |
| Q: Jessica. I need help with the IF function in Excel 2003. I'm working on a worksheet for a company ... A: Hey Maria, In the blank cell in the total column that should contain the shipping amount, put this ... | |
| What is the Future of Excel VBA ? | 9/14/2005 |
| Q: I'm using Excel 2003. With Excel 12 and the new Windows system Vista ahead, what is the future of ... A: Hey Ken, From what I gather Excel 12 contains mostly user interface and functionality changes. All ... | |
| 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: Hey Sharon, I'm not really sure how the M32 file became overwritten with data from NI 184, but ... | |
| Filter Counter | 9/13/2005 |
| Q: Most times when I use filters in Excel (once turned on) there will be a text thing that at the ... A: I know that can be pretty annoying! I actually found an article about this on the microsoft website ... | |
| charts | 9/12/2005 |
| Q: I have a excel spreadsheet showing my poker results over a period of time - but I cant figure out ... A: Hey William, I think it may be easier if you could possibly email me your spreadsheet and I can ... | |
| Need VBA ToolBar Help Please | 9/5/2005 |
| Q: Jessica. How are you ? I'm using Excel 2003. I have just read about and experimented with ... A: Hey Ken, I'm doing well..how are you? Sorry for the delay in my response. I think this solution ... | |
| Creating a MTD total | 9/5/2005 |
| Q: Coloumn A is the current (today's) total. Column B is the MTD total. How can I get Column B to ... A: I actually found a solution to this problem at this site: ... | |
| Hi Jessica! i've been trying... | 9/4/2005 |
| Q: i've been trying to figure out how to do this excel problem and its been bugging me for quite ... A: Hey Alvina, Wow! This is a tough one! :o) Unfortunately, I can only help with questions directly ... | |
| Creating a database to manage lists of my students | 9/3/2005 |
| Q: I know nothing about databases and I've never used Excel. I have Windows XP and MS Office 2000, but ... A: You can totally do this with Excel :o) If you want, I can create a template for you to enter your ... | |
| disallowing users to save changes | 9/1/2005 |
| Q: I have prepared a worksheet that we are using for a template. I want users to be able to insert ... A: Hey Tom, Sorry for the delay in getting back to you. What you could do is just allow the user to ... | |
| Date Formatting | 8/31/2005 |
| Q: I have a program which requires a column of Dates to be formatted a certain way, i.e. "mm/dd/yy". I ... A: This is what you need to do to format a date from dd-mm-yy to mm/dd/yy: -Insert a new column next to ... | |
| Excel | 8/30/2005 |
| Q: I am getting the #DIV/0 in a column and would like the cells to be blank until the data is entered ... A: Assume that you have a number in cell A1 and you want to divide it by a number in cell A2...in the ... | |
| Excel Non-duplication | 8/30/2005 |
| Q: I have a question. I am using an excel sheet to revise our inventory numbering system. ... A: Hey Michelle, I think this solution will work for you: Let's say your data is in cells A1:A50, and ... | |
| EXCEL WORD SERCH? | 8/25/2005 |
| Q: i know you can search and replace words in MS WORD but can you do it in Excel office 2000? and if so ... A: Yes, you can search and replace words in Excel 2000. These are the steps you would take: Replace ... | |
| formula to shade cell without conditional format | 8/24/2005 |
| Q: xp-excel 2003 Is there a formula to have a cell shade to a color depending on the day of the week? ... A: You can use a macro in order to solve this problem. -Unlike standard macros which are installed ... | |
| Date and Time formula's | 8/24/2005 |
| Q: XP & excel 2003 My questions are 1st in cell A1 I have 5/18/05 22:00 and in cell B1 I have =now(), ... A: 1stMy questions are 1st in cell A1 I have 5/18/05 22:00 and in cell B1 I have =now(), Is there a ... | |
| variable input to interative calculation | 8/23/2005 |
| Q: I have developed a spreadsheet Excel 2002 with numerous inputs and outputs that uses excels ... A: Hey Keith, Would you be able to email me your spreadsheet so I can take a look at what you mean? ... | |
| spreadsheets | 8/23/2005 |
| Q: i want to know all the basic steps to make a spreadsheet and also different types of spreadsheet.can ... A: These tutorials should be a good start. If you have any specific questions, don't hesitate to ask! ... | |
| CountA Formula In VBA Not Working Right | 8/22/2005 |
| Q: Jessica. I am using Excel 2003. I have entered the code below, which works fine, except the COUNTA ... A: Hey Ken, I made this modification to your code: rcount = ... | |
| Area & Volume estimating | 8/21/2005 |
| Q: I need help to set up in excel a method to work out both the Area and the Volume for concrete ... A: Hey Bob, Are you asking for what the formulas would be for area and volume for the shapes you ... | |
| Excell error | 8/20/2005 |
| Q: I formatted my PC & did a clean install of Windows Xp PRO when i opened Excell i get this error ... A: The following resolutions should help your problem: Method 1: Download the latest version of the ... | |
| excel | 8/19/2005 |
| Q: in excel, what is a label? A: A label in Excel is a type of data that you can enter into an Excel worksheet. A label is always in ... | |
| conversion of days to dates | 8/18/2005 |
| Q: I have over 5000 entries which are psuedodates which I would like to convert to "dates" in excel ... A: It seems as though you have dates in your spreadsheet that are in two different formats, unless the ... | |
| Excel Footer or Template | 8/18/2005 |
| Q: I am about to begin another school year. I teach introduction to computers and computer ... A: Sorry for the delay in answering your question. I have actually been interested in doing this same ... | |
| Running Excel 2000 | 8/16/2005 |
| Q: I am running Windows EP. I loaded Office 2000 two years ago. For some reason Excel will not load. I ... A: Sorry about that, this must be really frustrating for you! Unfortunately, there could be any number ... | |
| Addressing '99999' values | 8/16/2005 |
| Q: My problem is that in the dataset, the author has used '99999' to denote a failed measurement, or an ... A: If I am understanding your problem correctly, I believe that this will help: You would need to ... | |
| saving files | 8/15/2005 |
| Q: Certain users aren't able to save files in Word/Excel. They are getting disk space error messages. ... A: I was able to find a website that seems to describe your problem. The information is below: ... | |
| Worksheet Limit | 8/15/2005 |
| Q: I had created a very large excel file with most of the worksheets being tabloid size. When I ... A: Hey Kath, The amount of Sheets you can have in a workbook should only be limited by your available ... | |
| Running Excel 2000 | 8/15/2005 |
| Q: I am running Windows EP. I loaded Office 2000 two years ago. For some reason Excel will not load. I ... A: Although this has never happened to me before, I have seen this same problem on an Excel message ... | |
| Excel beginner tutorial | 8/13/2005 |
| Q: I'm looking for good basic info to teach Excel to my boss. I have a basic knowledge of the program, ... A: Hey Buddy, These tutorials should be a good start. If you have any specific questions, don't ... | |
| Deleting duplicate listings | 8/12/2005 |
| Q: I have a list of names. Many of the names are duplicates. How do I delete the duplicate listings? I ... A: You could flter for unique records to solve your problem. This is what you would do: -Select the ... | |
| Free Chart Objects From Cell References ? | 8/11/2005 |
| Q: I'm using Excel 2000. On Sheet1 is Chart Object "Chart 1". What macro code will make the ... A: Hey Ken, Sorry about the delay in answering your question..this was a tough one! I think this will ... | |
| TRUE or FALSE Function (I think) | 8/11/2005 |
| Q: I am using Excel 2000 I got a list about 7000 numbers some of which are duplicated. I am trying to ... A: You could flter for unique records to solve your problem. This is what you would do: Select the ... | |
| Hello Jessica - I am working... | 8/10/2005 |
| Q: I am working as a volunteer for the AIDS foundation in my area. Right now all the information is ... A: You can absolutely do this with Excel. I will be glad to help. You can use a column for SSN and ... | |
| Disabled Items | 8/10/2005 |
| Q: Using Microsoft Office 2002 I have a very important file which is getting added in disabled items ... A: I'm assuming you ran 'Detect and Repair' off of the Help menu. If not, I would suggest trying that ... | |
| EXCEL ROTA WORK SHEET | 8/9/2005 |
| Q: very helpful, the names do not have their own sheet, if there are 200 names they would be split ... A: Would it be possible to send me the worksheet so I can get a better understanding of the layout you ... | |
| EXCEL ROTA WORK SHEET | 8/9/2005 |
| Q: My working week consists of 4 days "ON" and 2 days "OFF" as below SUN MON TUE WED THU FRI SAT ... A: I believe I can answer one part of your question, but I will need a little more info on the other. ... | |
| Excel Format | 11/18/2004 |
| Q: I have very simple question but i could not figure out. I want to explain by example I have data in ... A: Is the data you described (00 03 01 02 d2 g5) in one cell? If so, in order to get it to look like ... | |
| Formatting in excel | 11/17/2004 |
| Q: I have rated you 10 out of 10. I forgot to mention though that the time and date has been imported ... A: You can do this pretty simply by completing the following steps. 1) Click on the square above the 1 ... | |
| Formatting in excel | 11/17/2004 |
| Q: I have a spread sheet with some times in, (from 06:00 - 05:59) i need to highlight or mark in ... A: You would complete the following steps in order to solve this problem: 1) Click on the square above ... | |
| Opening .xls without Excel Software | 11/16/2004 |
| Q: I infrequently receive excel spreadsheets with info on them that I am supposed to open and read--not ... A: I believe this link would be useful to you: ... | |
| Formulas | 11/16/2004 |
| Q: Is there a formula for counting for example: sum of all the Green cells in range a1:d14 or the sum ... A: I am not sure if you are familiar with user-defined functions, but this is how I will answer this ... | |
| Text formula | 11/15/2004 |
| Q: I am using XP and Excel 2002 I have a column of text data that each cell contains 6 letters ... A: I believe this is the formula you are looking for. Assume that IEGKLE is in cell A1. You would put ... | |
| Excel for children | 11/14/2004 |
| Q: Jessica I am currently training in ICT. I want to incorporate excel in my lesson plan. Have you ... A: Here are a couple of websites that I think may be helpful for you: ... | |
| How can I generate a new column... | 11/13/2004 |
| Q: How can I generate a new column showing the differences between two columns of data? thank you. ... A: I'm not sure I understand your question. Do you mean just having a column that just does simple ... | |
| EXCEL 2002 CUMULATIVE TOTAL | 11/12/2004 |
| Q: We're getting closer this time I apologize for not being clearer example DAILY TOTAL MONTH ... A: From what you are describing, it still seems to me that my first response with the macro would be ... | |
| EXCEL 2002 CUMULATIVE TOTAL | 11/12/2004 |
| Q: but this seems to just be adding the two columns together - what we need is - example DAILY TOTAL ... A: I understand your question now, sorry for the confusion :o) This would be your solution: Assume ... | |
| excel | 11/12/2004 |
| Q: i would like to know if there is a way to combine data from a chart in one sheet with a chart in ... A: If I understand your question correctly, I believe this is your answer. In order to use data from ... | |
| Excel to PDF Creates 3 files! WHY? | 11/12/2004 |
| Q: I have an Excel spreadsheet with 8 worksheet tabs at the bottom. When I try to print all the ... A: WOW! That was a great visual animation..very thorough :o) This seems to be a problem with Excel, it ... | |
| EXCEL 2002 CUMULATIVE TOTAL | 11/12/2004 |
| Q: GOOD MORNING, HOW WOULD I SET UP A CUMULATIVE TOTAL EXAMPLE: WE ENTER DAILY SALES FIGURES INTO ONE ... A: In order to do what you need to do, you will have to create a Macro. Here are the steps: 1) In ... | |
| Writing macros - Testing applications on run | 5/17/2004 |
| Q: Inside a macro, I wish to test if an application is already running, in order to avoid to launch it ... A: Is the application you are checking for a Microsoft application? If so, I know you can use this: ... | |
| Openig Excel files | 5/15/2004 |
| Q: Can you explain why when I open an Excel file from "My Computer" I get a message that tells me it is ... A: Try re-registering your Excel: 1 - Click the Start button 2 - Click on Run 3 - In the box, type ... | |
| EXCEL FORMULAS | 5/14/2004 |
| Q: I AM TRYING TO USE THE FUNCTION THAT LETS ME TAKE OUT THE LEFT MOST CHARACTERS IN A LINE OF DIGITS, ... A: I believe this formula will work for you. Just insert a column next to the one you would like to ... | |
| Dear Jessica, Thank you... | 5/13/2004 |
| Q: I should've mentioned that when I check off the "Black & White" box, it doesn't help. I get to ... A: I took a look at the Microsoft help database to see if they have an answer for this problem. I ... | |
| FILTERING | 5/13/2004 |
| Q: I have a table of values with 5 columns and up to 200 rows. In the first column is the date (ie 16 ... A: I'm not sure I am totally understanding this question. If you want to get rid of everything after ... | |
| Hi, For some reason I can... | 5/12/2004 |
| Q: For some reason I can print Excel documents only in black even though they are in grayscale (or ... A: Try this and let me know if it does not solve your problem. 1) Click on File on the top menu, then ... | |
| Macro to round a figure (%) | 5/12/2004 |
| Q: Here's what i'd like to do : I got a "variation" (excuse my french!) in a cell and i would like it ... A: I have to apologize, I received an email from AllExperts saying that I did not answer this question ... | |
| xcel | 5/12/2004 |
| Q: I have copied so many names from the web site to excel. Each name has a email address. But i need ... A: Not sure if I totally understand the question. Could you email me an example of the spreadsheet ... | |
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
Jessica L.
Top Expert on this page
Expertise
I can provide answers for most Excel problems. I don`t mind answering even the simplest of questions.
Experience
I am a self taught Excel user and have been using Excel for about 12 years.
©2009 About.com, a part of The New York Times Company. All rights reserved.