| Thread | Last Post | Replies |
|
| data, sort option is grayed. how to sort on a column? | 25 Sep 2007 15:25 GMT | 1 |
right click to select column. data menu. sort option is grayed. why? ( I thought it was because I had already sorted this spreadsheet. but I created a new sheet, copied in a few columns of my problem sheet. and I can sort on any column I choose to. )
|
| How to i capitalize all words in an existing worksheet? | 25 Sep 2007 15:19 GMT | 3 |
I have a worksheet that contains approximately 2500 names. At this time all names in in lowercase. I need to get them all into UPPERCASE. I know there's got to be an easier way to do that rather then retyping each name.
|
| Copying the repeated data of the previous sheet to the next sheet | 25 Sep 2007 15:18 GMT | 1 |
I have a problem while exporting a data in an excel sheet. The first time I have exported I got the data as mentioned in column A and the relative data is manually entered as in column B Sheet 1
|
| fromula bar | 25 Sep 2007 15:09 GMT | 2 |
the formula bar in my excel program has a horizontal orientation but entered data is presented vertically, making it difficult to read. i have been unable to find a way to change that. thanks for the help.
|
| how cani create a pop up reminder when closing excel? | 25 Sep 2007 14:59 GMT | 2 |
i want to create a pop up window so when i x excel, it pops up like an error message. so it says 'did you remember to update total of customers' with a yes and return button. Please help me :D
|
| Wacky time calculation | 25 Sep 2007 14:56 GMT | 6 |
One of my data sheets at work brings numbers into Excel as decimals. For instance, 5 hours and 39 minutes is shown as 5.39. How can I get Excel to convert this to 5:39 (semicolin instead of decimal)?
|
| Keeping Margins and Forcing Landscape mode on a shared Document | 25 Sep 2007 14:36 GMT | 1 |
I made a Excel Spreadsheet that is set to landscape and has a few adjusted Margins. I put it up our office Network but everyone else who opens it still sees the old Margins and Portrait mode. Yet if I open it, it's fine. Any idea how I can get everyone else to view it the ...
|
| Matching Names listing Data from one Column! | 25 Sep 2007 14:20 GMT | 1 |
Hey all need some help! Data Sheet 1 Conisits of Names from B15:B49
|
| Creating a Search Cell | 25 Sep 2007 13:51 GMT | 3 |
I have a customer list in column 1 from a4 to a500. I want to be able to in a1 type some letters and the customer corresponding to the letters i am typing in comes up. Exactly like a search engine for excel. Any help on this?
|
| about this formula =DATEDIF(J5,H5,"d") | 25 Sep 2007 13:46 GMT | 4 |
i can use this formula in my excel {=DATEDIF(J5,H5,"d")} the results is VALUE
|
| How to retrieve data from other filename? | 25 Sep 2007 13:42 GMT | 1 |
Does anyone have any suggestions on how to retrieve data from other filename? For example, the filename for my current workbook is Eric - RRRRR.xls, and the cell A1 under sheet1 for Eric - RRRRR.xls workbook equals to the cell B2 under sheet2 for Temp - RRRRR.xls. And I get a ...
|
| Prevention of Printing | 25 Sep 2007 12:20 GMT | 1 |
I would like to send an excel document to someone , it consists of approximately 6 worksheets. Is there a way that I can prevent them from printing it out once I have emailed it to them. Any help would be appreciated.
|
| if number occurs twice | 25 Sep 2007 12:14 GMT | 1 |
Good day, If I've gat the same number showing up twice , can I get the name next to the second number as well. A B
|
| Save As Functionality | 25 Sep 2007 11:34 GMT | 2 |
I have noticed that when i go to file - save as... and then select the drop down list to select the drive i wanna put my .xls file into... that it takes sometimes 3-4 minutes for it to drop down. This doesnt happen in any other Office program. I am on a company network (fyi)
|
| How to determine the top 5 occurrences from a list of numbers? | 25 Sep 2007 10:30 GMT | 3 |
Does anyone have any suggestions on how to determine the top 3 occurrences from a list of numbers? For example, 1,1,1,1,1,2,2,2,3,3,3,3,3,3,4,4,5,5,5,5,5,6,6,6,6,7,7,7,7,7 under column A The occurrence of 1 is 5 times
|