| Thread | Last Post | Replies |
|
| Watermark behind text in the footer? | 03 Apr 2006 04:12 GMT | 2 |
Hello Excel experts! I'm working on a spreadsheet of about 50 pages in Excel 2003. Ideally, the client would like each page to have a footer with a number 1, 2, 3, etc... in the bottom right hand corner...identifying his
|
| Show figures and dates for "top ten" | 03 Apr 2006 03:50 GMT | 6 |
I apologize if this has been asked before, but I couldn't find anythin with a search. I have a table with monthly revenues. The headings across the top hav the years, from 2000 to 2006. The headings at the side have the months
|
| Import Hyperlink from MSAccess via MSQuery | 03 Apr 2006 03:35 GMT | 1 |
I have a user with an Access query that has a hyperlink column. The user requires that this query be available to other users via a spreadsheet. Using MS Query, I need to export various columns, including the hyperlink to Excel. All good, apart from the hyperlink column, which ...
|
| Find and delete single character | 03 Apr 2006 03:26 GMT | 11 |
Is there a function to find and delete a single character, lik alphabet, or symbols like >, #, ', ?, ` , etc -- KH_G
|
| newbie question on multi-dimensional array | 03 Apr 2006 03:11 GMT | 2 |
Hi all, I have a real lame question about multi-dimensional array operation. Suppose I have defined a two-dimensional array "Array(10,10)". If I want to use the Excel function "Average" to compute the average value
|
| Summing up mixed data? | 03 Apr 2006 02:55 GMT | 2 |
I have been looking at a way to solve a minor issue while I recreate a score keeping wookbook. We are tracking review scores that have % score and a Pass Fail. There is a grid by person by date and scores saved as combined values. So we
|
| Update LINKS when opening a workbook? | 03 Apr 2006 01:43 GMT | 1 |
Hi Excel Experts, I've stumpled upon a little problem. I will try my best to explain wha I've encounterd. Main Workbook (let's call this MONTHS workbook).
|
| Repeating columns cuts off merged cells | 03 Apr 2006 00:56 GMT | 3 |
I hope you can help because I can't find a solution to this one. I've got a two page spreadsheet (side by side) and I'm trying to repeat columns A & B because their row headings on the left and should only appear when printed (split onto two pages) (as in print setup > columns
|
| can't open excel 2003 | 03 Apr 2006 00:56 GMT | 3 |
I have been running Excel 2003 (Part of Office 2003) under Win2K for ages. All of a sudden, apparently after installing Security Update for Excel 2003 (KB905756), Excel will no longer open. The flash screen appears for an instant and then disappears. Trying to open it through
|
| I keep getting a "Circular Reference" error message but there is nothing in that cell. | 02 Apr 2006 23:58 GMT | 2 |
I using the dependent precedent to track it down and there's nothing. How do I stop this? Delete the cell? Marc
|
| formula help | 02 Apr 2006 23:47 GMT | 2 |
I am trying to create a formula where it takes the result of one formula and adds .60 if the answer to a question is yes but adds zero if it is no. The first part of my formula is as follows: =10+(IF(F44>1,(F44-1)*8.5))
|
| v-lookups | 02 Apr 2006 22:11 GMT | 4 |
I'm struggling with some vlookup formulas. I'm going to be taking some Excel level I and II evening courses, but not in time to help me understand vlookup formulas I need at work soon. I'm googling of course.... but does anyone know of a good primer site that can walk me ...
|
| embarassed to post question | 02 Apr 2006 19:50 GMT | 4 |
sample of 2 worksheets for measuring hurricane shutter Sheet 1 a b c d 1 window width heigth span
|
| HTTP link in Excel | 02 Apr 2006 19:45 GMT | 1 |
I have created an extra item in a drop down menu in the Excel menu toolbar, and have attached an onclick event on it which when clicked should go to a website. However eventhough the url loads it becomes distorted, boxes, texts are not
|
| annoying scrolling | 02 Apr 2006 19:39 GMT | 7 |
I've got an annoyance when using Excel. Sometimes when I attempt to select a series or rows that extend beyond the size of the screen, my machine will scroll so fast when I reach the end of the viewed area that it goes well beyond where I want it to stop. Is there a simple
|