Threads Replies Last Post 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   how do i limit my worksheet size to say 11 columns and 11 rows. ... 2 24.08.2006 16:32:07 Adding durations Hi I'm using excel '97. I have a spread sheet with durations on it (vodafone) and want to add them. Is there any way to do this? When I highlight and hit sigma it tries to enter nothing in the top selection instead of the total at the bottom. Cheers BB ... 5 24.08.2006 08:56:15 macros opening in excel mobile does anyone know if possible to open macros in excel mobile?... 2 24.08.2006 04:29:08 cell comments in a vlookup table i have information in a vlookup table that i only want to veiw when required.It cannot be done with cell coments as these do not come over within a lookup table.I thought of another column within the lookup table,but these are always visible, and i am running this program on a P.D.A and space is at a premium.... 1 24.08.2006 04:22:02 2 Questions Hi I run Win 2K with Excel 2K Question 1 I have some VB code in the "Sheet 1" module of my excel file. The code is as follows: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column <> 12 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = UCase(Target.Formula) ErrHandler: Application.EnableEvents =... 17 24.08.2006 01:15:02 ? I am trying to list credit card information in a spreadsheet.....How do I get the month/year to show numerically? Also, I can't figure out how to make zero's stick....please help! :)... 2 23.08.2006 23:34:41 How can I get rid of the template task pane in Excel How can I get rid of the template task pane in Excel.... 2 23.08.2006 19:51:02 How to work with Hyperlinks I have several columns with several dozens of hyperlinked entries in each column. I'd like to unlink them all. I highlighted all entries in a column and removed underlines, changed their color to black, but they still were linked. Sure, I can unlink each one, but it will take several hours to finish my job. Is there a way to unlink all hyperlinks at once, or, at least, in each column sep... 13 23.08.2006 19:48:46 Frequency chart and normal curve 2 questions: 1. I have a series of about 200 numbers that I would like to create a frequency chart/graph for. I am having difficulty in OL2000 creating a frequency graph. 2. I have the mean and standard deviation. I do I create a normal curve with this data? Thank you, Carl... 3 23.08.2006 18:48:02 What Is Ms Excel Used For & How do I use It ? I havent a clue about excel, I need someone to give me a crash course on this please !!!... 4 23.08.2006 17:36:02 plot graph from multiple worksheet as embedded chart object on every worksheet Hi i want to plot the graph for every worksheet (column B and column D). I have more than 50 worksheets in the same workbook. How do i write a macro to ask the excel to plot the graph for every sheet and present the chart object on the same sheet? thank you very much for your help! i have been working on this over 2 days still cannot figure it out... ... 1 23.08.2006 12:50:26 printing to file how can i print a selection to a prn file on excel. Quattro allows me to do this and is it possible on excel. when i did try the file doesn't have the informaion that i want in it.... 3 23.08.2006 09:01:02 Stop Recording ToolBar dissappeared in my Excel WorkSheet? I used Macro function in Excel WorkSheet.But now the Stop Recording/Relative Reference Button ToolBar for Macro does not appear any more?Can someone help me restore this option again? Regards... 4 23.08.2006 05:28:47 Linking daily sheets? ;) I'm keeping track of daily sales at a small store. I would like to open one spreadsheet, enter all the sales for the day, and have a running 'year to date' sales total at the end, so it needs to take the YTD total from yesterdays sheet and add it to todays total. I save each daily sheet under 'save as (whatever todays date is)'. I know how to link two sheets, but how do I tell it to take the ... 2 23.08.2006 05:08:02 How to substruct in a range of cells? I have a table with 3 columns and several hundred rows. In column A entered years (1920, 1910, 1930, etc). In column B entered age of a person (32,76,43, etc). In column C I'd like to enter the year of birth of these persons which, of course, is the result of subtracting the age from the year. Using formula for the first row =A1-B1 gives the correct answer. But I'd like to enter data in ... 7 23.08.2006 03:15:21 How do I keep letters the same and change the # for drag formula I want to have the columns do the following A1 b1 A2 b2 A3 b3 When I drag/drop they go A1 A2 B1 b2 C1 c2 What formula can I use to reorientate my data?... 3 23.08.2006 01:23:02 time sheet I have set up a time sheet for employees to fill out on the computer. I need one column (STRAIGHT TIME) to total up to 8 hours ONLY, and anything beyond that to go in the OVERTIME column. So in other words, if I work 10 hours in a day, I need Excel to automatically record 8 hours in the straight time column, and 2 hours in the overtime column. I can't find what formulas to use to make th... 10 22.08.2006 21:22:02 Excel auto cascade Info Hello I am on a project and I need to find out how I can cascade cell info (both numbers and text) to other sheets in the workbook. There is a main "Product List" with empty Columns to the left of product list info (part #, Description, price). Now when this empty cell gets selected on the left (by inputting in a number, "Quantity of product wanted"), that product info needs to cascade to anothe... 1 22.08.2006 17:50:41 Numbers to Words Is their a a function to convert numbers to english text e.g: $112.23 would become one hundred twelve dollars and twenty three cents (or something imiliar) I found the one for bahtitext but I need english ****************** Crystal reports has ToWords(12345.6749,2) Returns twelve thousand three hundred forty-five and 67/100. ToWords(12345.4999,0) Returns twelve thousa... 3 22.08.2006 17:10:23 How I can make a passward on the folder? I'm new user of Microsoft. plz tip me for getting knowledge.... 3 22.08.2006 16:56:13 Excel Woes Hi folks, I'd appreciate some help with my excel settings. Seems something happened ??hmmm, and now I cannot just double or single click on an excel icon and have itopen the workbook. It opens excel but it is blank with no workbook. I have to manually move to a folder and open from within excell to have a workbook open and see worksheets. HELP please! Thanks, larry... 2 22.08.2006 15:22:56 Pivot Table Help Good Morning I have a pivot table set up and all is ok i have set up a macro to copy the data in the pivot table and to paste it sumwhere else and to sort it all is good, but when i save the spreadsheet and close it down and reopen it and run the macro the pivot table shrinks down to 2 rows and 2 colums how do i get my data back on show Can anyone help Thanks in Advance ... 5 22.08.2006 14:33:44 Send an email to a list of emails in a worksheet Hi !! Anybody can help me??...I need to send an email using Lotus to a list of emails contained in a .xls file with that same file attached. Description: I have a .xls file with a list of e-mails and other data. I have to send this file to the e-mails that are into the file and at the same time attach that file to the e-mail. Thanks -- cexarsiado --------------------------------------... 3 22.08.2006 14:04:35 code is not to work on sheet1 Hello to all. If possible could someone help here. This workbook is a bookin sheet for guests. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) ' VB TO COPY CONTENTS FROM LAST SHEET TO THIS ONE If ActiveCell.Row < 11 Then Exit Sub If ActiveCell.Row > 64 Then Exit Sub If ActiveCell.Column > 1 Then Exit Sub ActiveSheet.Unprotec... 4 22.08.2006 13:22:12 Pivot Table Help Good Morning I have a pivot table set up and all is ok i have set up a macro to copy the data in the pivot table and to paste it sumwhere else and to sort it all is good, but when i save the spreadsheet and close it down and reopen it and run the macro the pivot table shrinks down to 2 rows and 2 colums how do i get my data back on show Can anyone help Thanks in Advance ... 1 22.08.2006 09:33:07 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>