General
in [Excel]
|
alphabetize worksheet names Is there a way to alphabetize worksheet names in a workbook without having to manually move each one? ... 13 May 2010 17:10
Centralized data I have a main costing work sheet that needs to be populated by individual costing sheets that went out to all of the buyers to populate. Main Costing Sheet A. Item # B.Desc C. QTY D. Cost E.....F.........G......H (all contain irrelevant information to costing activity. There are 5 buyers (Ni... 17 May 2010 18:01
Summing 2 columns cells into a 3rd colums cells In Excel 2007, I need the to add data from column L's cells 2-93 with the data from column M's cells 2-93 and have it total in Column N's cells 2-93. I'm hoping that there is an easier way than auto summing each pair of cells. This example is the smallest range that I have to due this with and auto summing is... 13 May 2010 16:03
Custom Function I can use in a formula? Hi Guys I got one for you. I have a sheet that I record football match results in, by entering a score in one cell like this: 1-1 or 2-1 or 2-2 I have a number of friends who attempt to predict the outcome of the games, and they score points depending on how accurate their prediction is. Points are scored... 13 May 2010 16:03
how do I tabulate data in excel 2003 I need to tabulate some data from 500 surveys with 30 questions. How do I do that? ... 13 May 2010 19:24
Can you freeze in two directions in excel Can you freeze in two direction in excel, along rows and colums? ... 13 May 2010 14:56
Dynamically reference a cell based on cell content Hi All, I do not know how below copy-paste will show on the post, but I will try to depict the question in self-explanatory way, so you will gatch what's my problem: I have an Average function to calculate the average for the last 12 months just before Total Colum - (I have several prior periods, but I want... 13 May 2010 14:56
Locking content, formula, and format in a cell Is there anyway to lock the content, format, and formula -separately or jointly- of a given cell? If so, how ... 13 May 2010 13:50
Need to print the second sheet only if it is active I have a two page excel worksheet, I always want the first page to print, but if there is a lot of information and the second sheet becomes active, I want that to print as well. But only if it is active. ... 13 May 2010 13:50
HELP! Split cell contents to new rows I know how to split cell contents to columns, but how do you tell excel to take the cell contents and insert into new rows. Each name is separated by a comma and I need each name to appear in its own row beneath that cell. PLEASE HELP! ... 13 May 2010 13:50 |