I though it is very useful if there is a short cut key that I can switch working between worksheet. Just like windows, you can switch the windows with "Alt + Tab", is there any short cut like that to switch working on worksheet in Excel?
199605
CTRL  +   PageUP\nCTRL  +   PageDOWN\n\nthis is perfect.........  \n\nEnjoy.........
336008
To Elaborate on the Freeze Panes idea....\n\nHighlight the cell that would be below and to the right of the panes you would want to freeze. For instance, if you want to freeze the the first row and the first column, place highlight cell B2. Then click on Window and select Freeze Panes.\n\nPlay with is a little and you will see how it works. I use it ALL the time, even for spread sheets that may be small emough to see completely on the screen... but you never know, it may grow.
374704
Sometimes there are hidden keys.\n\nTry [Shift] + F4  (should be F16)
72620
Firs question would be:- What version of Excel?\nAssuming you have Excel 2003.\ncheck your settings. \ntools->options->calculation\nmake sure that the "automatic button" is checked and then the "Recalculate before save" is checked. \nhope that helps.
354654
Yes, it is possible, Excel always update all links every time you open a work book.
675681
Goto Tools Menu > Macro > Visual Basic Editor (Alt + F11)\n\nType this in exactly...\n\nPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)\n    Sheet1.Cells(1, 1) = Sheet1.Name\nEnd Sub\n\nSheet1.Cells(Row, Column)\nRow = Row Number\nColumn = Column Number (A = 1, B = 2, C = 3, etc)\n\nThis will change the text in the cell everytime you change the name of the sheet and click anywhere in the sheet.
133905
This may be overly symplistic, but if it were me, I'd open up both files at the same time and just link from one file to the other as if I were linking between worksheets.  That way excel creates the full path for you.  You could do that for one cell, then do a search and replace for all of the others.
523552
[EDIT - DELETED A WHOLE BUNCH OF TEXT]\n\nthat kind of thing is complex to create in a macro form, normally the kind of thing that you'd pay someone to do because i'd imagine it's easily a couple of hours work to write all the code, test it, iron out bugs etc. there *may* be a built in function in excel to do something like this but i wouldn't have thought so - i'm happy to be proved wrong:\n\n----found on t'internet----\nA1:A10 (your list of values)\nB1:B10 (leave blank)\nC1: =A1*B1 (copy thist fomula down through to C10)\nC11: =SUM(C1:C10)\n\nNow to use Solver....\nTools>Solver\nSet Cell: C11\nEqual to the Value of: 1173.76\nBy Changing Cells: B1:B10\nSubject to the Constraints....\n(click the add button and constrain B1:B10 to Binary)\nClick [OK]\nClick [Solve]\n\nExcel will toggle cells B1:B10 between 1 and 0 until it comes up with a combination that sums to 1,173.76\n----end of instructions----\n\nit depends on the setup of your spreadsheet - if it's one huge page that's a jumble of undistinguishable invoices with no reference to who the invoices belong to, it means manually checking the results of the macro for the set of results that applies only to one 'customer'. ideally you'd want a seperate sheet for each customer and then the macro or above method can be ran on whichever sheet/customer the cheque is from.\n\ni dunno about other people on here but i wouldn't spend hours of my time creating such a thing for the sake of 10 points which aren't really worth anything - i CAN tell you that if the above method doesn't do the job that it'd mean creating a loop that will add up every possible combination of totals from the sheet then comparing it each time against the grand total until it gets a 'hit'.\n\ni can't imagine this kind of sorting being practical for huge amounts of figures, probably a list of 20 at most because you could get into some big big processing time otherwise.\n\ni would be interested in hearing anyone elses ideas about doing it?
571940
Yes Alt + F4. To switch between them is Alt + Tab. Hope this helps. Rock.
24518
Open your Excel, go to Help and learn how to freeze and/or unfreeze panes. Great aid to your work.
35813
Hi.  Like you, I too miss the days of the Lotus macros/scripting.  Lotus macro language was far simpler to understand.  It was so intuitive.  I tried writing scripts in Excel the first few years after Microsfot conquered the office space (~1994-1998), and after hours upon hours of trying to understand its heiroglyphics in an attempt to create a macro for a repetitive task that would have taken me ~60 second to write in Lotus, I gave up and have since only been tempted into this highly cryptic world on a handful of occassions.   I have little idea still of what I am doing in teh Microsoft Excel Macro Edior.  However, I think I do at leats kmow how to bang out something to do what wish.  Try this:\n\nSub Macro1()\n    var1 = ActiveCell.Value\n    ActiveCell.Value = "'" & var1\n    ActiveCell.Offset(1, 0).Select\nEnd Sub\n\nI think it does exactly as the keystrokes you described does, except it sounds as though you may want one more "DOWN" command, i.e., "ActiveCell.Offset(1, 0).Select".\n\nHope this helps.
508501
I know Excel inside & out...and I would love to help you, but I really cant understand what you are asking for.\n\nSo - you are trying to find the picture. OK. Pictures are handled as graphics on a different layer. They are not tied directly to cells or formulas. It should be clearly visible\n\nTry this: select all (Ctrl-A) go to the edit menu, select Clear > Formats. Now, in the format menu,  row > unhide, row > autofit, and Column > unhide, Column > autofit.\n\nThat should open up your entire worksheet. If something is there, you should see it.
53592
This is cool.  Use the Print Area function.  From File menu, choose Print Area.  Choose to clear it, first of all.  Then highlight all the portions of your spreadsheet that you wish to print.  \n\nYou can highlight sections that are not next to each other (noncontiguous) by using the CTRL key while blocking w/the mouse.  So, for example, use the mouse to highlight columns A and B.  Let go of the mouse button and see that those areas are highlighted. Without doing anything more (don't click anywhere, don't use an arrow key, etc.), press down the CTRL key and then click on column D. You will then see that columns A,B and D are highlighted (but not C).  You can choose your own print area in this fashion.  \n\nAfter you've gotten your print area highlighted, go to the File menu, choose Print Area, and choose Set Print Area.  Now only the things that were highlighted are going to print.  You can see this on the print preview screen. \n\nEnjoy!
524935
in MS word the shortcut is ALT + 0241 for lower case, and ALT+ 0209 for uppercase. However, if you're in a word document and using it a lot, you can define your own shortcut key. \n\nOtherwise, change the language setup of your keyboard in the control panel. If you're really desperate, copy and paste from below.\n\nñ Ñ
436068
To solve your Excel part of this, create a section break before and after the Excel section.  Make this an unprotected section.  In Excel 2003 and 2002, I believe, when you protect the document through the menu system, the taskpane will pop up.  Under Editing Restrictions, select Filling in Forms.  There should be a link called Select Sections.  Now, select the sections you want protected (the ones with the drop downs) and unselect the ones you don't (the Excel).  I believe there is something similar feature in previous versions of Word, but I don't remember the exact wording.
84820
It allows you to switch between all of the applications you have running.  It is important to HOLD the Alt key.. while you only TAP on the Tab key... that will allow you to easily select the application you need.  This is great to use if your computer is freezing and you lose mouse functionality.
488748
You can do this in two ways:\nOne: Using Macro.\nTwo: Using functions\n\nI prefer using the option Two as a start.\nNow, I need you to focus with me...\n\n- Enter your two values "Default" and "1000" in two cells (Say Y1:Y2)\n- Create a Combo Box using "Forms Toolbar", that is go to View > Toolbars > Forms\n- The toolbar will show and you can create a combo box from it.\n- Right click on that combo box and go to Properties > Control, select two cells that have your values (Default and '1000') Y1:Y2 as the Input range, select a cell to link this combo box to (Say Z1).\n- Now click ok\n- Where ever you select a value from this combo box, Z1 cell will change to 1 or 2.\n- Your A1:E50 cells need to have this function, need to be changed. I have a question here (Do these cells have a numbers (A) or coming from a formulas (B) ?)\nA) If the A1:E50 cells have all constant numbers, I prefer you choose another range to put this formula in.\nSay G1:K50, put in G1 this formula and copy and paste to the others:\n= CHOOSE( $Z$1, A1, A1/1000)\nB) If they have a formula, just change it to this formula:\n= CHOOSE( $Z$1, [your old formula], [your old formula] /1000)\ndon't forget to change the value [your old formula] to your old formula on each cell.\n\nNeed more help? or would like to see the Macro section?\nmail me here\n\nEnjoy my profile, I am VBAXLMan