which keyboard shortcut would render all formulas in a worksheet visible on microsoft excel 2003?
103502
hold alt key and \nhit t then \nhit o then \nhit r then \nrelease alt key then\nhit return.\n\nsame procedure to get back to original format.
967626
EXCELL - Spreadsheets
801228
I'm using Excel 2003. This solution should work for any recent version of Excel. \n\n1. Select the entire worksheet. You do this by either 1) clicking on the "select all" button, which is located between the labels for row 1 and column A (the very top left corner), or 2) press "Ctrl+A".\n\n2. On the top bar menu, choose Data/Sort. Choose the column on which you want to sort. (It almost doesn't matter for your purpose, but if you have a preferred order you might as well choose it now.) \n\nBe sure that the order is Ascending for now, even if you want it to be Descending in your final sort.\n\nIf your worksheet has a header row, you'll want to select the "Header row" radio button. If you choose this option, your header row (row labels) will stay at the top of your sort. If you choose "No header row," the header row labels will sort with the rest of your data.\n\n3. Click "OK." If the sort order is Ascending, your blank rows should be at the bottom of your list. If you had chosen to sort in Descending order, the blank rows would be at the top and you'd have to do a follow-up step of selecting the blank rows and deleting them. \n\nHope that helps.
990843
You can call it from VB6 using\nWorksheetfunction object\nthis object has all the functions in Excel\n\nenjoy\n\nXLMan
529006
I use MS Excel.  I use each worksheet in a workbook for the different months of a calendar year.  I copy the previous month's rows into the current months and erase the amounts due, dues dates, etc, and put in the new ones, then add new rows as required.  I use a gray font color for rows that don't apply, and use a red font for unpaid items.  As I pay them, I convert them to green.  You can use summary cells to add stuff up.
665752
http://www.yrbktips.com/nav1024.cfm?cat=5&subcat=26&subsub=3&method=display&id=437\nhttp://wiki.scribus.net/index.php/InDesign_Shortcuts\nhas a very comprehensive list for CS
557136
Here's some tutorials I found\n\nhttp://www.bcschools.net/staff/ExcelHelp.htm\nhttp://www.bcschools.net/staff/WordHelp.htm\nhttp://www.baycongroup.com/excel.htm\nhttp://www.techtrainteam.com/services/olt/office2000/xls.html\n\nYou can also google it though, and make use of pressing the F1 key for help which is very usefull.\n\nGood Luck! ^_^
1008778
In a short cut?\n\nSimply retype the "run" line... and resave or rename the shortcut.
943817
[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?
481237
Conditional formatting. \nSelect the columns/areas\nGo to: Format, Conditional formatting. \nSelect 'Formula is' in first drop down, in data entry, type in =MOD(ROW(),2)=1\nclick format\nselect patterns\nselect a background color\nclick ok\nclick ok\n\nTo get it in a button, start recording a macro, do the steps listed above, add a button from the forms toolbar, link the button to the macro you just recorded.
1185281
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.
184494
the short cut to see all the formulas. press and holt the "ctrl" button and then the "`" button. pressing it back and forth will reveal the formulas making it easier to check. also the auto fill which lets u copy and paste formulas together. on the bottom right corner of a cell it will turn into a pluss function. scroll that down to apply all the formulas from the previous cell.
1086093
Yes, as the others said, go into the "Define Name" Dialog box (which you can access either through Insert>Name>Define or through the keyboard shortcut "Ctrl+F3"). In there you'll see all the named ranges defined and so you can see if they are in that worksheet or somewhere else.\n\nAnother possible solution is to use Edit>Go To and then select the named range you want to locate.\n\nAnother very neat feature is to use "zoom out"  and go below 40% (Ctrl+Mousewheel Down) and the named ranges will become apparent and labelled (as long as they're not dynamically defined ranges).\nThis is incredibly useful when you have lots of named ranges because you can see them all at once.\n\nYou might also want to check if your spreadsheet contains links to other worksheets, because if that's the case, it can create problems when you send that spreadsheet to other people that don't have access to the linked document.\n\nFor this, go into "Edit" Menu and choose "Links". If it's grayed out, it means there's no link, and you're clear.
325795
I don't think its an option from the menu. Ofcourse, VBA script can be written for that to happen.
1107100
Select the cells that you want this special formatting applied to, then select the 'Conditional Formatting' option from the 'Format' menu at the top of your screen.\nIn the 'Conditional Formatting' wizard, select 'Cell Value Is', then select 'Equal to', and in the third box type the letter 'x' (or whatever value you want).  Then click the 'Format' button and choose the formatting effects you want applied when your chosen value is entered.  Then just click 'OK' until done.  Best of luck!
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
1079681
1) Open the worksheet where you want to add an ActiveX control \n\n(ActiveX control: A control, such as a check box or button that offers options to users or runs macros or scripts that automate a task. You can write macros for the control in Microsoft Visual Basic for Applications or scripts in Microsoft Script Editor.). \n\n2) Display the Control Toolbox: point to Toolbars on the View menu, and then click Control Toolbox. \n\n3) Click the control you want to add. \n\n4) Click on the worksheet at the location where you want to place the control. \n5) Drag the control to the size you want. \n\n6) If you're adding a check box, text box, command button, option button, list box, combo box, toggle button, or label, enter the text you want to appear on the control. \n\nHow?\n\n(Right-click the control. \nPoint to the name of the object on the shortcut menu (for example, CheckBox Object). \nClick Edit. \nEdit and type the text. \nWhen you're finished, press ESC. \n\n7) Set the properties you want for the control: right-click the control, and then click Properties on the shortcut menu.\n\nFor information about the properties, press F1 in the Properties dialog box to display the Microsoft Visual Basic Help for Microsoft Forms.\n\n8) Do one of the following: \n  <<a>> Add Visual Basic macro code for a control to be used in Excel\n\n(Right-click the control, and then click View Code on the shortcut menu.\n\nIn the Visual Basic Editor, write your macro code.\n\nFor information about writing macro code, see Visual Basic Help.\n\nTo quit, click Close and Return to Microsoft Excel on the File menu.)\n\n<<b>> Add a Web script for a control to be used on a Web page\n\n(Click the worksheet anywhere within the data that will go on the Web page.\n\nOn the Tools menu, point to Macro, and then click Microsoft Script Editor.\n\nIn the Script Editor, write your script, using the control ID to handle events for the control.\n\nFor information about developing Web scripts, click the option you want on the Help menu in the Script Editor window.\n\nTo return to Excel from the Script Editor, click Exit on the File menu.)\n\n9) To quit design mode and enable the ActiveX control, click Exit Design Mode