Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Time Sheet
- Has anyone any idea how to calculate a timesheet where the total hours for the month are in the format "111:00" and this is reduced by formula after deducting the daily workinjg day???? PLEASE HELP - I am getting too thin on top for thisLet me first see if I...
- Tags: bjjhome.bt@..., cell, reference cell
- Q&A 2005-02-21
Additional Resources
- Excel error
- When i copy cells that have an absolute cell reference using autofill i receive green auditing triangles in the top left corner of each cell that has the answerthat has been copied to. It says there is an error howvere the answers are correct...any ideasDepending on how you set...
- Tags: absolute cell, cell reference, Lord Foul, Microsoft Excel, software
- Q&A 2005-03-15
- Any Excel Gurus Out There?
- hello all, is it possible to reference data from a merged cell into a single cell? and if so how? whenever i try it i get #VALUE in the single cell. any help with this would be greatly appreciatedre: merged cell referenceIf you're getting #value in the single cell, you...
- Tags: Microsoft Excel, hull_max@..., cell, single cell, merged cell
- Discussion threads 2007-07-11
- How can I sum by referencing a blank cell as the starting point to sum?
- I am trying to sum contigous cells but separated by blank cells. I use the blank cell as a reference pt.e.g.a1 = blanka2 = 2a3 = 4a4 = 7a5 = blanka6 = 2a7 = 5a8 = 3a9 = 10a10 = blanka11 = 7a12 = 9a13 = 20a14 = 35a15 =...
- Tags: blank cell, cell, alex.austriaco@...
- Discussion threads 2007-01-30
- Moving data in Excel
- I have an excel spreadsheet template with multiple formulas. Users do not access the formulas but they have a horrible habit of dragging the bottom row of data to the top and then filling down when starting a new form. This throws everything out as now the last formula is...
- Tags: Microsoft Excel, damian.murphy@..., cell
- Discussion threads 2007-10-03
- Build summary sheets quickly with Excel's Paste Options
- Is this a worthless idea?Maybe I'm missing something, but when I want to link cells, I start with "=" in the receiving cell and click on the cell to be linked or type in the address. The article requires more steps and has the added disadvantage of making the...
- Tags: BDAHNE@..., cell, excel, hardware, Microsoft Excel, Paste Options
- Discussion threads 2005-09-28
- Autofill a spreadsheet
- I have a spreadsheet I send out as a letter and whos reference number ascends chronologically. This reference number is shown on the form in a cell, say E4. I want to be able to type in the reference number on a blank template of the letter and...
- Tags: PRODUCTIVITY, jason-debaugh@..., reference number, spreadsheet
- Discussion threads 2007-06-16
- excel names
- Is it possible to use as a reference to a named cell the contents of other cells?Cell A1 has been named as "lt", and A2 has lt as cell content. May I use in A3 a formula such as =UnknownFunction(A2) to get the contents of cell A1?Thanks.=INDIRECT(A2)This is the one...
- Tags: cell
- Discussion threads 2004-11-10
- Using an Excel Ref as a filename link to other data to display
- I have a database set up in Excel were I have many excel workbook files One for each serial numbered itemwhere I keep track of important information about that item. I also have an overview sheet that lists each serial number in column A followed by important information pulled...
- Tags: Jimboni@..., workbook, cell, Microsoft Excel
- Discussion threads 2007-04-09
- Excel File data transfer from another Excel File
- How to transfer excel cell data from one excel file to another excel file.Link to another Excel workbookOpen both workbooks and make sure the destination workbook which will contain the link to the other workbook, is saved. Select the cell you want to link from. If you want...
- Tags: workbook, Microsoft Excel, qfaisala@..., software, programming, visual basic, cell
- Discussion threads 2007-02-05
- Excel help
- How can I reference link, from an Excel 2000 cell, the last used cell in a column.For example, a spreadsheet has rows of entries of debits and credits. A new balance is calculated in the Balance column for each row. In another sheet I want to reference the...
- Tags: CountA, Microsoft Excel, skat, software
- Q&A 2005-01-04
- Excel formula multiply by single cell
- I have a long list of values to apply a multiplier to. Rather than copy the value down the entire column, so it exists in each row, I thought there was a way to select the row value and multiply it by the common multiplier. I thought it might...
- Tags: cell, Aqusenu, software, Microsoft Excel
- Q&A 2006-03-22
- Data entry validation in Excel
- I am currently working on a spreadsheet in Excel that is a shared file.My problem is that some users never check the cell they are entering data into and that data will not be in a range I would like to specify.... i.e. I want them to start entry on...
- Tags: cell, data entry, Microsoft Excel, programming, Steve_ald@...
- Q&A 2006-01-17
- 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
- How do i highlight the active cell in Excel?
- Is there a way to highlight the active cell in excel, so that when you click on a cell it shows up in yellow or some other color? I'm not referring to the option to use the paint bucket to fill the active cell. I want the highlight to disappear...
- Tags: freakyj92@..., Microsoft Excel, active cell, cell
- Discussion threads 2007-10-18
- IF staements in Excel
- I have a spreadsheet, which has a cell that is used to total the previous cells in the row. The formula that I am using is as follows, =IF(G2=110,(F2*G2),IF(I2=110,(H2*I2),IF(K2=110,(J2*K2),IF(N2=11,(M2*N2),0)))). The first 2 IF-statements [for G & I] return the value as calculated, but the last 2 [K &...
- Tags: cell, Excel 2000, Microsoft Excel, peetree, software
- Q&A 2005-09-01
- Help with Excel
- Hello,I'm creating a template in excel. In column A i have the month (Jan, Feb...) and in Column B the expenditure. But I still cannot find a formula to sum in a new cell the expenses that correspond only to January, and in another cell just the expenses of february...
- Tags: sacf14@..., Microsoft Excel, cell, Column B, SumIf
- Discussion threads 2007-06-14
- Excel 2003 Hyperlink
- I have a spreadsheet where I have many columns, okay? Now I have used the EDIT HYPERLINK and selected PLACE IN DOCUMENT where I enter in a cell. So far with me? Now what happens is when I add new rows, say dozens of new ones, the links still work...
- Tags: cell, BorgInva, software, Microsoft Excel
- Q&A 2006-09-05
- 10 keyboard shortcuts for speeding your work with Excel data
- Which Next Cell?Nice collection of keyboard shortcuts, but the first one input and move to next cell has two shortcuts, depending on the direction of input:Type + Enter takes you to the next cell DOWN;Type + Tab takes you to the next cell RIGHT.When inputting across, using TAB to...
- Tags: Microsoft Excel, keyboard, MJGunther, cell, keyboard shortcut
- Discussion threads 2007-10-10
- Excel adding information from one cell to another cell
- I have three different cells with words in them and i need to add them all into one cell. Is there a formula for this?examplecell a1 says happya2 sada3 madi want my end product to becell a1 saying happy sad mad thanks.
- Tags: Microsoft Excel, happy_murray@..., cell
- Discussion threads 2007-05-14
- << Previous
- page 1 of 1
- Next >>
