| Thread | Last Post | Replies |
|
| Microsoft Office 2003 PDF Feature | 26 Nov 2007 21:27 GMT | 1 |
I used to be able to make a PDF in Microsoft Word 2003 but since my PC crashed a couple of days ago the feature has disappeared. I also had an option on my toolbar but it has also mysteriously disappeared. Does anyone know how to fix this?
|
| password protect a file in Excel 2007 | 26 Nov 2007 21:26 GMT | 2 |
I haven't been able to find how to password protect a file in Excel 2007. A previous post said it was in Save as, and then Tools. There is no Tools with Save in that I can find. Office 2007 is going to take some getting used to! Thank you.
|
| How can I retrieve data from zip file into excel? | 26 Nov 2007 21:07 GMT | 5 |
Does anyone have any suggestions on how to retrieve data from zip file into excel? such as following link http://pitrading.com/free_eod_data/S.zip
|
| Trouble with Page Setup to Print 11x17 | 26 Nov 2007 21:02 GMT | 2 |
I am having trouble printing a spreadsheet that I need to print on 11x17 paper. I have the page set to 11x17 and landscape already. I need all my columns to fit on one page and the spreadsheet can be however many pages long it needs to be.
|
| How to format feet/inches (ft'in") | 26 Nov 2007 20:54 GMT | 4 |
Can I (or How can I) format cells so that I can input my information in feet and inches? Maybe something like: 5'3" Everything would be in whole inch increments, so I don't need to bother with
|
| Summary Sheet Monitored Live | 26 Nov 2007 20:42 GMT | 1 |
I have a service call dispatch log that I use in Excell 2003. The file is protected and shared as view only on a network. I need to monitor the summary sheet (calls not cleared), of the call status, using one of our network stations, with the display being updated live, without ...
|
| Script Suggestions | 26 Nov 2007 20:31 GMT | 1 |
I pasted script below and I need a bit of help with it. It works fine, but I want to refine it. I have this in seven different worksheets (for each day of the week). However, I usally have to edit the part where it says "MONDAY RECEIVING.xls'!
|
| How to add currency symbol to a cell value | 26 Nov 2007 20:05 GMT | 3 |
Is there any possibility to add currency symbol to cell values by using conditional format from built-in currency symbols based on selected currency from combo dropdown box in my excel workbook. or is there any other solution.
|
| How to use "&" character in header or footer; won't print | 26 Nov 2007 19:57 GMT | 2 |
I am trying to use the "&" character in a footer and a header. It will not print or show in print preview but will otherwise display. How can I fix this?
|
| Can I vary the shade or intensity of the color patterns? | 26 Nov 2007 19:47 GMT | 1 |
I would like the chosen color patterns to be less intense when printed. Is there a way to vary the color transparency in a cell?
|
| VBA Delete row based on multiple columns of data | 26 Nov 2007 19:46 GMT | 3 |
I have multiple columns of data that I am currently moving from one workbook to another. After it is moved, I want to delete all of the rows that are blank in columns J,M,S, and V. I can not think of the code to do this.
|
| Excel 2002 : How to reduce the number of unused worksheet ? | 26 Nov 2007 19:46 GMT | 5 |
Dear Sir, I have a file which was open with maximum number of worksheet (255 pages) by its default. I have done a lot of work in that file using up about 50 pages currently,..
|
| Automated Generated Numbers | 26 Nov 2007 19:41 GMT | 2 |
I have to create invoices on Excel. How should i make certain that when the invoice is opened, a new invoice number is generated? SO that there are no duplicates.
|
| Program colunm to switch receievable ammount from 30 to 60 days | 26 Nov 2007 19:37 GMT | 1 |
I'm trying to program the column that contains the receievable ammount to automatically switch when the account moves from 30 to 60 days passed due etc.
|
| Is there an equivalent of sumproduct but for count? | 26 Nov 2007 19:16 GMT | 6 |
I have the following formla, but am look to do the same with "count". Thanks =SUMPRODUCT(--('All Divisions'!A2:A3039="Eastern"),--('All Divisions'!J2:J3039>=30))
|