| Thread | Last Post | Replies |
|
| Excel Locking Machine | 27 Sep 2007 21:55 GMT | 2 |
I have a 2.8ghz P4 with 1.75GB memory & 15gb free hard drive space, running Windows 2000 & Office 2000. I have opened a new Excel document, and an existing Excel file (13mb, containing 13 columns and 48,606 rows of simple text data).
|
| How do I make Excel display a specific worksheet? | 27 Sep 2007 21:40 GMT | 3 |
I have a workbook with a few worksheets, one sheet per person in my group. Can I set up Excel so that when an individual opens the workbook, they can see only their own specific worksheet without seeing the others? Or is there a way that I can create a query that asks the user ...
|
| Shortcut key - merge cells | 27 Sep 2007 21:17 GMT | 2 |
Is there a shortcut key to merge cells in excel.
|
| Lookup percentages | 27 Sep 2007 21:15 GMT | 12 |
I am fairly familiar with VLOOKUP and HLOOKUP, and pivot tables, but have a problem that perhaps somebody can help with. I have a pivot table built with three columns as in the following partial example (whole table is much longer but this should show the issue):
|
| problem in VB codes-2 | 27 Sep 2007 21:07 GMT | 3 |
can anybody explain how I can use the loop below for "find" property in the following code.I don't know why it can not jump to next I when "find" property can not find the "/164" in the cells!!!????I know there are far easier codes to do the substitution but I have to use the ...
|
| Generate random numbers | 27 Sep 2007 21:01 GMT | 3 |
I want to generate 45 random numbers between the numbers 1 and 300. I have tried using RAND, RND, and a couple others. I can get it to generate one random number, but I want to generate more than one random number (45). Please help.
|
| Character count | 27 Sep 2007 19:57 GMT | 9 |
Is there a formula that returns a count of a specified character? For example: Cell(A1) = I:\1stFolder\2ndFolder\3thFolder\4thFolder\5thFolder\abc.xls Answer would be 6 for "\"
|
| Help with copy/paste | 27 Sep 2007 19:45 GMT | 4 |
Morning. I want to paste multiple lines of text (recipe ingredients list) in just one cell. I'm using Excel 2003 and what's doing is pasting in multiple rows. Any help will be appreciated!
|
| Excel Dropdowns | 27 Sep 2007 19:17 GMT | 2 |
how do i setup a dropdown for every column in a certain row?
|
| How do I change my negative values to zeros in Excel? | 27 Sep 2007 19:09 GMT | 2 |
I need to convert data from mg/L to mg/kg, but before I can do that I need to get rid of my negative values. How do I change, for example, -0.005 to zero without manually doing so (I have hundreds of negative values and do not have the time or patience to do so)?
|
| Formula to populate a drop down list based on the selection of ano | 27 Sep 2007 18:54 GMT | 1 |
I am trying to create a worksheet to organize manufacturer and product information. I have created a drop down list based on the manufacturers name from lets say sheet 1 and I have the manufacturers products on lets say sheet 2, what I would like to be able to do on a whole ...
|
| Please help me... Set precision as displayed issue | 27 Sep 2007 18:48 GMT | 1 |
I almost always use "Set precision as displayed" option for all my calculations. It gets pretty annoying for me to always have to click on that checkbox every time I start a new document. Is there any way to Set precision as displayed permanently? (When I start a new document for ...
|
| Convert Excel 2007 format (*.xlsx) into Excel 2003 format | 27 Sep 2007 18:46 GMT | 2 |
I received an Excel file created in 2007 format (*xlsx) and I am unable to read the file, even after downloading the conversion patch (http://office.microsoft.com/en-us/products/HA101686761033.aspx) The file came to me with a *.xlsx.zip double extension. After extracting the .zip ...
|
| Mouse Hover display | 27 Sep 2007 18:45 GMT | 16 |
Not sure if this is the right area or not...and if it isn't, I do apologize. I'm looking for a way that I can add a comment to a file in general...not just a cell. Specifically what I'm looking for is the ability to read a comment about a file before I click on it. In other words ...
|
| Publisher printing | 27 Sep 2007 18:38 GMT | 2 |
I am creating an invitation on 5.5 x 8.5 cardstock... I have been able to line everything up properly, but cannot get the document printed with the set up guides (located in the four corners of the document) to NOT print...help, please! :)
|