| Thread | Last Post | Replies |
|
| Cell Horizontal Spacing ? | 30 Nov 2007 21:38 GMT | 1 |
Using Excel 97 The majority of my worsheet is fine, but here and there I seem to have a different size for the light blue grid lines that delineate the horizontal spacings for the
|
| Comments are out of alinement | 30 Nov 2007 21:22 GMT | 1 |
When I choose to show my comments they are all a thousand rows down. I have about a hundred of them. Do I have to straighten them all one at a time are is there someway I can straighten all of them to be with the cell they belong too. I am trying to save myself about 2 or 3
|
| How do I change the column heading in Excel to display "A" "B" "C | 30 Nov 2007 20:06 GMT | 1 |
I have Excel 2003 and when I start is up, the new worksheet display the column heading as "1" "2" "3" etc. How do I change it to A, B, C etc?
|
| Excel If Statements - getting over the Excel limit of 7 | 30 Nov 2007 18:51 GMT | 3 |
I am trying to create a conditional statement with 17 IFs. I started needing to do 11 Ifs. I got over the Excel limit of 7 by identifying a cell in the last element of the first string of 4 IFs in which there was a further string with 7 IFs. However I now need to expand this to ...
|
| Cleaning blank spaces before and after text in a copy & paste problem | 30 Nov 2007 18:41 GMT | 4 |
If I cut and paste this (see below) from an email body to Excel and do a Text to Columns, I can't remove the blank spaces before and after each of the three columns. I have tried =TRIM(cell) and =CLEAN(cell) but to no avail. I made sure the columns were in the Text format.
|
| Locking cells | 30 Nov 2007 18:39 GMT | 8 |
Is it possible to lock and unlock cells on one sheet based on certain criteria in a certain cell on another sheet ?
|
| Dynamic Embedded Hyperlinks? | 30 Nov 2007 17:56 GMT | 3 |
I'm creating a spreadsheet for clients to use to go out and hit a government website to get data. Every client has a different Certificate Number to get their information from. I'd like to give the client a box to input their CERT number so that I don't have to worry
|
| Track household revenue and expense! | 30 Nov 2007 17:34 GMT | 1 |
Any template that can do that, french if possible?
|
| Lostl Workbooks in Excel 2007 | 30 Nov 2007 16:49 GMT | 1 |
Using my laptop with Excel 2007, I cant seem to locate workbooks after startup. The main excel screen appears with a blue page but cannot locate the workbooks around the screen( although they show in the task bar). On my PC, I can just locate them way off to the side of the ...
|
| Pivot Chart Help Please | 30 Nov 2007 15:57 GMT | 2 |
I have a spreadsheet with about 70000 rows and in it are amongst other things part names, prices and number of days before they were used. There are about 250 parts which are repeated through the table and I was wondering rather than doing it manually is there an easy way to
|
| Protected Worksheet And Lists | 30 Nov 2007 15:07 GMT | 2 |
Is it possible to protect a worksheet that contains a list, and still be able to add rows to the list? (Excel 2003) Thanks, Mark
|
| number formatting | 30 Nov 2007 14:53 GMT | 3 |
Hi. I was woundering how I can add trailing zero's to numbers. I have a colunm with number lemgths between 1 and 7 digets and need them all to be 10 diget's long. I have no trouble with adding the zero's as headers but needt hem as trailers. Thanks.
|
| Change default author name for comments | 30 Nov 2007 13:25 GMT | 1 |
How do you change the default name of the author of a comment in Excel 2007? Regards, Jarryd
|
| Generating blank cells in Excel 2007 | 30 Nov 2007 11:54 GMT | 1 |
I'm creating graphs in Excel 2007 and my ranges contain cells that can be empty. The ranges contain cells with formulae that sometimes need to return blanks. I've done this using "" (two double quotes).
|
| Excel 2007 Bug? Conditional Formatting | 30 Nov 2007 11:26 GMT | 1 |
My client has the following situation: Sheet1 A1 = 5% A2 = $3.00
|