| Thread | Last Post | Replies |
|
| Themes button in Excel 2003 | 19 Sep 2007 21:44 GMT | 1 |
There is a button in Excel 2007 on the page layout menu called Themes. Does Excel 2003 have the same button or capability? If so, how is this done in 2003?
|
| links missing | 19 Sep 2007 21:41 GMT | 1 |
I have workbooks set up for officers - they each have 52 sheets within their workbook and as they enter information it feeds into a complete total column that keeps updating from week to week. There is a link setup on each persons workbook that feeds into a complete stats ...
|
| Vlookup and HLookup Issue | 19 Sep 2007 21:37 GMT | 1 |
I currently have this formula on my main sheet today: =IF(ISNA(VLOOKUP($B6,prin_received_091807.xls!$A$8:$H$98,3,FALSE)),0,(VLOOKUP($B6,prin_received_091807.xls!$A$8:$H$98,3,FALSE))) My issue is that on my prin_received sheet I do not always have the same columns. So I basically ...
|
| Sorting | 19 Sep 2007 21:14 GMT | 12 |
I'm having a hard time with this problem. Please help! Example: I need the following to sort: A1= Green B1= 1 C1=0 D1=1
|
| VB codes for option buttons | 19 Sep 2007 21:12 GMT | 7 |
I have a command button and two option buttons in my file and I need switch between two option buttons(I mean selecting button1 or button2 alternatively) by pressing the command box by means of VB codes.can anybody help me. thanks
|
| Sum of a cell if certain criteria are met. | 19 Sep 2007 21:06 GMT | 2 |
I know this is probably easy, but for some reason I am having a hard time with it. Here's what I want to do. IF A1=L THEN C1-B1 IF A1=S THEN B1-C1
|
| Excel 2007 : Online Resource Materials on Functions and Formulas | 19 Sep 2007 21:00 GMT | 2 |
Dear Sir, I wish to learn more about Excel 2003/7 functions and formulas online. Do you knew of any good website that provide free materials on this ? I need the tutorial notes with lots of worksheet example based on the real
|
| Create a single xls file with each import csv file having its own tab | 19 Sep 2007 20:38 GMT | 1 |
All, I have 26 csv files named a.txt .. z.txt. I want to be able to import all of these files using the name of the .txt file as the name of a tab and import all data as text not
|
| generate numbers | 19 Sep 2007 20:20 GMT | 3 |
We have designed tickets and each will have a number: VIP-0001 VIP-0002 VIP-0003
|
| how to check for ANY text when conditional formatting? | 19 Sep 2007 20:10 GMT | 4 |
I just want to conditionally format the cell if there is ANYTHING written in the cell. Can't figure it out!
|
| Security Levels and Macros | 19 Sep 2007 19:41 GMT | 1 |
I have a spreadsheet that I want to distribute to multiple users presumably with different versions of MS Excel. This spreadsheet contains a macro, that will only run if user's software has a security level of medium or lower. Is there a way to get around this limitation, ...
|
| Roll back toolbar | 19 Sep 2007 19:07 GMT | 1 |
I have a friend who is new to spreadsheets. He bought Office Home and Student 2007. I was trying to help him on some basics but am totally frustrated with all of the complicated buttons, icons and other things way to advanced for him. I am used to the old reliable "File, Edit, ...
|
| Arrow keys moving opposite direction | 19 Sep 2007 19:05 GMT | 4 |
Everytime I try to move through the cells with the arrow keys the cursor actually moves in the opposite direction I tell it to. For example, I hit the left arrow key and the cursor moves right! Has anyone ever seen this before?
|
| hide or unhide rows with button | 19 Sep 2007 19:03 GMT | 13 |
I want to group rows together and have a quick expand/collapse button on the sheet itself. I see the group/outline function but do not like the display of the expand/collapse in the left side of the rows.
|
| Trial version of 2007 | 19 Sep 2007 18:52 GMT | 6 |
Does anyone know if the Trial version of Office 2007 can co-exist with an earlier version of office? I currently have 2003 Pro and would rather not have to re-install it if I don't want to stay with 2007 at the end of the trial period.
|