| Thread | Last Post | Replies |
|
| Printing just vertical gridlines | 30 Sep 2004 19:29 GMT | 2 |
Is there any way to print out the data in a worksheet showing vertical gridlines only? Virginia
|
| Trying to make a duplicate roster with a button. | 30 Sep 2004 19:16 GMT | 1 |
Hi everyone, I'm new to this forum and have used excel for basi spreadsheets for awhile now, but I want to start some more advance stuff. Here is what I'm looking to do I have a 4 sheet book with A-H Col bein
|
| help help | 30 Sep 2004 19:11 GMT | 1 |
Need help in formulae.. I have one master sheet , In which one tab is contain name , Id etc,, and reason of leaving organisation and in another tab I have to show no. of person leaving for this reason ..
|
| help with Excel Chart, Series name | 30 Sep 2004 18:14 GMT | 1 |
I am using ORACLE OLE2 package to print a series bar graph in excel. I need to rename "Series Name" that comes out in as a char in excel. By defual the series are names as Series1, Series2, Series3,.....SeriesN. How can I access the handle to "Series Name" which help me change its ...
|
| Variation on dependant Lists problem | 30 Sep 2004 17:55 GMT | 1 |
Is it possible to programme Excel so that if you enter a particula value in A1 it will enter an associated text in A2. For instance, I a trying to create a stock-control sheet. Each piece of stock has a cod and a description. I would like to be able to enter the code in colum
|
| CSV file and number formatting | 30 Sep 2004 16:57 GMT | 1 |
I am trying to create a csv file from an excel worksheet. The proble is when I open the file in excel, I get scientific notation. I als have numbers that are supposed to be text. some of these numbers star with zero, so most of the time it is lost when converting to csv with n
|
| How do I use a macro to Import mutiple .txt files into excel 2000? | 30 Sep 2004 15:33 GMT | 1 |
I've got as far as Importing a single file into a specific location (A:1) But I need to produce a macro that consults multiple .txt files and appends them to individual excel lines. Any help or guidance would be greatly appreciated
|
| How Draw a picture using VBA in Excel? | 30 Sep 2004 15:17 GMT | 4 |
Can anyone suggest a method to draw a picture in EXCEL using the VBA. The picture to be drawn uses some bitmaps and super-imposed by texts from the excel sheet. The text drawn as picture should match with the same format as in excel (like font, bold,etc.,)
|
| How do I display Values in pivot table? | 30 Sep 2004 14:34 GMT | 1 |
When I create a pivot table (Excel 97) rather then count, sum, etc the values, I simply want to display the values. Not just the min, max etc. I want to display them all. They can be in one cell or many. Any suggestions? Thanks - Tim
|
| How do I label or name a column in Excel? | 30 Sep 2004 14:20 GMT | 2 |
please advise me how ot make a label or a name for each column in an Excel spreadsheet?
|
| how do i run an office 2000 excel spreadsheet on works 7? | 30 Sep 2004 14:01 GMT | 1 |
HOW DO i RUN AN OFFICE 2000 EXCEL SPREADSHEET ON MS WORKS 7
|
| i need help making a box plot | 30 Sep 2004 13:38 GMT | 1 |
|
| Number Incrimants..? | 30 Sep 2004 13:08 GMT | 6 |
I have developed a form in excel. One of the cells contains a number field that I would like to automatically increment each time it is printed. i.e...
|
| printing filtered data | 30 Sep 2004 12:52 GMT | 2 |
My worksheet's size varies from 12 to 100 rows. To identify rows with data, I have a hidden column "A" which displays a character if the row has any data entered. I have entered a "fixed" character in cell A100. To print, I used a macro to unhide column "A", activate Autofilter,
|
| detecting change | 30 Sep 2004 12:19 GMT | 1 |
How can I make a cell automatically log when another cell was updated or a value entered ? I can use the NOW() function to log the time when something was first entered, but then whenever another cell is changed, all the previous cells
|