| Thread | Last Post | Replies |
|
| Hiding information | 01 Jul 2009 00:23 GMT | 4 |
I've searched through and seems no one else is having my problem. At the bottom of my sheet I have a list of names that goes into a drop down list. I go into format cells --> custom and put in ;;; and it hides the names but when I click the drop down box where they go the names ...
|
| Finding combinations of cells that sum to near a value | 30 Jun 2009 21:57 GMT | 1 |
Starting with a column of ~30 numbers, I'm looking for a way to have Excel find all combinations that sum to a target value +/- a specified range width. (For example, I may be looking for all combinations that sum to 1000 +/- 10.)
|
| IN DESPERATE NEED OF HELP WITH GRAPHS | 30 Jun 2009 21:24 GMT | 2 |
For the life of me, I can not seem to be able to change the names of the X & Y Values once the data has been graphed. I want it to be in specific words or number for the Y axis but it only puts it in numbers based on the number of total rows. I can change it a little
|
| Inserting cells | 30 Jun 2009 21:00 GMT | 1 |
I have spent 3 days writing sql queries to perform a security audit accross the domain. The data is captured and I have created a templte in excell where I copy the records and paste them into excell for management. I was under the impression that the records could be inserted ...
|
| Managing File Size in Excel 2007 | 30 Jun 2009 19:09 GMT | 2 |
I recently moved to Excel 2007 from 2003. I created a data entry workbook for a survey I'm doing for a client. The workbook contains 6 protected sheets -- a sheet for respondent information and sheets to enter data for 5 plant sites -- and 4 hidden sheets that I use to capture ...
|
| Tables in 2007 | 30 Jun 2009 17:54 GMT | 5 |
What are the advantages to converting a list to a table in 2007? Why does the table have a name? I did read in help that you can post a 2007 table to sharpoint services. What does that mean?
|
| Convert Text To Number | 30 Jun 2009 16:48 GMT | 3 |
I run Excel 2K ans Windows XP I have downloaded some numbers from a mainframe and they have come up as a text format in the worksheet. I tried reformating them to a number but it does not work. I also tried entering the number 1 in a cell and copying it
|
| Populate Adjacent Cells based on Pull Down Selection | 30 Jun 2009 13:27 GMT | 1 |
I have a spread sheet where col A is a "Level Of Training" named range ("LOT") pull down selection built in the Validation List box. Dependent upon LOT selected for that row, I need the col B (labeled T1), col C (labeled T2), etc through col G (labeled T6) to be populated with a ...
|
| Undo delete of embedded object | 30 Jun 2009 11:06 GMT | 1 |
I've embedded a word document into Excel 2007. Double click will allow me to edit the text within - that's all working fine. I accidentally deleted the object, and clicking undo has restored a picture of the object (with all the text I typed) rather than the
|
| A button on the page | 30 Jun 2009 06:49 GMT | 2 |
How do I make a button on my page that if I click it will put today's date in the cell I want? I am using excel 2007. ----------------------------------------------------------------------------- Less Spam Better enjoyable experience
|
| EXCEL 2007 CREATING A MACROS | 30 Jun 2009 00:31 GMT | 2 |
CAN'T FIND THE MACRO SELECTION ON THE EXCEL 2007 TOOL MENU ----------------------------------------------------------------------------- Less Spam Better enjoyable experience Visit : news://spacesst.com
|
| Gridlines not pinting(everything chkd & unchkd) | 29 Jun 2009 23:52 GMT | 1 |
Im in excel 2003 and I have unchecked draft quality and checked print gridlines but still will NOT print.. ONLY lines that print are the ones containing text,, HELP
|
| Keep cursor at same point in cell when switching between workbooks | 29 Jun 2009 23:48 GMT | 2 |
I'm using Excel 2007, and am entering text data (address details) in cells. The info I need to enter is on another workbook, so I am using ALT-TAB to move betwen the two. Yesterday when I was doing this, each time I switched back to the workbook I'm entering, the cursor was in ...
|
| Finally, an easy way to get rid of excessive default Excel 2007 styles | 29 Jun 2009 23:40 GMT | 1 |
http://support.microsoft.com/kb/291321 Delete from "Select Case CurStyle.Name" to the "do nothing" line. It deletes all existing styles and resets them to the default Book.xlt. Not glamorous, but it works.
|
| stock control question | 29 Jun 2009 23:23 GMT | 4 |
Hello all, I have 2000 items and want to represent them as full cartons - inner cartons and single items. Full cartons have 36 pieces inner cartons have 6 pieces and singles are self explanatory. I tried using the INT formula but I can't seem to get it to work. Is there
|