| Thread | Last Post | Replies |
|
| Sort order on very large spreadsheet. | 31 May 2007 17:32 GMT | 4 |
I have several cells that will not sort properly. Is there some kind of setting that will prevent them from sorting from a to z. When I manually enter some of the problem cells again in another workbook, they sort fine.
|
| Ctrl + Pagedown lock | 31 May 2007 17:29 GMT | 3 |
Can you please help me to lock navigation through the sheets tabs using ctrl+page down button
|
| Eliminating Spaces | 31 May 2007 17:22 GMT | 5 |
How do I eliminate all rows without any entries without having to go into each row individually?
|
| How do I make an excell cell blink? | 31 May 2007 17:14 GMT | 2 |
I am told there is a way to make cells "blink" in excell. How can make this happen?
|
| Pivot table usage | 31 May 2007 17:08 GMT | 3 |
happen to see this function-Pivot table. What's the function for this? Any ideas on how to use this? Thanks!
|
| delete single spaces | 31 May 2007 17:03 GMT | 5 |
How can i delete a single space from a cell example 123 456, to 123456 I see the trim option and clean but does not do this simple? task Please help someone , Mark
|
| send mails from excel | 31 May 2007 17:02 GMT | 3 |
i want to send mails to people whose email ids are stored in a column(say col A)(different rows). i want to send individual mails with a common subject. in message body should be like
|
| Formula Fill Problems | 31 May 2007 16:52 GMT | 6 |
I have a formula that I want to implement for a series of data points. For the first cell(A1) the formula would be "IF(E5=0, NA(), E6/E5)" The next cell in the series (A2) would be "IF(E8=0, NA(), E9/E8)". So each time the formula is iterated it increases each cell value by three ...
|
| Transpose columns to rows with spaces | 31 May 2007 16:46 GMT | 4 |
I have: name address phone#
|
| HOW DO I SORT DATA USING A SPECIFIC CHARACTER IN A CELL | 31 May 2007 16:42 GMT | 1 |
I am trying to sort a large excel worksheet using a specific column. Unfortunately the complication includes the fact that the column is alpha numeric, and that even worse, I am trying to sub sort by a numeric value - the final two digits.
|
| convert column to row | 31 May 2007 16:41 GMT | 2 |
I have a list of several hundred staff in a column - see below (A1) title firstname last name (A2)address 1 (A3) address2
|
| Averages | 31 May 2007 16:37 GMT | 1 |
My question is...I have an Excel workbook with numerous sheets (one for each week) and on each sheet I am entering a 5 day minimum sales amount (column C) a 30 day minimum sales amount (column G) and a 90 day minimum sales amount (column K). I am them going back at the end of ...
|
| filter count | 31 May 2007 16:17 GMT | 3 |
I am using Auto Filter. It isn't "counting" the selected records in the bottom left corner of the screen. HELP.
|
| "#DIV/0!" | 31 May 2007 15:59 GMT | 4 |
I looked at the #DIV/0! theme but there were too many technical words for me to understand. I hope someone can help me with this one. I am trying to breakdown the percentage of four types of house (A, B, C AND D) built on two different plots (X and Y).
|
| Sorting Problems | 31 May 2007 15:50 GMT | 6 |
I have a worksheet setup with mutliple rows that are dependent on one another. I.e. Row 1 is the title, Row 2 is data about row 1, Row 3 is data about the title in row1, this repeats for new title/data every three rows. I would like to be able to sort data based on the title in ...
|