| Thread | Last Post | Replies |
|
| save as | 03 Mar 2007 14:46 GMT | 2 |
Where is "save as" option in Excel 2007? I have a spreadsheet on USB drive and would like to save it to my hard drive. Mark
|
| List deleting or changing | 03 Mar 2007 13:36 GMT | 1 |
I have a list of data that was given a name to an area of data though I've added more data (rows) and the list doesn't work with the new data added and reverts back to the original named list regardless of row additions anywhere. How do I change the range of data named to cover ...
|
| copy and paste data from website | 03 Mar 2007 11:02 GMT | 1 |
I need to copy and paste large quantity of text and numerical data (currency) from a website into an excel worksheet. When I paste the data into the excel worksheet, the columns have leading spaces and the column with the numerical data has leading spaces so it is not recognized ...
|
| Theatrical Resume | 03 Mar 2007 10:59 GMT | 1 |
What format/template is used for a theatrical resume?
|
| Format Paragraphs. | 03 Mar 2007 04:30 GMT | 3 |
Is there any way typing a long paragraph in Excel and have the system format it into justified lines each having several words in it? Don J ----------------------------------------------------------------------------
|
| NAICS Code Cell Format | 03 Mar 2007 04:29 GMT | 3 |
I recently downloaded some US Census data (NAICS codes) into Excel and they have a cell format that I am unable to change. When I sort a list of numbers (e.g. 10, 12, 101, 111, 112), rather than sorting these numbers from lowest to highest (or vice versa), the numbers are sorted
|
| Link to cells in other worksheets & workbooks | 03 Mar 2007 04:14 GMT | 2 |
I just got a new computer & installed Excel 2002. On my old computer I used to be able to create formulas that linked to cells in other worksheets or workbooks. I would just type = then select the worksheet tab & then click on whatever cell I wanted to reference.
|
| division cell | 03 Mar 2007 00:36 GMT | 4 |
Should I divide a cell in 2 parts diagonally and to write in every part a text. .... someone knows how to do? Thanks
|
| Display in same cell lbs(kgs) using formula to auto-convert lbs | 02 Mar 2007 23:43 GMT | 1 |
I would like to have a cell show #lbs(#kgs) in that format. But have the kgs measurement autoconvert from the entered lbs number. So the formula would look something like this Xlbs(Ykgs=X*0.454). I would also similarily like to have a #in(#cm) cell setup but I am guessing it ...
|
| Worksheet Tab names? | 02 Mar 2007 23:18 GMT | 7 |
Within a Workbook can I arrange things such that the Worksheet Tab name is taken and maintained from a cell within the same Worksheet, or better yet an index of Worksheet Tab names in a master Worksheet? If so How? TIA.
|
| Solving for variable with a circular reference | 02 Mar 2007 22:46 GMT | 6 |
I am trying to solve for a variable that refers to itself. I am using MS Excel 2003. I have a feeling I need to use the iteration function or solve mathematically but am wondering if I can get some hints. Example: solving for "A." All of the other numbers are variables that ...
|
| Changing to lower case | 02 Mar 2007 22:43 GMT | 4 |
I have a 7000+ line worksheet that is ballooned into a very large address book. Over the years some of the addresses were entered in all caps, others (~6000) in corect case. Is there a way that I can automatically change to proper case, ala MS Word? I am using Excel
|
| Formatting .. is it possible to .... | 02 Mar 2007 21:30 GMT | 2 |
format a range of cells like c6 through h6 with a fill color of green if the value in cell k6 is positive and with a fill color of red if it is negative? How would that be done?
|
| password protect the button in Excel? | 02 Mar 2007 21:06 GMT | 3 |
I have some buttons in my Excel files and assigned macro behind them. I have add password protection to the VBA code so without password, the users won't see the VBA code. But now my boss want even the buttons to be password protected -- he doesn't want users to click on the ...
|
| Closing a Cell When Excel goes Inactive | 02 Mar 2007 18:23 GMT | 1 |
Excel 2000. I want to be able to close off the data entry/editing on a cell when the user switches to another application. The reason for this is that while the cell remains open for editing I cannot remotely execute save and close macros from an external application. While I ...
|