| Thread | Last Post | Replies |
|
| Workbook display's title bar and right scroll bar outside Excel wi | 18 Jun 2007 02:34 GMT | 1 |
I somehow got a spreadsheet (aka "Workbook", I think) to hide its title bar and vertical scroll bar outside the visible area of the Excel work area. The sheet's title bar is covered by the Excel window's bar that shows the cell location and content. The vertical scroll bar is off ...
|
| spreadsheet to jpeg | 18 Jun 2007 01:24 GMT | 4 |
Can you tell me how to convert a spreadsheet to a jpeg?
|
| Is it possible to save a custom header or footer? | 17 Jun 2007 23:30 GMT | 1 |
I use the same footer constantly and I have to type it every time I use it. I'm sure there must be some way to save it and insert as needed? I have tried copying it to clipboard, but even that does not work. Thx in advance!
|
| using Number from Cell for Celladress | 17 Jun 2007 23:16 GMT | 1 |
For Example in Cell A1 is the Number 1234 and in Cell B1 is the Number 5678. How can I use the Number in the Cells A1 and B1 to Adress other Cells. For example I want to Count the Cells with content from D1234 to D5678,
|
| Create New Workbook from Worksheets in One Workbook | 17 Jun 2007 22:27 GMT | 4 |
I'm trying to create a new workbook using sheets from another workbook, using a macro. I have a workbook with 8 worksheets in. I want there to be a button in this workbook that will:
|
| How do I get the coordinates of the active cell in Excel? | 17 Jun 2007 21:28 GMT | 8 |
I want to find the row and column numbers of the active cell so that I can use them as variables in an Excel worksheet.
|
| comparing two text ranges | 17 Jun 2007 21:12 GMT | 5 |
I'm trying to see which text entries in one array are listed in another array. I have tried the =countif(array2,$d2)=0 method within conditional formatting and it only seems to select some of the fileds some of the time and I cant seem to understand where the problem that keeps ...
|
| Creating notches in box whisker plots in Microsoft Excel | 17 Jun 2007 20:55 GMT | 1 |
Does anyone know how to create the notches in the vertical box whisker charts? An example can be found in figure 10 of the following article: http://www.qualitydigest.com/oct97/html/excel.html
|
| Finding Graph Values | 17 Jun 2007 20:53 GMT | 2 |
I have the following data and have created a quadratic graph in some graphing software. I need to find the value of y when given the value of x. Although the software does this by entering the value in a field, can this been done in Excel for simplicity,
|
| Multiple returned values into a single cell | 17 Jun 2007 20:53 GMT | 11 |
I have an Excel spreadsheet, where I am trying to put multiple results, into a single cell. For example, I have a dropdown selector "Yes" or "No" in a row that states whether I want a column Market name returned: a b c ...
|
| Macro to copy worksheet | 17 Jun 2007 20:42 GMT | 2 |
I have a Summary worksheet that updates daily using several vlookup formulas. I created a macro that would archive this information. In the macro, I first make a copy of the summary worksheet. Then on the copy, I copy/paste special the values and formats onto the worksheet to ...
|
| Enter button jumps to next cell each time its pressed!!!! | 17 Jun 2007 20:34 GMT | 3 |
It drives me mad, I want to be able to put in address, hence need to enter few lines, But each time I want to go down one line, I end up in next cell!!!!! It must be something blindingly simple, but it prevents me from using Excell
|
| Pivot Fill In | 17 Jun 2007 20:29 GMT | 4 |
When using pivot tables, Excel only fills the first cell in a particular column for each section or category of data. Is there a way to get the pivot table to fill all the data elements to have a completely filled in spreadsheet? I would like to format or even possibly complete ...
|
| Time Sheet | 17 Jun 2007 18:19 GMT | 3 |
I am trying to create a timesheet for my students and am running into issue I am not sure how to solve. Any suggestions would be greatly appreciated. The student are to work on a series of projects that take anywhere from 20 minutes to ca. 6 hours during a class period of 83 ...
|
| Confused here Prevent Saving File - but allow ONLY File SAVEAS Met | 17 Jun 2007 16:37 GMT | 2 |
I have the two event codes below. I do not want the current file to be saved with the opening Filename. What am I missing in order to after the user gets the message below he is able to then do a File SAVEAS and (must) enter a new filename?
|