Sponsored White Papers, Webcasts, and Downloads
TechRepublic 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
Additional Resources
- 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
- Use named ranges for absolute references in formulas
- There are a number of ways to design absolute references in formulas. For example, in an order form, you might use a Lookup function to determine the shipping charges from a shipping table, as shown here. If you use the cell range for...
- Tags: Formula, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-06-10
- $600 budget for computer...best possible for this is?
- Given an absolute budget of $600 which must include taxes and shipping, what is the /absolute best/ machine possible?Note that this is not an OS-specific question. I'm asking for the absolute best including OS and enough software to make the mach
- Tags: hardware, linux, software, windows, Raymond Danner, Dell Computer Corp., Hewlett-Packard Co., computer, operating system
- Discussion threads 2006-11-27
- Excel Change Absolute References to Relative References and Relative to Absolute in Multiple Cells (exe)
- If you want to know how to change multiple excel cells in absolute format into relative format, or from relative format to absolute format, then this software is for you. Simply select a block of MS Excel cells that you wish to change. Decide further what should be changed (block...
- Tags: Format, Reference, Cell, File Splitter, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2008-06-02
- 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 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
- 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
- Download our sample Excel ledger to learn about absolute cell references
- Don't go nuts trying to figure out Excel absolute cell references. Instead, read this article to find out how to create and use this handy Excel feature. We even provide a sample ledger for you to download as an example.My previous article, "See how our sample spreadsheet uses absolute cell...
- Tags: Bob Johnson, cell, absolute cell reference, cell reference, Microsoft Excel
- Technical articles 2001-04-25
- 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
- Absolute Time Server (exe)
- Absolute Time Server is a full-featured time server, which works as WinNT service and is fully RFC-868 and RFC-2030 compatible. Absolute Time Server acts as a background process, has very low system resources consumption, and it can be started before user logon. Version 4.4 build 256 includes unspecified updates.
- Tags: Absolute Time Server, Microsoft Windows NT, Servers, Operating Systems, Microsoft Windows, Software, Hardware
- Software downloads 2007-11-09
- Absolute Key Logger (zip)
- Absolute Key Logger records all keyboard keystrokes into a log file, so that you can use this data later. You can use Absolute Key Logger to: restore lost typed text; find forgotten passwords and logins just look through the log file to find what you need; have full control of...
- Tags: Keylogger, Computer, Absolute Key-Logger, Productivity, Keyboards, Hardware, Peripherals
- Software downloads 2002-10-23
- 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
- Locate any Cell Phone/Cell Phone Number!
- Because of the demand of Cell-phone, antennas are everywhere in our society. After few days of research, I found out we are not only can be monitor our everyday lives by Credit Card but also with our Cell-Phone (# of People owned a cell-phone is much higher than Credit Card.)...
- Tags: Cell, cell phone, GPS, mak1515@..., networking, telephone, wireless
- Discussion threads 2006-09-14
- Excel 2003 Hyperlink Issue
- I'm trying to hyperlink a single work in a sentence that is all within one cell. So far, I'm only able to link to the entire cell/sentence. Example: Can techrepublic answer this question? With techrepublic underlined/highlighted as the hyperlink. All within a single cell. ...
- Tags: cell, matthewhaggerty@..., windows, 2003, excel, hyperlink, Microsoft Excel
- Discussion threads 2007-01-31
- Absolute Delete (zip)
- Absolute Delete is a privacy tool to securely delete your traces left while surfing: cookies, cache and history. It can also delete your deleted items, temporary files, recent documents and your search history. When you delete a file, the link to the file is removed on your computer but the...
- Tags: Data Recovery, Tool, Absolute Delete, Productivity, Storage Management, Databases, Storage, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2004-09-20
- 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
- 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
- Convert Cell References Utility for Excel (exe)
- This routine allows the user to convert the cell references of the formulas within the selected range of cells to any form of absolute reference. This can be useful in situations where you have two or more sheets linked together via formula functions. Keep in mind that you can do...
- Tags: Microsoft Excel, Cell
- Software downloads 2005-10-04
- Absolute Database (zip)
- Single file Delphi database with comprehensive SQL support, strong encryption, BLOB and multiuser mode support. This BDE alternative is fully compatible with standard and third-party database components and reporting engines. Absolute DB does not require any DLLs, drivers or updates. Absolute DB is written completely in Delphi, full source code...
- Tags: Borland Delphi, Storage, Programming Languages, Databases, Development Tools, Hardware, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2007-10-30
- << Previous
- page 1 of 1
- Next >>
