| Thread | Last Post | Replies |
|
| Tables in Excel 2007 (SP-1) - Information Goes Blank | 16 Apr 2008 00:52 GMT | 4 |
I have a set of data that I am trying to turn into a table. In column D I have a date amounts entered. In column G I have amouts entered. The Column Headings in Columns H - O are year amounts, eg. 2007, 2008, etc.
|
| I need help making bingo cards!!! :) | 15 Apr 2008 23:58 GMT | 4 |
I am hostessing a baby shower this weekend, and I want to make "baby bingo" cards for the guests to play. I'm not exactly sure how to set it up.... Please give me some ideas?!?
|
| Removing a digit from a column | 15 Apr 2008 23:51 GMT | 2 |
I have a column of data that I need to remove the last digit in each cell. Is there a formula for doing so, so that I don't have to use find and replace?
|
| Reducing Spreadsheet | 15 Apr 2008 23:48 GMT | 1 |
I have a spreadsheet that has a lot of data. It has dollar amount in the column A and and thier ssn in column B but some rows are duplicates but i want to add the dollar amounts and delete the extra row to shorten the spread sheet. please help
|
| Prevent Inserting rows/columns | 15 Apr 2008 23:38 GMT | 3 |
I was wondering if their is a way to prevent a user from inserting rows or cells on worksheet or to send them a message warning if they try to?
|
| How can buffer the row height of my data. | 15 Apr 2008 23:35 GMT | 1 |
When working with tables in MS Word, you have the option to buffer the cell so that there is a set amount of space above and below the work you enter. The same functionality works with the Spacing option. My question is, is there such an option within Excel?
|
| Move active cell to same location on each worksheet | 15 Apr 2008 23:29 GMT | 3 |
I have files with loads of worksheets (about 100 each). When I enter data, it is different for each sheet but I want to be in the same location on each sheet. I start on my first sheet, locate the place I want to enter data and enter the data into the cell. Now comes the problem ...
|
| Format rows | 15 Apr 2008 23:20 GMT | 8 |
I am workin on a sheet that I would like to do the impossible. I am creating a drop down list of topics. I would like to assign a color to each topic and have excell highlight the row depending on the topic. Is this truely imposible?
|
| CURRENT TIME IN DESTINATION CELL IF SOURCE CELL IS TEXT | 15 Apr 2008 23:19 GMT | 3 |
I want to enter someones name in one cell and have the current time post in another cell.
|
| FOR RON ROSENFELD: PARSING QUESTION | 15 Apr 2008 23:08 GMT | 4 |
Hi Ron, You previously helped me parse some data with the formula (see message at bottom). I would like to modify the formula to parse something a little different.
|
| Putting 0's in Database | 15 Apr 2008 23:05 GMT | 2 |
Is there any way to format a cell so you can zeros in infront of a number? For example, I want it to say 0040166071564 but what comes up is 40166071564. HELP!
|
| vlookup. | 15 Apr 2008 23:02 GMT | 7 |
given the data below : a23 paper 5 b14 lamp 15 a23 paper 2
|
| How copy editable text from Excell to Word and not get a picture? | 15 Apr 2008 22:50 GMT | 3 |
Currently, doing a simple cut and paste from Excell to Word results in a picture. How do can I get editable text?
|
| Show and copy values in formula bar containing a formula | 15 Apr 2008 22:42 GMT | 2 |
If I have a formula in a cell or cells, is there a way I can view and/or copy the values/results from that formula in the formula bar?
|
| If Function Treating Answer as a Text Box and Not a Numeric Box | 15 Apr 2008 22:34 GMT | 3 |
I'm creating a scoring matrix which auto assigns values based on another cell's answer. At the end, i would like to sum all the values. However, this function is not working as the data is being calculated as a text. How would I change the following to get it to kick out ...
|