1 Resources for

spreadsheet cell

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Multiple Entry Spreadsheets: The idea of multiple-entry spreadsheet cells borrows from 700-year old idea: double-entry accounting. The idea, when applied to the domain of spreadsheets, has two parts - embrace dependency cycles change the semantics of dependency cycles, and allow multiple formulas in a spreadsheet cell. To make multiple-entry spreadsheet cells work, it...; Tags: Author, Spreadsheet, Spreadsheet Cell, Productivity; White papers 2006-08-03

Additional Resources

Excel Spreadsheet help: I am trying to find a way to take information from a table in one spreadsheet and populate another cell in another spreadsheet. Can this be done?; Tags: PRODUCTIVITY, 1bravesfan@..., Excel spreadsheet; Discussion threads 2007-07-13
Excel Spreadsheet Formatting: Is there a way to cause a cell in a spreadsheet to blink when a certain condition is met?You might try herehttp://www.cpearson.com/excel/BlinkingText.aspxYou would then have to link your cell condition to trigger the procedure.It's probably easier to use conditional formatting and just change the font (Red Bold, etc) to indicate...; Tags: topgun@..., Excel spreadsheet; Discussion threads 2007-08-23
Creating addressable fields in excel using hyperlinks: I would like to know if I can some how use hyperlinks in an excel spreadsheet to represent the cells addressable cells.For instance, create a hyperlink to take me directly to cell A1 in the spreadsheet when I click on the URL. I would like to have the excel...; Tags: Microsoft Excel, pawint27@..., cell; Discussion threads 2007-10-23
Excel unwanted arrows in spreadsheet: I cannot get rid of a series of arrows which appear next to a row of cells in a spreadsheet. I have tried everything I can think of (cut, delete, edit cells etc). When the arrow is clicked it highlights, but after that it does not respond to any command...; Tags: arrow, cell, whytock@..., software, Microsoft Excel, spreadsheet; Q&A 2006-04-12

