| Thread | Last Post | Replies |
|
| Excel 2003 Opening in Black & White | 17 Aug 2006 18:16 GMT | 4 |
For the past 3 weeks every time I open an Excel Workbook it opens up in Black & White. I've tried uninstalling and reinstalling and nothing works. Can someone please help me?? Any resolution would be greatly appreciated.
|
| Rounding Net Pay Circular Reference Problem | 17 Aug 2006 18:06 GMT | 2 |
Hi I am constructing a spreadsheet to calculate pays. Problem is I want to round the pays to the nearest $5 and put the balance from the net pay as extra tax. I am using the tax figure to calculate the net pay... which results in
|
| Forms: can a cell itself be clickable? | 17 Aug 2006 17:59 GMT | 1 |
Hi! I'm trying to create a form for my boss. I'm using the forms toolbar, but what it does is throw in a check box for instance, but if I change the cell in any way, the "picture" of the click box stays where it's at. Any way to change this?
|
| opening a worksheet at a specific point | 17 Aug 2006 17:12 GMT | 13 |
i have a diary , i would like it to open at the specific date every time i openen the file.PLEASE HELP>
|
| Per hour-of-day summary chart | 17 Aug 2006 16:44 GMT | 2 |
Is there an easy way to create a chart showing the total number of requests per hour of day from the following raw data (simplified example, real data consists of thousands of log entries)? Timestamp | Number of transactions
|
| Reducing data in a Worksheet | 17 Aug 2006 16:31 GMT | 3 |
I have a very large number of data points, approximately 36000 pairs that was genrated from a test. I would like to reduce the number of datasets so it is not so large of a file to manipulate by skipping a every other row (or maybe 2 or 3 rows). Does anyone now of a formula
|
| how to make this range in this case ? | 17 Aug 2006 16:11 GMT | 6 |
i have 1 range in sheet1 that contains many item, i fill and font color any for per cell i wanna copy all of them to other sheet2, but if i changed any in range in sheet1, then range in sheet changed too. it mean they are a mirror
|
| Auto replace, can it easy be done? | 17 Aug 2006 16:03 GMT | 3 |
I have a series of tables where by I put in each tenant's name (column a) and their lease end date (column b) and add any special comments or irregularities in the leases in column c. Right now we either type in each individual comment or use number codes, or essentially footnotes
|
| Please help me decipher the result of COUNT. | 17 Aug 2006 15:31 GMT | 14 |
Following data from A1:A7 Sales 12/8/2008 19
|
| Opening Multiple Web Links in a Column | 17 Aug 2006 15:15 GMT | 1 |
I am very new to using web links in excel. A task I do very often is open a list of different websites that are in various columns in an excel spreadsheet. I am quite sure I am doing it the slowest way possible, so I need some help please. Basically I have been clicking
|
| There must be a way... | 17 Aug 2006 14:56 GMT | 1 |
Hey All: I've got a quick question that's been bugging me for a while. If I'v got data arranged by columns, but I've written a formula which I wan to drag right (i.e. rearrange the calculated data into rows), then ho
|
| copy a column of single cells into a column of merged cells | 17 Aug 2006 14:27 GMT | 3 |
I am trying to copy a column of single cells on one worksheet into a column of merged cells on an adjacent worksheet- does anyone have any methods of achieving this? I tried formulas, but the referencing gets messed up and in the merged cells it only displays every fourth entry
|
| How to get thousand seperator after every two digits | 17 Aug 2006 14:16 GMT | 2 |
When i enter a number in excel and when thousand separator is applied it is adding comma after every three digits. 123,345,678.00 But i want to have the comma after every two digits after the first
|
| inserting object | 17 Aug 2006 14:06 GMT | 3 |
i try to insert pdf file to my excel file in Insert>Object>Create from file>Browse the pdf file there an message appear when opening the inserted file-"Cannot start the source application for this object"
|
| Going to worksheet based on answer | 17 Aug 2006 14:04 GMT | 2 |
I am using Data Validation (List) to provide the user with, say, options. Lets say the options are A,B,C - depending on the answer, can I jump t a seperate worksheet.
|