| Thread | Last Post | Replies |
|
| Priceslist help | 01 Mar 2006 17:53 GMT | 2 |
I am new to excel so go easy on me! I am trying to complete a pricelist. I have over 500 items each with 11 different prices. I would like to enter the cost price for all the items in the cells but Is there a formula I can enter so if I enter say for e.g.. 30%, 45%, 50%, 60% as
|
| Toggle between worksheets | 01 Mar 2006 16:23 GMT | 2 |
Normally you would see the multiple Excel icons at the bottom knowing you have more than one application open. When I open 2 or more excel worksheets I only see 1 icon and I cannot toggle between each one using the ALT-TAB keys.
|
| Text only in toolbar buttons | 01 Mar 2006 16:03 GMT | 2 |
I would like to know how to set custom toolbar buttons to display text only and no picture? Thanks, Thierry Paradis
|
| Hidden data when pasting from html page into Excel? | 01 Mar 2006 15:53 GMT | 1 |
I have a situation where I copy a report, which is generated as an html page, into Excel for analysis. When a new copy/version of the report is available, I copy and paste the new data over top of the old in Excel. I've noticed that the size of my Excel file is growing after each ...
|
| Problem Importing Data Using Wizard | 01 Mar 2006 14:34 GMT | 8 |
I have a text file with contents that look like this: 02/06/2006 16.02.00 This is the date and time. I want this data imported into one cell and treated as a text string. When I use DATA-->Import External
|
| Error 0x800A03EC trying to set range value | 01 Mar 2006 13:22 GMT | 2 |
When trying to set the range value of the spreadsheet I get th following error: Exception from HRESULT: 0x800A03EC. BuildXls method follows: public string BuildXls(string FileName, ref string[,] AryFieldsAll
|
| Number of days between 2 dates, if end date is blank assume todays | 01 Mar 2006 12:41 GMT | 1 |
I need an excel formula to calculated the number of days between 'Start Date' and 'End Date'. IF the 'End Date' is null I want to use todays date. Please Help
|
| Need example | 01 Mar 2006 12:21 GMT | 6 |
I am a student, currently enrolled in a online course dealing with Microsoft Office 2003. One of the requirements is to post responses to questions from the instructor on the classroom discussion board. This weeks question concerns Microsoft Excel and states "Give an
|
| Simple "if word exist among theese cells, then true" | 01 Mar 2006 11:53 GMT | 3 |
Im banging my head on the "find" functions. They give me a -value- when I need TRUE/FALSE for an IF function. It must be a much easier way to return TRUE or FALSE if a word exist within an area:
|
| How to speed up Autofiltering? | 01 Mar 2006 11:40 GMT | 13 |
How to speed up Autofiltering? Excel 2003 sp2 hangs up for 10 minutes after I choose a record in the Autofilter.
|
| inserting '0' into a excel cell | 01 Mar 2006 11:26 GMT | 2 |
hi i trying to put a phone number into a cell in a excel workbook, the number starts with 0191 ( the diling code) , the computer sees this as a minus and drops the '0' for a '-'. how can i include the '0' in the phone number?
|
| drop dpwn tables in excel | 01 Mar 2006 10:39 GMT | 2 |
hi, i working on a little spreadsheet and would like to insert a dro down table, tht allows some pre-written answers to be inserted into cell, for example : under the heading 'type of order', the correc answerss would be 'model', 'tool' , 'base'. how do you insert drop dow
|
| How to get separate Taskbar Buttons for each Excel Document? | 01 Mar 2006 10:30 GMT | 2 |
I am working on Windows 2000 Professional, with MS-Office 2000 installed. MS-Excel version is (9.0.6926 SP-3). Untill very recently, when I used to open multiple Excel documents, I used to get separate buttons in Taskbar for each of the open document. But now, i
|
| Excel 2003 is not letting me select all cells | 01 Mar 2006 09:21 GMT | 1 |
I just recently upgraded Office to 2003. Excel is acting weird! When I am trying to AutoFormat cells Excel is not letting me celect all the cells in my worksheet. It either goes horizontally, or vertically, but not both. Where do I uncheck the restrictions?
|
| Need more complex data validation than I can see available from the menu | 01 Mar 2006 09:17 GMT | 8 |
I have an excel 2003 spreadsheet, and I want the data in cell B to be between 2 values if the data in cell A is between 2 other values. For example, cell A contains an annual review score. Cell B is to contain a merit increase percentage. Once the user has entered a score in ...
|