Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Dynamic link
- How do I set up a dynamic link between 2 excel sheets.Type an = sign and then switch to the other sheet and click on the appropriate cell. It will look like:=Sheet1!A1/You can also name the range. Select the cell and type a name in the name box to...
- Tags: cell, demo@..., Formula Bar, software
- Q&A 2004-12-02
Additional Resources
- Quick access to Excel formula bar via keyboard
- A quick keyboard shortcut puts you right into the Formula bar. You don't need the mouse at all! by Susan Harkins
- Tags: Mouse, Formula, Keyboards, Microsoft Excel, Mice, Microsoft Office, Hardware, Peripherals, Office Suites, Software, Susan Harkins
- Blog posts 2008-07-25
- Excel ANNOYANCES: Formula ANNOYANCES
- Transforming the data in the worksheets using formulas is what Excel does best. What could be annoying about that? Lots! Take one horrible example: consider what happens when one creates a formula in one cell and copy it to another cell. If one doesn't build the formula just right, the...
- Tags: Formula, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software
- Book chapters 2004-12-08
- Streamlining Internal Functions
- British American Racing BAR belongs to the fast-paced world of Formula One motor racing. As a relative newcomer to this industry, BAR had a sole focus: winning the Formula One World Championship. With this goal in mind, a vital part of the company's strategy over the past year and a...
- Tags: SAP AG, British American Racing, Enterprise Resource Planning (ERP), Strategy, Team Management, Channel Management, Enterprise Software, Software, Management, Marketing
- Case studies
- Formula not working always in excel suing VBA
- Hi alli've used a formula something likeactivesheet.cells(row,col).formula = "='C:Documents and SettingsAdministratorDesktop[sdfsdf.xls]Sheet1'!$A$12"this line will be in a loop , iterating for a couple of rows.But what is happening is, the formula works fine for most of the cells,but for a couple of a cells, ....instead of the result, the formula itself...
- Tags: redvamsi@..., Microsoft VBA, cell
- Discussion threads 2007-10-04
- Avoid nested formula errors with Excel's Insert Function dialog box
- Excel's nested formulas option may be useful, but many people find it a challenge fraught with potential errors. Mary Ann Richardson explains an easy way around it: use the Insert Function dialog box. Entering nested formulas manually into Excel can often lead to syntax and typing errors. For...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Click OK, cell, Microsoft Office Suite Excel Tips Newsletter, Formula, MIN, Office Suites, Software
- Technical articles 2006-12-19
- Sum cells in as yet uncreated worksheets
- HelloI am trying to reproduce a formula I found in a locked worksheet. Copying and pasting formula has not worked.Formula is =sum('Day (0):end'!d16).The formula is designed to add values automatically when new sheets are added. If it helps am adding new sheets via a macro.Please help
- Tags: morrison_paul002@...
- Discussion threads 2007-07-24
- EXCEL formula help
- I need to understand why excel is not allowing the same formula, that exists both above and below... I am only doing a sum of 7 cells on the same row? but if I enter the formula even with prens, or begin the formul with a 0, or even backward,...
- Tags: dawn.prentice@..., Microsoft Excel
- Discussion threads 2007-07-01
- iFD Formula (exe)
- iFD Formula is a compact powerful utility for Pocket PC that allows you to work with a sufficient set of formulas (mathematical, physical, and electrical). You can also add your own formulas where you can add new formula categories, new formulas and their parameter description. The calculation is easy and...
- Tags: Formula, Calculation, iFD Formula, Pocket PC, Handhelds, Operating Systems, Desktops, Hardware, Software
- Software downloads 2006-02-02
- A formula to return a formula in Excel???
- I have a situation in which several hundreds of sheets in the same workbook require the same formula to be enterred. Is there a way short of building a function that I can enter the formula once in a 'Legend' sheet, and then use a reference to that cell in...
- Tags: bubba_barnett@..., Cell, Cell A1, Sheet1
- Discussion threads 2007-04-24
- Excel Formula that doesn't repeat when you use drag and fill
- I'd like to create a formula for a spreadsheet and populate all the line items without having the formula repeat over and over. Someone did it in one of their spreadsheets but would not share how he did it.Thanks,SusanI'm not sure what you mean.Do you want to copy the...
- Tags: PRODUCTIVITY, Microsoft Excel, smdonahue@...
- Discussion threads 2007-06-22
- Formula dragging in excel
- I was just wondering, when you drag a formuladown the page, is it possible to drag only the formula and not the cell format. eg. if there is a formula in a cell which has a border, can you drag the formula to other cells without dragging the cells border??
- Tags: nickl@..., cell
- Discussion threads 2007-08-01
- Do not update formula when inserting rows in Excel
- In Excel, I want to be able to insert a row but NOT update a formula referencing that row. For example in Cell B1 I have the formula =AVERAGE(B3:B33) now when I insert a new row at row 3 the formula automatically changes to =AVERAGE(B4:B34) I want to ALWAYS average...
- Tags: 7s1u7le79ba7089@..., Microsoft Excel
- Discussion threads 2007-05-03
- Formulas in Excel
- I have created a formula in Excel as below: =SUM(IF(Data1!B1:B155=B9, IF(Data1!C1:C155=AD10,IF(Data1!I1:I155 = 2, Data1!L1:L153,0),0),0))But it is not displaying the result in the cell. If i am in the formula and do a F9 Calculate it will bring the correct result through but will make the formula disapear. How can i...
- Tags: feedback, Microsoft Excel, off-topic, simon_sez_it@...
- Discussion threads 2007-01-11
- Copy an Excel formula without changing its cell references
- After having written the formula for instance like=A1*B1/D1To achieve the result of copying and pasting so that the cell references do not change all you need to do is to modify the formula like this=$A$1*$B$1/$D$1now the cell references are ab
- Tags: ASAP Utilities, cell, cell reference, feedback, gbramley@..., Microsoft Excel
- Discussion threads 2006-11-01
- Formula 1 RSS Feed (widget)
- As requested by a Uni friend of mine, I've devised a widget displaying news about Formula 1. Follows the same layout as my previous widgets, and the same credits apply. Formula 1 RSS Feed are proving more popular than expected. This version is the first release on CNET Download.com.
- Tags: RSS Feed, RSS, Internet
- Software downloads 2007-07-23
- jit-xls (exe)
- JIT-XLS Create and print bar codes in Microsoft Excel 97, 2000, 2003. Create Excel spreadsheet cells in your workbooks to automatically calculate bar codes for one or a million other cells or formula expressions. Includes bar codes Codabar, Code 128, Code 39, Code 93, EAN-128, SCC-14, SSCC-18, EAN-13, EAN-8, ISBN,...
- Tags: Bar Code
- Software downloads 2006-04-24
- Copy an Excel formula without changing its cell references
- If you copy a formula from one place to another, Excel will want to readjust the references to reflect the change. However, if you want the formulas to stay the same, Mary Ann Richardson can help end the confusion. When working with a spreadsheet, when you copy a formula...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, cell reference, Microsoft Office Suite Excel Tips Newsletter, Formula, Office Suites, Software
- Technical articles 2006-10-31
- MS Excel
- Is there any possiblity to show the a number of rows in Excel spread sheet by writing code in formula barlike the one we use with autofilter and find what we want.
- Tags: Microsoft Office, pkb_pkb@..., Microsoft Excel, Microsoft Corp.
- Discussion threads 2007-05-28
- transpose w/ formula
- hi everyone,what i want to do is:i want to display the contents of a row on a column, very much like transposing data but with a formula. can it be done?cheers
- Tags: msalvs@...
- Discussion threads 2007-05-23
- << Previous
- page 1 of 1
- Next >>
