| Thread | Last Post | Replies |
|
| Columns are missing when printing a selection | 29 May 2007 21:13 GMT | 4 |
I have a spreadsheet which allows me to scroll through it while always displaying the first two columns. When I go to print the selection desired (columns A through H) it will not print the first two columns. What do I have to do to correct this. Thanks
|
| spreadsheet Curser | 29 May 2007 20:46 GMT | 1 |
I have created a spreadsheet in Excel 2003 it is a shared worksheet - we use cells a-3 and have entries all the way down to row 384 - my question - I can be in cell E384 and save - but when I reopen the spreadsheet, the curser is still at the top like at D133. It is just a ...
|
| Excel 2007 Severe Performance Problems | 29 May 2007 20:18 GMT | 8 |
When running various workbooks that ran without incident as Excel 2003 applications I am experiencing slow-downs and lack of "resource" halts running the same workbooks now saved as Excel 2007 applications. These are moderate to small excel applications by corporate standards, ...
|
| I need to change the paper size to 11X17, then pdf the file | 29 May 2007 19:29 GMT | 1 |
I've created my spreadsheet. Now I need to send the file in pdf format so that the other user can print it on 11x17 paper. Should I pdf then change paper size? I can't find a way in excel to print on 11x17, especially since my printer won't accept that large size. Help!
|
| Fill range/series help required please | 29 May 2007 19:26 GMT | 5 |
I am trying to auto fill a series, the problem I have is the wrong values are amended through the series and I cannot see how to correct this. . . My series to fill is: =COUNTIF('[2007.xls]Mar 07'!B2:W2,"U")
|
| Calculate average speed | 29 May 2007 19:26 GMT | 3 |
I have a training spreadsheet which includes distance in miles xx.xx (column D) and lapsed time in h:mm:ss (column E) How do you enter and format the lapsed time data so excel can calculate the average speed (column F)?
|
| Font size on the screen is different when printed | 29 May 2007 19:10 GMT | 2 |
I have changed my font from 10 to 16 in my excel sheet. However, when I print the document, the font size is not any bigger. Any ideas that could help me? Thank you very much!
|
| XlFixedFormatType | 29 May 2007 18:32 GMT | 1 |
I would like to use XlFixedFormatType to export an Excel 2007 to a pdf file format with a variable file name from a cell in a macro. I have used this: Sub SaveWithVariableFromCell() Dim SaveName As String
|
| "tools" on the toolbar is grayed out | 29 May 2007 18:06 GMT | 1 |
This morning when I opened my Excel 2003 the "tools" on the toolbar was grayed out. I can't figure out what is going on. Any suggestions.
|
| HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO. | 29 May 2007 17:59 GMT | 1 |
I want to copy a cell that has a reference to a cell in another sheet but I want the new reference to be incremented by 2 positions. example copy cell f1 to f2, cell f1 has a reference to 'test'!r5 I want the f2 cell to reference 'test'!r7
|
| Recovering Overwritten Workbooks | 29 May 2007 17:51 GMT | 1 |
Is there anyway other than the normal Excel data recovery to get back an overwritten workbook? I did not even realize the program was asking me to overwrite the file and when I went to go back into it it was completely blank. HELP!!!!!!!!!!!!!!!!!!
|
| Sum/Count/Max at bottom of sheet | 29 May 2007 17:34 GMT | 1 |
For a quick count or sum of cells, I like to highlight the cells to see the sum, count etc. at the bottom of the page. To adjust what I need (sum, count etc) I change it by right clicking on the bar at the bottom and selecting the function I want.
|
| Pivot Table - Filtering Data Field | 29 May 2007 17:16 GMT | 3 |
Excel 2003 - SP2 When I filter the data field Excel removes all the other data headings in the filter dialog box but those I kept so I can not filter back to those other headings. This does not happen for all the other fields I have tried -
|
| Hlookup with multiple same values? | 29 May 2007 16:42 GMT | 3 |
Microsoft 2003 - I have a row of data that contains user names. Below this row is an "x" in each cell that meets a certain critieria that I already filled out. Now I want to combine all the names in the first row so there is only one name, not multiples of the same name, and ...
|
| Quick formula | 29 May 2007 16:40 GMT | 4 |
I think I'm confusing "if" with "or"...please help. I want cell A to use the value in cell B if there is one, otherwise I want cell A to use the value in cell C and multiply it by 2.25. Pretty easy, but I can't seem to get it to work.
|