| Thread | Last Post | Replies |
|
| Unable to double-click cell for editing | 19 Jun 2005 15:09 GMT | 4 |
For some reason I can no longer double-click a cell to edit its contents. I have to select the cell and then edit its contents from the formula bar. I used to be able to double-click a cell and edit text from within the cell. I don't have any problems in any other
|
| hide menu | 19 Jun 2005 14:26 GMT | 1 |
Please help me to solve this problem. I have created a spreadsheet. Now I want to hide the menu ( so that copy, paste) is not accessible by others. Also others can input data on it but cannot change it. Thank you
|
| Countif question | 19 Jun 2005 05:31 GMT | 5 |
How do I use COUNTIF if I want the criteria to be greater than the value in cell B1? Thanks in advance. Barb Reinhardt
|
| Which formula to use ? | 19 Jun 2005 05:12 GMT | 4 |
I've tried messing aroung with a couple of formulas in an attempt to sort this out, however nothing seems to be resulting in what I'd like to accomplish. I've done up an example of what I'd like to do... I would like to be able to have a persons name entered into column A if the
|
| Seeking a solution to a time-consuming problem... | 19 Jun 2005 03:24 GMT | 4 |
I am hoping someone can recommend a solution for a time-consuming problem that I run into often. I create and modify Excel sheets that are used to record data on a regular basis. Often the modifications done to these sheets require
|
| Find what values equal a total | 19 Jun 2005 01:34 GMT | 1 |
Say I have a list of various values that add up to 100. I also have two subtotals, say 35 and 65. Is there a formula or a way to easily find which of the values would add up 35 and which would add to 65? Thanks.
|
| Macros/Signatures Question | 19 Jun 2005 00:40 GMT | 1 |
I have an Excel Workbook that I created for a PC Order Form. I set it up to only make certain rows visible based on the Machine Model that they choose. I digital signed the Worksheets and exported the Digital Signature Certificate and installed it on the User’s PCs. The code ...
|
| Duplication and colors | 18 Jun 2005 23:37 GMT | 7 |
Can anyone please help me with the following :- I have 5 columns and about 60 rows of various numbers. There are a number of duplicate entries in some of the cells. When I have the cursor on a certain cell, say B5, is there a way for excel to find and
|
| Help with a formula please | 18 Jun 2005 22:48 GMT | 2 |
I have 2 work sheets - sheet1 lists daily items i.e. entry date, no of entries, amount of entries etc (one day per row), sheet2 is a summary of the daily totals. I have been asked to produce a summary of the daily totals on a weekly basis. So on sheet1 we will have 5 rows, but ...
|
| Row Height | 18 Jun 2005 18:16 GMT | 2 |
I'm working on this spreadsheet and we are constantly adding more information to these cells in a certain column. After a while when there is a lot of text added into the cell, it begins to not continue wordwrap-ing it anymore, and cuts it off, as well as when choosing AutoFit ...
|
| Help. I am brand new to Excel but need to quickly come up with a formula to do the following: | 18 Jun 2005 13:14 GMT | 11 |
Help. I am brand new to Excel, but I need to quickly come up with a formula to do the following. In any programming language it would be a simple do while loop, or equivalent, but I can not find out how to do it in Excel:
|
| Change 2 names in one cell to one name in 2 cells | 18 Jun 2005 11:34 GMT | 2 |
Is there a way that if there are two names in one cell (a1), i.e.; Johnson--Jackson, that they can be changed to be listed in two different cells, such as, Johnson in cell b1 and Jackson in cell b2. I have a very long list of names and I do not want to go through the list
|
| emailing from excel not an option | 18 Jun 2005 07:10 GMT | 1 |
I am trying to email an excel file but when I click on File - Send To - Email is not an option (greyed out)
|
| Excel Formula/Worksheet maybe Macro Question | 18 Jun 2005 05:18 GMT | 3 |
OK. Heres what I want to do. I have my cell phone bill in Excel format and I want to write a macro or get a formula together to go through and sum up all the minutes by phone number. So basically I have
|
| How to save excel data into text file with space delimited | 18 Jun 2005 05:12 GMT | 3 |
Hi, I am a newbee of excel. I do have a question about how to save dat in excel file into text file with space delimited( the default one i tab)? And I also want to know how to just select some column to export the default one is export all the column).... Thanks in advanc
|