General

password protect worksheet
I am trying to create a profitability workbook where sheets 1-2 I want to have my secretary fill out most of the basic data, but I don't want her to see the profit (on worksheet 3) I make on the total project. Is there someway to restrict viewing with a password on a specific sheet within a workbook? ---------... 14 Feb 2006 09:42

File Converters
Has anyone run across file converters for Lotus 123 Rekease 9 Workbooks? These files have an extension of .123. ... 14 Feb 2006 12:19

Trend line in Excel
Hi all, I'm messing around with the trend line function in excel. I see there are 6 different types of trend/regression types: - Linear - Logarithmic - Polynomial - Power - Exponential - Moving Average I have a list with 30 data points that I would like to plot on chart with the different trend/regr... 13 Feb 2006 11:15

vlookup and sum
Hi there, Is there a way to sum data with a vlookup, as follows: Style Jan Feb Mar Apr ... 002 100 100 100 100 ... 003 150 150 150 150 ... In another sheet, I want to sum year-to-date info by style. sum of vlookup(A2,A2:I3,1,0) to vlookup(A2,A2:I3,3,0) Tha... 13 Feb 2006 09:41

picture display on excel worksheet
I wish to make a product list on my worksheet. I have the following questions: 1). Could I hide a row, and the pictures attached on this row is hided together. When I unhide the mentioned row, the pictures that is hidden with the row could open with others cells in the row. 2). When I tried to filter my pr... 12 Feb 2006 23:15

line break / hard return?
How do I make a line break / hard return in a cell that contains only text? For example, in MS Frontpage you hold down the ctl key and hit return. ... 13 Feb 2006 02:19

where can I download the MegaStat add-in for Excell
I'm attending a class on Business statistics and found reference to MegaStat add-in in the very first chapter of my statistical techniques in Business Economics, peeked my interest in downloading or as referred to, add-in to my current 2003 Office Excell program ... 12 Feb 2006 11:52

What does the symbol ^ mean in Excel formulas?
I am having trouble finding out the purpose of the symbol ^ when using calculations in Excel. Can anyone help me? ... 11 Feb 2006 14:36

group excel sheets within workbook
Hi, I was wondering whether it is possible to group excel worksheets under an individual tab within the one workbook. A example of what I would like to do is to have a set of tabs across the bottom of the workbook to the right (as the sheet tabs appear to the left) labelled with each month of the year. When I s... 13 Feb 2006 08:08

pari-mutual wagering spreadsheet
I have a excel program which was given to me several years ago, it?s a pari-mutual wagering spreadsheet. The program contains stats on many horses, on which you would handicap and then wager on. The program then calculates the current odds, track take, payouts, etc. I would like to strip the formulas out of the gam... 10 Feb 2006 07:56