Bulk File Generator for Excel (exe): This Bulk File Generator utility allows a user to export a selected range of cell data from within any spreadsheet to either a new file, overwrite an existing file, or overwrite all the files within a selected directory thus retaining all the original file names and extensions (Bulk File Generation...; Tags: Data, Microsoft Excel, File, Spreadsheet, Cell Data, Productivity; Software downloads 2008-01-18
EXCEL - Macros: I have a filtered list in an excel spreadsheet and want the macro to move down one visible cell. the move is from the row where the filter lies to the first visible filtered row. b/c the first visable row changes all the time i need to move...; Tags: JimTobin2@..., Microsoft Excel, cell; Discussion threads 2007-07-29
Excel 2003 - Cell format problem in application: Using Excel 2003. Cell is formatted as number. There is no formula applied to the cells. User enters a number and it is automatically divided by 100. This happens in every excel spreadsheet,new or old. Number goes in ok if the cell is formatted a; Tags: excel, software, lynn@..., Cell, Microsoft Excel; Discussion threads 2006-12-15
ms excel: hello sir, iam working as an accountant in cardiac scan centre.I want to know about the links in ms excel i.e links between two different spreadsheets e.g. Spreadsheet and spreadsheet 2. I want to make changes automatically when i...; Tags: PRODUCTIVITY, clemy_everonline@..., spreadsheet; Discussion threads 2007-10-03
Firefly Excel Dashboard (msi): Excel Dashboard is designed to simplify the creation of complex Excel spreadsheets that require data from a variety of different sources. The key feature is how it abstracts the spreadsheet down to the cell level. The data in each individual cell can be populated from a SQL query of unlimited...; Tags: Dashboard, Spreadsheet, Cell, Excel Dashboard, Microsoft Excel, Productivity, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management; Software downloads 2008-01-16
AutoTable for MicroStation Excel (exe): AutoTable is designed to provide MicroStation users a more convenient way working together with Excel. You can import Excel spreadsheet into MicroStation and modify it with Excel at anytime. Besides, you can update table to synchronize it with the original Excel spreadsheet.Version 3.33 can reset the last cell in Excel...; Tags: Excel Spreadsheet, AutoTable, Microsoft Excel, Microsoft Office, Office Suites, Software; Software downloads 2005-12-28
Sheet Reference (Variable) in Formula: I have a spreadsheet that has each month on a tab. The current month beginning balance is the previous month ending balance. Rather than having to type the sheet name into each beginning balance formula, I would like to type the sheet name into one cell on the...; Tags: cell, jh46, software; Q&A 2005-11-17
Prevent an Excel spreadsheet from displaying preliminary results: Use IF-function instead to control cell contentsNice tip, but in this case I would prefer using the IF-function to keep the contents of the output cell empty untill all counts have been received, I.e. I would use in cell E9 the following function:= IF(COUNT($E$4:$E$8)=5,SUM($E$4:$E$8),"")Reason: in this case the essence is...; Tags: cell, $E$4:$E$8, excel, gerard.de.graan@..., hardware, Excel spreadsheet; Discussion threads 2006-05-25
Add the Watch Window toolbar to your Excel spreadsheet: Want more Excel tips and tricks? Automatically sign up for our free Microsoft Office Suite newsletter, delivered each Wednesday! IT pros often use Excel worksheets to track what happens toa certain cell when changes are made to other cells. Pre-Excel 2002, if thecell you were monitoring moved off the screen...; Tags: cell, Excel spreadsheet, Mary Ann Richardson, toolbar, Watch Window, Watch Window Toolbar; Technical articles 2005-03-15
ACME Quick Comparator (exe): Open two Excel spreadsheet files and click on the compare button. The program does a cell by cell comparison between the two sheets and highlights any differences in blue so that they are easy to spot. You can optionally limit the column range to be compared and enable comparisons of...; Tags: Cell, Productivity; Software downloads 2005-10-19
Auto Adjusting Row Height for Non Static Data: Hello Everyone.I have a nightly spreadsheet that managers fill out as part of their end of day process.Every morning my staff prints the worksheet for that day and goes over the report. My problem is that the column height is restricted. I cannot get the page to print with the...; Tags: PRODUCTIVITY, binarywasp@..., spreadsheet; Discussion threads 2007-08-01
Integrating Automated Test Generation Into the WYSIWYT Spreadsheet Testing Methodology: This paper presents an automated test generation methodology for spreadsheet languages. The authors' methodology is driven by the end user's request, allowing the user to generate test inputs for a specific du-association or cell, or at the whole-spreadsheet-level. This methodology is tightly integrated with the highly interactive spreadsheet programming environment,...; Tags: Methodology, Author, Spreadsheet, Productivity; White papers 2006-04-01
Excel: Shared a workbook and now spreadsheet will not calculate: I have a sorce spreadsheet for which another sheet is linked to pull data. I shared the workbook which may or may not be part of the problem. When I make formula changes in the workbook, the formulas are copying and show in the cell, but the calculation...; Tags: PRODUCTIVITY, Microsoft Excel, cmikesh@..., workbook, cell, spreadsheet; Discussion threads 2007-10-30
How to sort a single column in Excel without disrupting the rest of the spreadsheet: We tend to view spreadsheet data as a whole, and that's as it should be. Seldom does a single column of values mean much to us without some related data to define it. Together, seemingly useless values become information. In fact, that's the definition of data and information. Information is...; Tags: Information, Column, Microsoft Excel, Spreadsheet, Cell, Productivity, Susan Harkins; Blog posts 2008-01-19
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

<< Previous
page 1 of 1
Next >>

TPG Power Checklist: Troubleshooting TCP/IP: TCP/IP, the protocol powering Internet, Intranet and Extranet communications, provides critical functionality withinmost every organization. Numerous ...; Buy Now

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now