| Thread | Last Post | Replies |
|
| HOW DO YOU | 23 May 2008 19:56 GMT | 3 |
can you make the cursor move to the next cell automaticlly after information is entered and can you make it skip cells that fill with results of formulas
|
| Cursor group hang | 23 May 2008 19:47 GMT | 1 |
I have a problem which seems to be specific to certain areas of spreadsheets where the cursor will highlight a group of cells instead of just one when I click on a single cell. I don't know how I made it happen nor how I can get it to stop.
|
| Use and navigate through option button on w/sheet | 23 May 2008 19:41 GMT | 4 |
I would like to make a index w/sheet with option buttons to navigateto other w/sheets , to open user forms and to run macros.for example; option button1.--goto w/sheet 10 option button2.--goto w/sheet 6
|
| Calculating time in minutes | 23 May 2008 19:17 GMT | 10 |
I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does ...
|
| Conditional Formatting Row & Text | 23 May 2008 19:13 GMT | 1 |
I have a spreasheet with 12 coloums. The last coloum has a value of either "yes", "no", or null. I need to conditionally format the spreadsheet so if the value is either "no" or null the entire row is in red with a bold type face. If the value is "yes" then the row is black and ...
|
| Sum Total with minus in different cell | 23 May 2008 19:09 GMT | 1 |
New to excel 07. I need a formula that will look at the following: COL F Row 2, is a zero and the amount is in col G Row 2 the worksheet has row 2-32 and I'm trying to put this formula in row 33 and I want the sum of the values that are in Col G rows 2:32 minus any values that ...
|
| Rank If? | 23 May 2008 18:56 GMT | 3 |
Here is my data ColA-ColB-ColC ABC-1- ABC-4-
|
| Drop down lists | 23 May 2008 18:41 GMT | 1 |
im updating my database and there are several columns that have drop down boxes and i use the auto filter a lot to sort the data so when its all sorted it throws the sources/info in the drop down boxes out, so nothin appears how do you have all the information on another sheet so ...
|
| Pivot table group help | 23 May 2008 18:33 GMT | 2 |
I am at a loss on this... I created a pivot table that has the following data items: ItemNumber, ItemName, QtySold, QtyOnHand, ListPrice, Location, PurchaseOrderNum, QtyOnOrder
|
| Colours in Excel 2007 | 23 May 2008 18:00 GMT | 4 |
I would have to say that the default color scheme in Excel 2007 is really hideous. Is there some way of making the default colours the same as they were in Excel 2003.
|
| duplicate | 23 May 2008 17:56 GMT | 1 |
how do I go about finding if there are many words that come back up more than once in the text? without using the find option. Let's say that I do not know which word might come up more than once, and I want to discover which ones do, how do I do that?
|
| Insert row/column error "Cannot shift object off sheet" | 23 May 2008 17:51 GMT | 2 |
When I try and insert either a row or column into a my spread sheet the above error message appears. I have tried pressing CTRL down arrow and CTRL right arrow to see where excel 'thinks' I have my last data as per recommendations on other queries and it skips to the very end so ...
|
| VBA code to fill down | 23 May 2008 17:48 GMT | 6 |
I have some VBA code that imports certain columns (a thru g) from another spreadsheet. I also have two columns of formulas in the spreadsheet that I'm importing into that I need to fill down after the import is done. Columns H & I have these formulas. How would I add to my VBA ...
|
| how ?? | 23 May 2008 17:35 GMT | 11 |
HELLO GUYS....HELP given: A B 1 axe red 10
|
| How can I disable all hyperlinks in a spreadsheet? | 23 May 2008 17:21 GMT | 2 |
I copy data from other spreadsheets. If it look slike an address Excel makes it a hyper link. I have to remove them one by one - then they come back when I copy data from that cell. How can I stop this for good without downgrading to an older version?
|