| Thread | Last Post | Replies |
|
| Length cell limited ? | 18 May 2005 21:09 GMT | 2 |
It is needed to insert in a combined cell a chain of but of 1500 characters however happens the following thing: although the information is complete in the cell, the chain is visualized partially since in form alone the first 1170 characters appear.
|
| Searching an entire workbook for text | 18 May 2005 20:48 GMT | 4 |
Does anyone know a way to do a text search in a workbook? This for a Workbook that has a bunch of worksheets and I'm trying to find away to search the entire workbook without having to go to each worksheet. Is there a simple way to do this?
|
| If main heading is selected, sub headings auto-selected | 18 May 2005 19:55 GMT | 3 |
I have a spreadsheet that lists a bunch of topics, and subtopics. I want to set up a formula or something so when one of the main topics is selected, all the subtopics are automatically selected. I'm thinking this will probably require a macro, or maybe hidden
|
| creating basic macros in excel | 18 May 2005 18:28 GMT | 2 |
I am trying to run a simple macro that filters out data. For example, I have a spreadsheet with ten columns. However, I do not need all 10; I want to select particular columns and re-arrange them in a specific order. I think this is pretty basic so any help would be ...
|
| How do I add time when some of the increments are less than an ho | 18 May 2005 18:20 GMT | 1 |
|
| Incorrect Calculation | 18 May 2005 17:55 GMT | 5 |
I have noticed that Excel 2003 does not always calculate figures correctly. I have been trying to total up an invoice by having a subtotal & a VAT cell (VAT being the subtotal plus 17.5%). Being as VAT is 17.5%, the figure calculates is sometimes a half penny.
|
| =Text(b2-A2,"h") hours between 2 times, what do I do for 10 times | 18 May 2005 17:54 GMT | 3 |
I am trying to do a work schedule for work. I am using an excel worksheet and typing the starting time ex. 8:00 am in Cell A2 and ending time 5:00 pm in Cell B2. I need to add the total hours worked for two full weeks. I have the formula
|
| Drop down box with country list | 18 May 2005 17:18 GMT | 1 |
I have an excel application where I need a drop down box with all the country' names listed, ready to use (like the Microsoft Date and Time Picker Control). Is there a way to get it and how? John
|
| How can I paste a table of data into Excel from a MSIE / web browser? | 18 May 2005 16:32 GMT | 4 |
Is there any way to paste out of a table on a web page, *straight* into msExcel2002, but without taking microsoft all the friggin Micro$oft formatting with it. I just want the data, but I also want the table
|
| Implementing Drag & Drop in Excel sheets | 18 May 2005 14:56 GMT | 2 |
Anyone have any information on implementing drag & drop on Excel sheets? We have a need to be able to drag and drop cells (special cells that our application manages and can recognize) and track where they are dragged from as well as where they are dropped so that we may
|
| Excel 2003 doesn't calculate (not allways!) | 18 May 2005 13:42 GMT | 1 |
another thread another problem... we do have a strange problem with our excel 2003 (sp1) installatio (Windows XP SP2).
|
| calculate day for day | 18 May 2005 13:40 GMT | 3 |
I need a formula to calculate day for day for a 365 year. The only function I can find in excel is days360. For example: If I took a vacation from 1 mar 04 thru 10 mar 04 that would be 10 days. Which I can do with SUM +1 but if the cells are blank I need the
|
| Cut from workbook1, paste to workbook2, get automatic link in workbook1 | 18 May 2005 13:15 GMT | 1 |
Greetings all! I am running Excel 2000 on a Windows XP Pro machine. I have two workbooks. Each row in either workbook is a description of a document with a date by which a review of that document is due (among other
|
| lookup | 18 May 2005 08:58 GMT | 3 |
learnt lots from these pages and now have formulas doing all my results, but i can't find a way to auto my entries. i have 900 students with a larges number entering say the athletics. column A first; B surname; C house; D grade; E gender; F 100m to Q discus. i put a 1 in the ...
|
| How to merge records into one record by customer's name? | 18 May 2005 04:50 GMT | 3 |
How can I merge repeating records of a customer who has different oders of products? Ist col, Company name, 2nd col cust name, 3rd-10th col Product items Thks,
|