Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 10 obscure Excel tricks that can expedite common chores
- This article is also available as a PDF download.Over the years, each new version of Excel has introducedsome nifty features. However, buried within Excel are lots of cool featuresthat too few users have discovered. If you or your users perform certaintasks every time you use Excel, you'll want to make...
- Tags: cell, column letter, entire worksheet, Jeff Davis, Microsoft Excel, Microsoft Office, Microsoft Word, worksheet
- Technical articles 2007-01-05
Additional Resources
- Keep embedded charts off your worksheet printouts in Excel
- You can print an embedded chart in Excel without its worksheet by simply selecting the chart and choosing File | Print or clicking the Print button, but did you know that you can print a worksheet separate from its embedded chart in Excel? Even if it's a large worksheet, Mary...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, worksheet, Microsoft Office Suite Excel Tips Newsletter, Chart, Office Suites, Software
- Technical articles 2006-04-18
- Vocabulary Worksheet Factory (exe)
- Improve and reinforce the vocabulary skills of your students with challenging and motivating worksheet activities created with Vocabulary Worksheet Factory. With the ultimate in worksheet generation technology at your fingertips, the creation of lesson-enhancing support materials for the classroom will be a lot more enjoyable and a lot less work....
- Tags: Microsoft Windows, Microsoft Windows Vista (Longhorn), Operating Systems, Software
- Software downloads 2007-05-07
- Excel 2000 - Using hyperlinks in IF statements from another worksheet
- I have two worksheets. One has a cell with a validation list followed by a number of cells containing a table of contents list. The other worksheet has 2-4 tables of hyperlinks, which corresponds with the table of contents on the first worksheet. The user can select...
- Tags: Microsoft Excel, irocu26, worksheet, Table B, cell, hyperlink, first worksheet, table of content
- Discussion threads 2007-04-26
- Excel: Formatting Worksheets
- Creating a basic worksheet is only the first step toward mastering Excel. If one plans to print the worksheet, email it to colleagues, or show it off to friends, one needs to think about whether the worksheet is formatted in a viewer-friendly way. A careful use of color, shading, borders,...
- Tags: O'Reilly Media Inc., Microsoft Excel, Microsoft Office, Office Suites, Software
- Book chapters 2005-01-14
- Insert Tab Name into a worksheet
- Is there a way to insert the tab name of a worksheet into a cell in the worksheet itself as a function?See this article:http://www.xldynamic.com/source/xld.xlFAQ0002.htmlCheers.RW Poster rated this answer. This question was closed by the...
- Tags: worksheet
- Q&A 2004-12-30
- How to transfer a hyperlink from the cell a lookup formula locates in Excel
- I have a database in worksheet 2 in a Excel 2007 workbook. In worksheet 1, I have a combo box that lists the project numbers listed in the worksheet 2 database. As a person selects a project, several other cells in worksheet 1 are populated with the data, associated with...
- Tags: Storage, Microsoft Office, dan.pelch@..., cell, database, hyperlink, lookup formula, Microsoft Excel
- Discussion threads 2007-09-20
- Link or Embed an Excel Worksheet
- When one want to create a dynamic link between the content of the document and the content in a Microsoft Office Excel workbook, insert the content as an object. Unlike when the user paste content (such as by pressing CTRL+V), when he or she inserts it as a linked or...
- Tags: Microsoft Excel, Microsoft Office, Office Suites, Software
- White papers 2007-12-01
- date formulas in excel
- i have a cell in worksheet number 1 that has a starting date for the first invoice of 60 subsequent invoices. i need to know how to have the same cell in each invoice calculate the future date based on the sequence of the worksheet. i.e. worksheet #2 would be...
- Tags: cell, invoice
- Q&A 2005-08-19
- My Excel Plug Numbers (exe)
- Many times, when you build your excel worksheet you base your model on plug numbers such as exchange rates, inventory values, and stock prices. Each time that you run your worksheet you plug new values of this plug numbers and analyze the results. My Excel Plug Numbers is an Excel...
- Tags: Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2006-09-26
- Formating an Excel list
- I'm using Excel 2003, I created a list on a separate worksheet, and named the list, then I used Data > validate to apply the list to a series of cells on a separate worksheet. I want to apply a color to the cells or fonts in my reference list...
- Tags: Microsoft Office, rthomas@..., worksheet, Microsoft Excel
- Discussion threads 2007-09-25
- Change your Excel worksheet defaults to fit your working environment
- Default Number of Pages in WorksheetAnother Default I change is the number of sheets or pages in a worksheet. Why open three worksheets when I normally only need one woksheet.1) Select Tools + Options2) Select General Tab.3) Change "Sheets in new Workbook:" setting to 1.4) Select OK button to save...
- Tags: Change, default options, excel, Excel Worksheet, hardware, Microsoft Excel, microsoft office, SELECT, sysadmin-tzone
- Discussion threads 2006-08-07
- Search for worksheet name in Excel
- I am trying to find a way to search for a particular worksheet name if the spreadsheet has many worksheets in the file. Is there a way to do it? I appreciate any help anybody can give me.Thanks!
- Tags: Search, jamesa@..., software, Microsoft Excel
- Q&A 2006-04-05
- excel to .pdf conversion
- I have a user that is experiencing a change that I haven't been able to figure out. When they try to print a document to .pdf it creates a pdf for each page. What she would like it to do is print all pages on one .pdf. Seems simple but...
- Tags: Microsoft Excel, rmurphy@...
- Q&A 2006-03-31
- Excel Look Up
- I want to take 2 worksheets and be able to insert information regarding specific cells from one to the other. 1 worksheet has our inventory items listed and the Quantities used in a given time - the other worksheet has all the inventory item descriptions and data but does...
- Tags: dnelson@..., Microsoft Excel
- Discussion threads 2007-03-28
- Link to 2 diff worksheets same workbook
- I need to create 2 hyperlinks for an intranet web page each of which will open to a different worksheet in the same Excel workbook. I have created labels for each of the A1 cells. So, worksheet 1's A1 is labeled "StepItUp" and worksheet 2's label for A1 is...
- Tags: A1, C. Boyd, cell, Microsoft Excel, programming, workbook, worksheet
- Q&A 2005-04-26
- Function to comparing data on Separate Excel Worksheet tabs
- Guys,I am trying to compare two sets of data held on separate excel worksheets. Worksheet 1 has UAT data, worksheet 2 has PROD data. I want to use an excel function to help verify the information held in both large worksheets tie up.I have been trying to use the...
- Tags: lou1s@..., Microsoft Excel
- Discussion threads 2007-03-20
- Excel 2002 Add-in: Open Database Connectivity (EXE)
- The Excel Add-in: Open Database Connectivity ODBC contains the SQL.REQUEST worksheet function, which can connect to an external database and return a query to the worksheet. The Excel 2002 Add-in: Open Database Connectivity ODBC contains the SQL.REQUEST worksheet function. The SQL.REQUEST worksheet function is used to link to an external...
- Tags: ODBC, Microsoft Excel 2002, Microsoft Excel, Databases, Microsoft Office, Office Suites, Software, Enterprise Software, Data Management
- Software downloads 2007-10-03
- Workbook TOC (exe)
- Workbook TOC is a table of contents generator for a Microsoft Excel workbook. This Excel Add-on will create a new worksheet listing the names of the worksheets in the workbook. The worksheet names are also hyperlinked to the worksheet to allow quick navigation of a large workbook. The trial version...
- Tags: Name, Workbook TOC, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2007-06-19
- Excel 2003 Sort restrictions
- Is it possible to "protect" an excel worksheet/document so that users can access, add/edit line items, but NOT be able to sort the worksheet?
- Tags: Excel 2003, windows, excel, office 2003, jgdavis, Microsoft Excel
- Discussion threads 2006-04-12
- << Previous
- page 1 of 1
- Next >>
