| Thread | Last Post | Replies |
|
| Delete rows with no data | 30 Nov 2005 21:24 GMT | 1 |
I have an excel spreadsheet that I would like it to automatically look at columns of data and if there is no data or formulas for that column of data to go ahead and delete the column or if I have it in a row to delete the row. Is there an easy way to do this?
|
| How do I use info from an excel program and make file labels? | 30 Nov 2005 15:46 GMT | 1 |
I want to use a column of information from an excel file and make file labels with that information. How do I do this?
|
| freezing a row | 30 Nov 2005 14:35 GMT | 2 |
I am working on what will end up being a very long excel sheet. I have all of my headings in the first row. I know that there is a way to keep this first row visible as the user scrolls down through the other rows, but I'm not sure how to do that. Can anyone help me out with ...
|
| How do I set up a weekly schedule for my managers (vacation etc.) | 30 Nov 2005 03:16 GMT | 1 |
How do I set up a weekly schedule for several managers that will contain their vacation days, travel days, etc.?
|
| Custom header | 29 Nov 2005 17:58 GMT | 1 |
How do I apply a custom header or footer to multiple worksheets in an Excel workbook? I'm in XP if that matters.
|
| calculation | 29 Nov 2005 13:42 GMT | 1 |
Can somebody help with the automatic calculation? At tools --> options --> calculation I can let exel calculate automatically. After a while it stops calculating automatically. Does anyone can tell me where I can adjust this automatically calculation so that it will remain so
|
| copy workbook sheets? | 29 Nov 2005 03:30 GMT | 3 |
Have 13 sheets in workbook, ME2005, 1x each month and 1x summary sheet. Each month has 68 rows for each customer and columns for deposits, date and amount and adding that to a summary page with checks and balances formulas. Starting new year in '06 and would like to transfer ...
|
| create raffle tickets in Excel | 28 Nov 2005 22:53 GMT | 1 |
I would like to create raffle tickets in Excel. How can I do this? I know it is possible but I haven't a clue on where to begin.
|
| How much is excel? | 28 Nov 2005 22:47 GMT | 1 |
How much is it to buy excel??
|
| change colors | 28 Nov 2005 21:07 GMT | 2 |
Have the following formula and if a "p" is inserted, I want the color of the cell to be green(ok), if "x" red(problem). =IF(C66="","",IF(C66=$B66,"p","x")) I saw this somewhere but can't find.
|
| Position Picture with macro | 28 Nov 2005 19:25 GMT | 1 |
How do I position the picture after inserting the image through macro? wks.Pictures.Insert ("T:\BrokerInformation\Grayson Fitch\Burn\logo_cne.gif") Thanks!
|
| Won't apply to all worksheets | 28 Nov 2005 17:56 GMT | 1 |
This macro will only work on the selected worksheet. It will not automatically apply to all worksheets in the workbook. How do I make this macro work on all worksheets? Thanks! Sub C_Page_Layout()
|
| Not apply macro to every worksheet in activeworkbook | 28 Nov 2005 17:36 GMT | 2 |
Below this message are the codes that I created to apply a header in excel spreadsheet (not the header in page setup). Unfortunately, the macro applies the header multiple time in the one activesheet, instead of applying one per each worksheet. Am I doing anything wrong?
|
| Formatting | 27 Nov 2005 02:42 GMT | 4 |
Is it possible to set up Excel so each time any new file is open the footer information can be the same for each new spreadsheet? I would like to see the same footer in each new file without having to manually insert the footers Also, if I want the default column width to be ...
|
| Strange behavior | 26 Nov 2005 17:41 GMT | 4 |
I have installed office 2003 8 months ago. Suddenly 2 months ago, Excel refused to open. In fact, it opens, loads the add-ins, and stay on a grey page (no work sheet open), no menu is active. When I close it (red button up right) a worksheet opens for a second and
|