Summary: I have received a file from office 2003. file has a unique function when i click on the button (which in a single column of excel 2003) it display the...
Summary: Hi, I have this data in Excel sheet Name John Phone 123 E-mail john@hotmail.com Name Jason Phone 234 E-mail jason@hotmail.com How can I rearrange it t...
Summary: Note: the above works good if only used in one of the sheets in file. Otherwise it changes the sheet names. An alternative is to use ASAP Utilites un...
Summary: sir, I have 2 excell sheets of employees. In one sheet name, staff no , address is present. In another sheet name, staff no and contact nu is pre...
Summary: I need to Sort an entire row by date automatically (close of escrow). I would like to be able to hit a button and the sheet sorts all the rows by date...
Summary: Perhaps it is different for Excel 2002 but in Excel 97 you are limited to 256 columns and 255 sheets per workbook. So the maximun number of columns in...
Summary: User has an excel spreadsheet created in Excel 2000. The spreadsheet is fairly simple, a listing of meetings with several filters inserted. The user t...
Summary: In Excel, each sheet has the 65536 lines limitation. Is there any simple way to remove or expand this limitation, or I have to split one file with ove...
Summary: Within a specific Excel 2002 Spreadsheet that I have, I am unable to change the color/fill of specific cells. I can change the color/fill of cells in...
Summary: I am preparing a costing sheet in excel 2000 where I must show an amount both in number and word i.e. 2,500/- (two thousand and five hundred and 00 on...
Summary: You use linking for the Word piece (look it up in the help files, theres oodles of useful stuff there. Essentially, the easiest way is to copy your so...
Summary: I need to know how to write a script in Excel that will check for the existence of a worksheet, a true or false response is ideal... thanks in advance...
Summary: Hello, I have to send a feed back email to a list of customers. I have all their data on a Excel sheet. What I would like to do is this: I want to k...
Summary: This is correct, but make sure that the people who are going to be accessing these documents have the necessary permissions. We frequently have peopl...
Summary: Dear Friends I have excel sheet made of many rows and column, out of that one 03 column in a row need to input the number and all others are formulas....
Summary: I have dat in ONE EXCEL SHEET. for data in cell AA1:AA12 I have created a combo box. Data1 1) English Songs 2) Hindi Songs 3) Poems Data2 there are th...
Summary: ASAP Utilites has that as one of the over 300 functions not found in Excel. It is free and pretty good to have around. Sorting sheets is found under S...
Summary: If I read this correctly, what you are wanting to do is create a field called Names and another called Ages, which you can then use in a MailMerge, in...
Summary: I m facing a problem and I am bounded to work in excel: Hope u all will help me after reading the following situation. Let me discuss it in detail: I ...
Summary: It's in standard menu usually..! My excel is in french and of course u can add what u want to ur menu by right clic on toolbar and choose "customize" ...
Summary: I'm using Excel 2002 to create graphs from a table. When I sort the data in the table (in ascending or descending order of the total column)the graph...
Summary: My first thought relates to how many profane words there are and how could you possibly check for every one, including variations (e.g. d*mn, sh!t, et...
Summary: If you want to *replace* the numbers, I believe you are going to need a macro because Excel can't overwrite an existing value in a cell. For example.....