| Thread | Last Post | Replies |
|
| Autosave default settings | 31 Dec 2007 23:21 GMT | 1 |
Can anybody help please. I'm trying to permanently alter the Autosave default setting on an Excel 2000 spreasheet. I can easily go into the Autosave function when I open the spreadsheet each time and change from the default setting of 10 minutes to 1 minute, however when I close ...
|
| How do I fill a formula on another sheet that repeat every 50 cell | 31 Dec 2007 23:14 GMT | 2 |
I am trying to set up a report to help me out. My problem is that i have to input 300-500 sheets of information in so i am using formulas to help me capture that date that i need and i am sending it to another sheet. On the Other sheet I have formulas set up to capture everything ...
|
| How do I change the size of a worksheet? | 31 Dec 2007 22:54 GMT | 3 |
I want to set the size of a worksheet to 20 rows and 10 columns. How do I do this? Every time the sheet is opened, only these cells should be displayed. I hope there is an option to set different sizes for different worksheets within the same workbook.
|
| in which folder can you save a .CSV file? | 31 Dec 2007 22:44 GMT | 17 |
I am trying to save my e-mail addressbook as a .CSV file. When the save menu opens, it lists a folder under the local disk (C:). But then when I try to locate the file in order to import the addressbook, I can find no such folder anywhere. I have tried using other folders ...
|
| how do i export excel calendar info to outlook calendar? | 31 Dec 2007 22:27 GMT | 1 |
i am trying to export calendar data from an excel file to my outlook calendar. Can this be done?
|
| linking cells again :-( | 31 Dec 2007 21:46 GMT | 7 |
Suleman, thanks for trying but stil no go... maybe what you responded will work and I just misunderstand what to do. I have a database in one worksheet that controls customer info, inventory and tracks sales by an invoice number. I am trying to create an invoice that
|
| Pass word protecting multipul worksheets within a workbook | 31 Dec 2007 21:23 GMT | 1 |
is there a way to pass word protect multiful worksheets within a workbook at the same time. i have several workbooks that have 5-35 worksheets that all need pass word protected and would like to do it all at the same time.
|
| data | 31 Dec 2007 20:50 GMT | 1 |
CAN I IMPORT AN EXCELL SPREADSHEET TO QUICKEN ?
|
| multiplying rows and passing formula throughout the col range | 31 Dec 2007 20:31 GMT | 3 |
Is this confusing? My formula: sum(C6*D6) to multiply price (C) vs usage (D). I need to continue multiplying like this to get a final total to get the amount spent for last year. my example:
|
| Change 3 letter text string to a number string | 31 Dec 2007 19:47 GMT | 3 |
I have a spreadsheet with a string of 3 letters (ATL) per cell, which represent an airport. There are 24 different 3 letter combinations. I want to change the 3 letter combination to a corresponding 3 number combination. Example:
|
| Excel 2003 - VBA - Formula disassembly | 31 Dec 2007 19:47 GMT | 2 |
I have an interesting problem. I have two tables exemplified by the simply example below. The first is a listing of all accounts while the second is the summation of those account into family groupings.
|
| How Can I Assign an Specific Code to every Product | 31 Dec 2007 19:21 GMT | 5 |
I have an Online Store and the problem i have is that i don't have SKU for the products i have making it extremly hard to keep track of every product. So i need to assign an specific code to each product and be able to type the name of a product and get the code automaticly on ...
|
| Formula for Budget | 31 Dec 2007 19:19 GMT | 5 |
I need a formula for a budget I am drafting with estimated and actual costs. Column B is estimated costs, Column C is actual costs. I can SUM the numbers in Column B for the estimated total cost but for the actual total cost I need to SUM the numbers in Column B unless there is a ...
|
| Spell check flagging words I can't find in Excel | 31 Dec 2007 18:09 GMT | 3 |
I am having a problem with a particular .xls file in the 2007 version of Excel. When you spell-check this particular document, it finds "mystery words" - they show up in spell-check but when you attempt to find them using the "find" feature, you are told that Excel can't find ...
|
| Use different cell content as headers | 31 Dec 2007 17:50 GMT | 3 |
Would anyone knows how a marco to insert different cell content as header onto different worksheets within a workbook? For Example Sheet 1 : use Cell A1 as header
|