| Thread | Last Post | Replies |
|
| transfer a variable balance from one worksheet to the next | 31 Jul 2007 23:28 GMT | 4 |
I have recently started using Excel to manage my monthly budget. I have successfully set up monthly worksheets, but would like to carry forward the final balance from one month to the next. This will be a variable balance. I know that probably the easy way out would be to ...
|
| Counting Hours in Multiple Days | 31 Jul 2007 22:50 GMT | 7 |
I'm attempting to do something that is currently beyond my skill level. Here's the problem: I have the following columns: Start Date/Time, End Date/Time. I want to count the number of hours each day for each day of the period. I
|
| Books for Excel 2007 | 31 Jul 2007 22:18 GMT | 2 |
Is there any recommendation of books for excel 2007? I know the book Step by Step for Excep 2007 is a good start, however, I want a similar book with tutorial like book from elementary to intermediate.
|
| Changing from One Side to Two Sided Printing - HP 2420D | 31 Jul 2007 21:40 GMT | 3 |
I've got a spreadsheet with multiple tabs. To change from one sided printing to two sided printing, it seems that I have to go to each tab, click on page setup, on the page tab select options and then change from one sided to two sided printing. I can't select all of
|
| Copying individual sheets from 1 worksheet to another | 31 Jul 2007 21:15 GMT | 2 |
I would like to copy an entire sheet (tab) from one worksheet to another. It seems easy at first. I merely "select" all the cells in the source sheet (tab) in the source worksheet, copy to the clipboard (^C), select the destination sheet (tab) in the destination worksheet,
|
| view of cell contents changes to #### when cursor leaves cell, ev. | 31 Jul 2007 18:48 GMT | 1 |
In Excel, view of cell contents shifts to ###### when cursor leaves cell, even when auto-fit, wrap text, shrink to fit, have been tried, and even when row and column have been enlarged to allow adequate room.
|
| how to "install" a template or macro | 31 Jul 2007 17:51 GMT | 3 |
I am new to excel templates and I have a template file (.xlt) and a macro file (.xls) but together by a friend, and I would like to put them into an "exe" type install. Looking around at microsoft downloads I found a "sample 2000 template" for
|
| format cell type | 31 Jul 2007 17:48 GMT | 6 |
Hi everyone, in a spreadsheet, I have a complex data type that I want to sort correctly. The format contains a prefix that contains both letters(A) and numbers(0) followed by a suffix after a hyphen and another number. Example:
|
| Excel 2007 Vista | 31 Jul 2007 16:49 GMT | 2 |
When I try to opne Excel 2007 in Vista, the application appears with the lower status bar on top and greyed out, and complete blue in the middle - no spread sheet. I have to close using ALT-F4, try re-opening and it comes up that way again - then sometimes it opens up normally.
|
| set the background color of the current cell(active cell) | 31 Jul 2007 16:48 GMT | 2 |
how to set the background color the row of the current cell(active cell) each time I click the cells.
|
| Large Excel Data Set becoming unmanageable | 31 Jul 2007 13:50 GMT | 2 |
I am currently working in Excel with a large set of data that could probably be handled better through other programs, but this is what I am limited to. I need to create pivot tables and graphs from the data, but in order to define the data better, I need to add an extra
|
| Combine two Excel files | 31 Jul 2007 02:44 GMT | 1 |
I have two Excel 2000 files that only contain two fields, Last-name and First-name. I want to combine the two files into one. Isn't there a way to import one Excel file into another? If so, how? Your help would be appreciated.
|
| creating a table on microsoft excel 2003 | 31 Jul 2007 02:38 GMT | 2 |
I am trying to create a table in excell 2003 its confusing me like crazy i dont know how to insert it or anything, please help.
|
| Script to make text in uppercase, on workbook level, but not for other opened workbooks. | 31 Jul 2007 01:19 GMT | 8 |
(A) I do have undermentioned script, but I cant't get it worked. I want to have cells changed to uppercase after Enter-command. (B) How to have this script for all sheets, so to have it on workbook level? And, how to avoid that other excel documents that are opened
|
| vlookup | 31 Jul 2007 00:47 GMT | 11 |
I use vlookup to get information listed on worksheet 1 (by a numerical number say 1 to 56) in column A and enter it on worksheet 2. I don't want worksheet 2 to change if I add Information to worksheet 1 and then sort worksheet 1 by column B.
|