| Thread | Last Post | Replies |
|
| Printing a group that is not grouped | 22 May 2007 19:38 GMT | 2 |
I have a document with 11 different sheets in it. If a qty is entered on any of the sheets I would like it to be included in the group to be printed. Is there a function to print sheets with changes from the "template" that I have created?
|
| Converting Spreadsheet into Cover Sheet | 22 May 2007 19:14 GMT | 14 |
I want to take my spreadsheet and take each column and place it on different areas of a cover sheet. Is this even possible? For example, A1 would be the title...E1 would be the abstract, something of this nature. Your help is greatly appreciated.
|
| Tool bars | 22 May 2007 18:58 GMT | 10 |
We have just upgraded to Office 2007. I’m having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics
|
| How to determine the value from a list? | 22 May 2007 18:51 GMT | 6 |
Does anyone have any suggestions on how to determine the value from a list? 22,22,25,27,27,28 I would like to determine the second smallest value, but skip checking the repeated one, such as in this case, I should select 25 and skip 22 because
|
| How do I combine multiple rows with like data in Excel? | 22 May 2007 18:47 GMT | 2 |
I don’t know what this would be called or what formula to use and would greatly appreciate any help I can get. I would like to take the example table below and get the following results. First Last Address Previous Employer
|
| Return Date using two dates and a word | 22 May 2007 18:46 GMT | 4 |
I am trying to make a time table based of a completion date A1 for specific tasks. Some completion dates have a range of dates. Here is what i need to do. If cell A1 is 12/1/07 i want a cell to return "9-1-07 to 10-1-07". I have no
|
| Change hyperlinks | 22 May 2007 17:22 GMT | 1 |
I have a user that has a 2MB Excel workbook with hundreds of hyperlinks to other Excel spreadsheets - which are all located on his external hard drive (G drive). Something happened with his login settings, and ended up changing all of the hyperlinks to C:\Documents and ...
|
| Formating pre-sets are all wrong | 22 May 2007 16:51 GMT | 4 |
I've opened a new Excel document and all the formatting is wonky. If I type a "1" it reverts to ".01". I change the format for a column for social security numbers, and it adds two zeros at the front: 123-45-6789 becomes 001-23-4567.
|
| how to paste values created by custom format? | 22 May 2007 16:50 GMT | 9 |
I have a spreadsheet that has a column of ID codes on it that all appear to be 7 or 8 digits long. Looking at the formatting, it seems that the formatting of all of this column is a custom format of "0000000". This means that some of the entries which are really only 6 digits, ...
|
| Assigning values to drop-down list options | 22 May 2007 16:43 GMT | 3 |
I'm not even sure if Excel can do this... I have a worksheet with 5 different drop-down lists on it (each with several options to select from). I want to be able to assign each option a value so that I can create a cell/formula that will average the values selected.
|
| Is there a table of Excel function-names for different languages? | 22 May 2007 16:32 GMT | 5 |
I work in a school with foreign students, some of whom have laptops with Excel in their native foreign-language versions. Our teaching materials use English, and it really slows up some of our students when the translations of Excel commands are not obvious.
|
| How can I count the number of characters on a cell? | 22 May 2007 16:29 GMT | 11 |
I have several hundreds of line items that need to be entered to a web application that restricts the length of each line to 40 characters. Is there a way to count the number of characters on a cell so I can automate the review process for each cell of my spreadsheet with one ...
|
| How do I reset the tab key? | 22 May 2007 16:26 GMT | 2 |
In an Excel worksheet my tab key does not just shift one cell to the right. Somehow it has gotten set to move a page to the right when pressed. How do I reset it to just move one cell to the right?
|
| Number of Copies for worksheet defaults to 5 incorrectly | 22 May 2007 16:18 GMT | 1 |
I Have a workbook that contains many worksheets. When trying to print the sheets, the Number of copies setting defaults to 1 for each sheet except 1 sheet which defaults to 5. If it is changed to 1 that's fine for that print but it then defaults to 5 again afterwards. There is
|
| Macro not recognizing blank lines as blank | 22 May 2007 16:16 GMT | 9 |
In the example below loc has two 4276 rows. I have a macro which deletes the blank rows, however, it's not recognizing the cell as blank. There's no formula in the cell. In the macro I've formatted the rows to get rid of the formula. Any ideas?
|