MS excel (short cut keys) to switch between worksheet?
444453
CTRL  +   PageUP\nCTRL  +   PageDOWN\n\nthis is perfect.........  \n\nEnjoy.........
743893
Sometimes there are hidden keys.\n\nTry [Shift] + F4  (should be F16)
310068
http://www.openoffice.org\n\nIts spreadsheet program will open an Excel file, and unlike the viewer, you'll be able to edit the data.
495864
click the right key then hit cut or copy then go to your new file then hit paste
1118432
Scroll until you get just the header rows at the top of the sheet (they should be there anyhow). Drag the little bar just above the top arrow on the vertical scroll bar for the workbook, down to below the header rows (the "splitter"). You should now see the header rows, then a thin divider line (the splitter bar) and the rest of your document below that. Now, go to the Window menu and select 'Freeze panes'. Voila!\n\nTo undo this, just go Window->Unfreeze panes.
527797
I have office 2000 pro and when i click on the help, the office assistant shows, i typed in how do i lock a column and this is what i got... \n\nSpecify which cells can be changed after a worksheet is protected\nTo unlock cells so that they can be changed, the worksheet must not be protected. For information about removing protection from a worksheet, click .\n\nSelect the cell range you want to unlock. \nHow? \n\nOn the Format menu, click Cells, and then click the Protection tab.\n\n\nClear the Locked check box. \nNote   After you protect the worksheet, the cells that you unlocked in this procedure are the only cells that can be changed. \n\nTip   To move between unlocked cells on a protected worksheet, click an unlocked cell, and then press TAB.  \n\ni imagine it would be similar in 2003, try the help menu and see if you get a better answer\n\nalso try the links below
1005206
the same way you do it with excel...
431591
Use Microsoft Excel or a slide-rule
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
946611
use the / key near the right shift
720639
You may want to switch between shared and protected workbooks. Go to your Excel's Help and see the difference between the two. It will also help you set the workbook up how you want it.\n\nSHARED-   If you want several users to work in the same workbook simultaneously, you can save the workbook as a shared workbook. Users can then enter data, insert rows and columns, add and change formulas, and change formatting. How to set up a shared workbook.\n\nLimit viewing and editing of an individual worksheet\nWhen you protect the worksheet, the cells and graphic objects that you did not unlock in steps 2 and 3 are protected and cannot be changed.\n\nPROTECTED SHEETS-\nSwitch to the worksheet you want to protect.\n\nUnlock any cells that you want to be able to change after you protect the worksheet.
744410
I use a macro program called Workspace Macro. I recommend Pro version. For $15 more you can get hotkeys and ability to edit macros. You can get more information from http://www.tethyssolutions.com/macro-automation.htm
796028
i wish there was an answer key. i need to do hecka worksheets and crosswords n' sh*t
1105719
In Excel, functions and macros only can do this. Try the functions PROPER, UPPER and LOWER.\n\nCtrl+Shift+A is another Word keystroke for changing case, it doesn't work in Excel.\n\nCheck out:\nhttp://www.mvps.org/dmcritchie/excel/proper.htm#upper
1160354
Open excel. goto tools-->options , on the view tab, deselect the option "startup task pane". Close & reopen excel.\nHope thats what you meant by template help!
523331
You might consider linking an instruction to refresh the pivot table to the Excel event that is triggered when a user jumps from tab to tab. But this would only work if they could be expected to move around in the workbook and not remain on one tab.\n\nFor example, I inserted this code in each excel sheet object. When a user moves to a different tab, I have instructed Excel to refresh a particular PivotTable (which in my system is called "PivotTable2", and happens to be on "Sheet1".\n\nPrivate Sub Worksheet_Activate()\nSheets("Sheet1"). PivotTables("PivotTable2"). PivotCache. Refresh\nEnd Sub\n\n(The sheets refresh command is all part of one line - this yahoo screen may break it on to two lines!)\n\nIf you wanted to use this kind of trigger, then you would need to insert this coding on EACH worksheet object (not the modules of course). If you have many PivotTables that need to be refreshed, then you can write one macro to refresh them, and then call the refresh macro from the worksheet objects. (The refresh macro would be stored in a module.)
959108
There are 3 ways of doing this:\n1 Goto Main Menu:\nChoose: "Tool"\nClick on "track changes" again.\n2. Or press "Ctrl+Shift +E"\n3.At the lowest bottom part of your "word screen" find the three small letters, "TRK" and right click for its options or left click for an immediate change between on & off.