Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Technical tip for loading a web image to an Excel worksheet
- Aspose publishes October 2007 Newsletter for .NET & Java programmers with introductory information about our spotlight product: Aspose.Pdf for Reporting Services. We will also look at the new and exciting features offered in the recent releases of Aspose.Words for Reporting Services, Aspose.Network, Aspose.Pdf, Aspose.BarCode and Aspose.Cells. This month’s Technical-Tip demonstrates...
- Tags: .NET, Application servers, aspose_seo, Technical-Tip, Aspose.Cells, Aspose.Pdf, web image, Reporting Services, Excel Worksheet, Microsoft Excel, Web, Aspose
- Discussion threads 2007-10-01
- Sample Code to Change Source of Linked Excel Worksheet in WORD
- I am looking for a Visial Basic Macro to change source of embedded Excel Worksheet in Word. Microsoft Support website provides a code to change the path name of the excel file in PPT (http://support.microsoft.com/kb/222708)but I was not able to find a similar code for Word. Any help...
- Tags: Word processors, Microsoft Office, ckuntay@..., Microsoft Word, Excel Worksheet, Microsoft Excel
- Discussion threads 2007-07-30
- Excel worksheet
- Hi, Does anybody know how to format an Excel worksheet so that it will only display 2 columns?Thanks
- Tags: ecrwn@..., Excel Worksheet, software, Microsoft Excel
- Discussion threads 2006-12-04
- 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
- Add a Date/Time stamp to your Excel worksheets
- Date & time stamp wirhout auromatic updateTried formula and it works great but i would like date and time to remain unchanged when you press F9 recalculate worksheet.Can this be done .did not get itWhy this is better than =now?
- Tags: date, Date/Time, Excel Worksheet, Excel Worksheets, f9, hardware, ian@..., Microsoft Excel, time
- Discussion threads 2006-01-13
- Sort and format a protected Excel worksheet with a macro
- ProblemReading a Tech Q&A post by traveladvocate, I was reminded of the axiom: You can't always get what you want.That pretty much sums up the situation when it comes to sorting data in aMicrosoft Excel protected worksheet. It is an immutable fact that only cellsthat are unprotected can be sorted....
- Tags: macro, Microsoft Excel, worksheet, Mark Kaelin, Excel Worksheet
- Technical articles 2004-06-23
Additional Resources
- 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
- 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
- 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
- Excel 2003 Personal Trainer: The Fundamentals
- Excel is a powerful spreadsheet software program that allows to make quick and accurate numerical calculations. Entering data onto a spreadsheet (or worksheet, as they are called in Excel) is quick and easy. Once data has been entered in a worksheet, Excel can instantly perform any type of calculation on...
- Tags: Microsoft Excel 2003, Spreadsheet, Microsoft Excel, Microsoft Office, Office Suites, Software
- Book chapters 2004-11-08
- 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
- Quickly import data into Excel with these techniques
- This sample chapter, taken from Managing Data with Excel, highlights a couple ways to get data from other applications into an Excel worksheet. Learn a couple ways that you can import data into Microsoft Excel.This sample chapter, taken from Managing Data with Excel, discusses ways to get...
- Tags: Technique, Chapter, Microsoft Excel, Microsoft Office, Office Suites, Software
- Book chapters 2005-10-28
- 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
- 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 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
- Open Excel file on Local Computer which is located on Server Using Asp.Net
- HelloI want to open a Excel file on my local computer.File is located on Server Computer.I am using Microsoft Office XP.I try this code Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open( openFileDialog1.FileName, 0, true, 5, ...
- Tags: deshpandevd@..., Excel File, Excel.Worksheet, Microsoft ASP.NET, programming, server
- Discussion threads 2006-10-11
- Crystal Reports from Excel
- Does anyone know how to create crystal reports from complex excel tables? I need to use the workbook approach and a wide variety of complex tables from the multiple worksheets pages in the workbook and to export this data to create crystal reports that calculate the same data the...
- Tags: Crystal Reports, Microsoft Excel, paige.heard@..., software, worksheet
- Q&A 2004-11-01
- Excel-to-Oracle (exe)
- Excel-to-Oracle is a program to migrate MS Excel data into Oracle database. Each worksheet becomes a table, each row becomes a record and each cell becomes a field. All versions of MS Excel are supported. The program has easy-to-use wizard style interface and works with all versions of Oracle server....
- Tags: Oracle Corp., Row, Excel-to-Oracle, Microsoft Excel, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Software downloads 2006-07-19
- Worksheet Sort (zip)
- Worksheet Sort is an Excel add-on that will sort the worksheets in an Excel workbook in either ascending (A-Z) or descending (Z-A) order.
- Tags: Worksheet Sort, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2006-04-24
- Printing Duplex in Excel 2003
- I am not able to print duplex in excel 2003 for multiple worksheets. Whenever i print, each worksheet will come out on different piece of paper instead of being duplexed. All i want to know is, is it possible to do this? Or is there any other solutions.Hello...When Excel prints...
- Tags: cyberace, Microsoft Excel, Page 1, printing, windows, worksheet
- Q&A 2005-05-18
- << Previous
- page 1 of 1
- Next >>
