| Thread | Last Post | Replies |
|
| Noob needs Excel 2007 help | 09 Feb 2007 00:43 GMT | 4 |
Hi - I just got MS Office 2007 Professional which, of course, includes Excel 12. I need to keep track of vehicle mileage, reimbursement amounts, and create an offset of those reimbursement amounts against the IRS standard mileage deduction, so that at the end of the year I only ...
|
| Add-ins in Excel 2007 | 08 Feb 2007 23:50 GMT | 1 |
I have a series of add-ins that apparently load on Excel 2007 but do not appear in the Ribbon. Example: all my COM add-ins. (eg asap utilities etc.) What's up?
|
| Change the Shape of a Comment in Excel 2007 | 08 Feb 2007 23:42 GMT | 3 |
I'm using Excel 2007 and can't figure out how to change the shape of a comment. In 2003 you would select the comment and then from the Drawing toolbar select Draw, Change Autoshape. From what I could gather from Help I should select the comment and make a selection from the
|
| Subtotalling | 08 Feb 2007 22:45 GMT | 2 |
I am not a new user, but I have a question that might be basic about formulas. This is the formula that appears when I select Data, Subtotals for my worksheet. =SUBTOTAL(9,E2:E1201)
|
| Excel/VBA Automatic Numbering | 08 Feb 2007 22:41 GMT | 1 |
I am trying to use a macro to get my excel worksheet to number automatically (the rows)....however when i insert a row, the number tracking is off and there is no automatic numbering... This is the code I am using:
|
| How to insert a list in the ActiveX combo box | 08 Feb 2007 22:28 GMT | 1 |
I have inserted ActiveX combo boxes into a form, but cannot figure out how to insert the list of choices that will appear when I click the drop down. I am using Excel 2000. Does anyone know how to do this? I can create form's drop down lists and another form of drop down off the ...
|
| Export highlighted data | 08 Feb 2007 22:26 GMT | 3 |
Is there a way to export a highlighted section of a worksheet to a text file? Or is there a way to only export parts of a spreadsheet that have data in them? For example, I have a spreadsheet with many hidden formulas from rows
|
| concatenating two fields in one cell, of which one is a date. | 08 Feb 2007 22:15 GMT | 3 |
I have two cells: Cell A2 Today's date is Cell A3 02/08/2007 I want cell A4 to state: Today's date is 02/08/2007
|
| References to outside sheets | 08 Feb 2007 22:15 GMT | 3 |
Hello there ! and thanks to everybody providing help! I have spreadsheets in folders call November06, December06, January07... Files names structure is always the same 1-11-06, 2-11-06 ... 12-11-06
|
| Static reference to worksheet in formula | 08 Feb 2007 22:08 GMT | 3 |
I have several Documents. For example one is called Budget 2007, Budget 2008. In each of these I have worksheets for each month, Jan, Feb, etc... I also have a worksheet called Year. In the Year I have cells that reference the month worksheets. For example I might have =Jan!$B23
|
| date | 08 Feb 2007 21:46 GMT | 2 |
when i open excel and type in other date/s (not Current date) why does it go to current date and how can i stop this from happening. all i want to do is input numbers for example: 03/06;04/05 but when i do this it goes to current date.
|
| Expand to fit. | 08 Feb 2007 21:15 GMT | 3 |
I have seen the formatting property 'shrink to fit'. Is there a way to make the cell expand to fit? For example I have a cell that concatenates multiple cells in my questionnaire. Many times the amount of words in the cell is too long for the length of the cell. I am using word ...
|
| Excel Charts - showing parts of a sequence | 08 Feb 2007 20:59 GMT | 2 |
I am trying to create an Excel line chart with the X-axis being dates. Excel insists on showing every day in the sequence along the axis, and I want to show only the dates for which I have data. This chart covers one year and I don't want 365 date points on the X-axis, only the ...
|
| how to auto arrange in alphabetical order-excel sheet | 08 Feb 2007 20:47 GMT | 2 |
how to auto arrange in alphabetical order-excel sheet after typing names in random?
|
| counting | 08 Feb 2007 20:38 GMT | 1 |
when i put in figures into cells and want to count how many there are how do i do this. for example: 1;2;3;4;5;6;7 would be there are 7 at the end of the cell. thanks.
|