| Thread | Last Post | Replies |
|
| Please help! | 05 Oct 2006 13:25 GMT | 2 |
I've been using Microsoft Excel web query functionality accessed through the menu path: Data>Import External Data>Import data then selecting
|
| Excel Macro for Coloring the cells | 05 Oct 2006 10:18 GMT | 3 |
I have a worksheet in which I have the data arranged ap per the temperature. There are 3 temperatures and for each temperature I have to put in a color for all the cells.
|
| formating incrementing numbers | 05 Oct 2006 09:59 GMT | 3 |
It almost seems silly asking this question, but I can't figure out how to do this. I need to come up with a grid 4 cells X 100 cells each cell containing numbers in the following format.
|
| Search through Data | 05 Oct 2006 07:39 GMT | 1 |
I have created a drop down list for my data. Is there a way i can make it so i can search through the data in the drop down list without scrolling
|
| how can I count hours more than 24? | 05 Oct 2006 06:41 GMT | 2 |
I'm trying to sum time fields up so I could get the total time I've been working. The thing is that everytime the sum hits 24 hours it just goes to 0 again. This way I only get X*24 + showing hours and I have no idea what is total summ.
|
| Excel example-formula C4+C5 adds before data in C5 Can I get it t. | 05 Oct 2006 04:01 GMT | 2 |
I'm trying to create a formula (for example): In cell D5 I want it to add C4+C5. I would like it to work only after there is data in C5, but not before. How can I get it to work only when there is data in C4 & C5? Right now its showing what I have in C4.
|
| Delete gridlines and shading below | 05 Oct 2006 01:53 GMT | 5 |
Someone sent me an excel sheet and they selected the whole sheet and put borders on all cells. They also shaded columns all the way down. I have 72 pages but only want one. I need to keep the borders and shading on cells A1-AG40. I tried to delete the rows by selecting for 41 ...
|
| Default Excel as Read Only File | 05 Oct 2006 01:34 GMT | 2 |
How could I default excel workbook as READ ONLY? Give me your hand. Thanks, George
|
| How do I turn off the spell checker when using Excel? | 05 Oct 2006 00:03 GMT | 1 |
I'm using a large database of names addresses and dates and other misc. items in Excel and the spell checker won't leave me alone. I don't wish to correct any of my data but spell checker insists on telling me every line has an error.
|
| conditional formatting - color | 04 Oct 2006 23:24 GMT | 3 |
I'm trying to use conditional formatting to accomplish the following: if the cell is empty or contains a greater than zero value, the cell color is white (or no color), if there is a 0 in the cell, the cell color is red.
|
| I don't remember giving a password for excel 2003. | 04 Oct 2006 23:20 GMT | 6 |
I enabled the microsoft office trial version on my computer. What did it use as my password?
|
| Excel Macro to delete rows | 04 Oct 2006 22:41 GMT | 2 |
I have an excel Sheet in which I have a blank row below the cell which contains "<<<Mem>>>". I vave some random data and multiple such cells. Can I get some help with the excel macros for the same?
|
| not the usual "A document with name _____.xls" problem | 04 Oct 2006 22:02 GMT | 5 |
I have a Word document that has links to an Excel spreadsheet. When I open the Word document and tell it to update the links, I get the "A document with the name _____.xls is already open" error message. It only happens with this one Excel workbook, and only when I open the
|
| organizing data on the fly to access certain infomation | 04 Oct 2006 21:39 GMT | 2 |
I have different fields in my columns i.e. name, date, time. I need to find like names and place them together, or, like dates and place them together while keeping my rows intact. I need to be able to organize this information when ever I want and however I choose according to ...
|
| copying worksheets | 04 Oct 2006 20:41 GMT | 2 |
Is it possible to copy a workbook & formulas to another workbook without re-entering each formula to reflect a new year? I created a budget worksheet that's linked to another worksheet that needs to be updated every year. I'm able to copy the workbook but I have to put the new ...
|