| Thread | Last Post | Replies |
|
| watermark | 29 Nov 2007 08:44 GMT | 7 |
Hi all, is it possible to put a watermark in a spreadsheet?
|
| How to find explanation of Excel error values in Help? | 29 Nov 2007 08:08 GMT | 5 |
Arrgghh!! I have forgotten what search key to enter to find the explanation of Excel error values in Help (offline only). How do I do that? I have the information in a book. I not need a summary. I just
|
| How to copy an unreferenced cell and keep the formula | 29 Nov 2007 04:33 GMT | 5 |
I have a formula in a cell, say, =G6. How can I copy this formula to another cell. At present, when I copy the formula changes because it is not referenced. When I copy, paste special with formulas the formula still moves. Anyone have a solution without cutting and
|
| Formatting a datbase | 29 Nov 2007 04:28 GMT | 2 |
can anybody help me? i started a database in excel but need to reformat it. all the database info spreads across three pages and i need to m ove it so thay stack in three columns on one 8.5 by 11 page. so the company is one line, phone the next, address the next, and so on. how ...
|
| Custom Format | 29 Nov 2007 04:22 GMT | 3 |
I need a custom format for latitude/longitude. Currently I have it as ## ##.## If possible, I would like the degrees symbol (superscript little circle) to be displayed after the first two ##. Next question: I need to be able to pull the format apart to calculate the
|
| Help Identifying code statement | 29 Nov 2007 03:50 GMT | 1 |
Can anyone tell me what these codes do? Or what they mean? Thanks lastrow = Worksheets(1).Range("B65536").End(xlUp).Row rw = Worksheets(1).Range("B65536").End(xlUp).Row + 2
|
| How to calculate minimum distance between three coordinate with ex | 29 Nov 2007 03:12 GMT | 2 |
I have 1000 data point with x,y coordinate. I am trying to find a point so that this point will give a total minimum distance between all these points. All suggest would be good! Thanks
|
| paste-link fill right | 29 Nov 2007 03:05 GMT | 1 |
earlier at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public .excel.misc&mid=fb15f05f-9139-47bd-ad18-2260e597da2f i was instructed how to paste-link and fill down using the "INDIRECT" function. Now I need to fill to the right. I need to have this ...
|
| Excell and Word stall on virus request | 29 Nov 2007 00:56 GMT | 2 |
I have just had to uninstall and reinstall a lot of microsoft updates and now both Excell and Word stall while virus request is active. Cannot shut either down. The only way to get out is to do Ctrl/Alt/Delete and get into task manager and close them down
|
| Counting date and catagory match | 29 Nov 2007 00:34 GMT | 6 |
I want excel to return a number if there is a date match in column B and a Category Name match in column C. I want to be able to do it for the whole column because the amount of items that occur on certain dates tend to fluctuates.
|
| A sorted chart? | 29 Nov 2007 00:29 GMT | 1 |
I'm new to VBA in Excel. I have a chart on a Worksheet. And in my VBA code I tell it where to grab data from: Worksheets("REPORT").ChartObjects(1).Chart.SetSourceData Source:=Sheets("Sheet1").Range(Sheets("Sheet1").Cells(ListBox1.ListIndex
|
| Calendars | 29 Nov 2007 00:28 GMT | 1 |
I have seen calendar information (shift dates actually) presented in Excel in monthly calendar pages. Would this formatting have been done by hand or is there some macro or something which does the job for you?
|
| How do I bring text to the edge of the page? | 29 Nov 2007 00:17 GMT | 1 |
I need to delete the margins to utilize the entire page bringing text to the edge.
|
| 2 part ranking question | 29 Nov 2007 00:10 GMT | 1 |
I have a list that changes daily. The data is a 3 digit station code, e.g. LAX, GGV, JFX, ect. First, I need to rank the station by occurrence, e.g. if LAX comes up 15x and GGV comes up 5x then LAX would be ranked 1 and GGV 2, ect. Then, rank the station to the division it finds ...
|
| READING DATA FROM COLUMNS | 28 Nov 2007 23:36 GMT | 2 |
hOW CAN i READ THE CONTENTS OF A TWO COLUMN LIST AND PRODUCE A SEPERATE COLUMN CONSISTING OF THE DATA IN COLUMN B OF THE ORIGINAL LIST ONLY WHEN COLUMN A CONTAINS THE SAME DATA IE
|