| Thread | Last Post | Replies |
|
| Excel sheet: scroll down, but leave first lines visible | 10 Aug 2007 16:44 GMT | 4 |
Have to solve a problem fast: Excel sheet has in the first 4 lines text that i want to have visible at all times ( fix on top ) even when i scroll down on the sheet......
|
| Keyboard shortcut won't copy zero text value? | 10 Aug 2007 16:03 GMT | 3 |
I'm using XL2003. According to the Help file for Keyboard Shortcuts, Ctrl+" copies the value of the cell above into the active cell. The value I'm trying to copy is '0.0 (apostrophe+"0.0", since the sheet is set to not display zero values, so I use the ' to make the zero value
|
| Excessive memory use | 10 Aug 2007 14:13 GMT | 2 |
I have a problem running Excel 2007 on a laptop with Windows Vista. Any time I work with a file of any substantial size, the program repeatedly freezes up. Windows Task Manager shows that Excel is using all the available CPU, even though I'm not performing any
|
| IF number is grather than 100 color the cell red | 10 Aug 2007 03:29 GMT | 2 |
I did this before but I can't remember how I did it. I want to have a column of numbers and if they are greater than a certain value ie: 120 , I want the sell to have the color red. Any ideas how to do this in Excel 2007?
|
| Exclude Data of Access | 09 Aug 2007 23:24 GMT | 3 |
I'm trying to exclude some data in my access table, but the code bellow doesn't work. I need that excel to exclude all data in the table that contains a criteria in two range of excel. It's the message error: "no value was supplied for an or more
|
| Within Excel | 09 Aug 2007 23:05 GMT | 3 |
Sorry, What's happening is that I double click on a 2003 Excel file, opens up in 2007. You cannot view the file unless I click on the Microsoft main menu button. Then it pops up. I mean that it initially doesn't pop up right away,
|
| Import from TXT file with "No record delimiter" | 09 Aug 2007 23:02 GMT | 2 |
I'm trying to import data from a text file into excel. Each record is 331 characters and there are no record delimiters. The file ends with a carriage return and line feed (ASCII13 and ASCII 10) I'm having no luck importing it and only get one record when I manually
|
| How do I get rid of that large "PAGE 1" thing in Excel? | 09 Aug 2007 21:18 GMT | 2 |
I'm trying to delete the large "PAGE 1" background text in an Excel spreadsheet. I used the F1 key, and it was useless.
|
| How can I increase my price list by 5%, multiply missing under pas | 09 Aug 2007 21:14 GMT | 3 |
I am trying to increase an existing price list by 5%. I have entered 1.05 in an empty cell, copied it, highlighted the cells to be changed, gone into Edit - Paste Specials but there is not a multiply tab to use only unicode text and text. Help!
|
| Wrap Text in Merged Cell - How? | 09 Aug 2007 20:11 GMT | 8 |
Excel 2007 If I merge several (or even 2) cells in a row, I can not get the text to wrap when I hit enter. It works, of course, in a single cell. How can I get the text to wrap in merged cells? I have checked "Wrap text"
|
| VBA Query that references a reserved word in one of the field names. | 09 Aug 2007 19:00 GMT | 1 |
I am extracting data from Pervasive 9.1 using Excel VBA. I want to avoid using "SELECT * FROM TABLE1". Instead, I want to select specific field names. However, one of the field names is "DESC" which is a reserved word in Pervasive 9.1.
|
| Cannot view file after double clicking on a file with 2007 | 09 Aug 2007 18:37 GMT | 4 |
Also, when I load excel, or word. When I click on the main menu button up in the left corner it doesn't show up.
|
| Excel 2007 Replace and single quotes | 09 Aug 2007 17:29 GMT | 5 |
I have a spreadsheet that got loaded in Excel 2007 so the cells show the following info, complete with single quotes: '02' 'test' 'another column' '07' 'stuff' 'more data'
|
| How to apply the same formula to an entire column | 09 Aug 2007 16:34 GMT | 5 |
I have a sheet that has over 6,000 rows (data transfered from an access table) I have added a column In the new column I want the formula to be =A3=B3 which will result in True or False and in the next row it want it to be =A4=B4 then the next row should
|
| Vlookup FALSE Value in VBA | 09 Aug 2007 15:22 GMT | 2 |
Hi Group, I'm using a form to enter addresses into a worksheet and have created a lookup which is fed by another form, "postcode search" Private Sub CommandButton1_Click()
|