Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Twenty20 Cricket World Cup Spreadsheet (zip)
- Twenty20 Cricket World Cup Spreadsheet contains schedule, squads, results, and match timings. Select your favorite team for the list of results and the squads. Select your country from the match timings worksheet to know match timings in your country. The worksheet is fully updated till the last match. This version...
- Tags: Spreadsheet, World Cup, Worksheet, Productivity
- Software downloads 2007-11-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
- MS Excel 2003 cell positioning
- I have a hyperlink to a cell within the same worksheet. I don't want to jump to another worksheet or file, just another location in the worksheet. What I am having trouble with is having excel jump to the cell and display it in the upper left corner....
- Tags: Microsoft Excel, Microsoft Corp., frotterus@..., cell, worksheet, D40, positioning
- Discussion threads 2007-09-18
- How to print Excel comments
- Comments are scattered all over my Excel spreadsheets and I find them helpful. Most of the time, they're just for me -- they're reminders of partial payments, specific check numbers, and so on. However, recently, I wanted to share a few comments with someone. Surely I didn't need to cut...
- Tags: Microsoft Excel, News, Susan Harkins
- Blog posts 2007-09-10
- 10 ways to format Excel data so that people can actually understand it
- Tell the truth, now. When you see a new worksheet arrive in your Inbox, your pulse doesn't exactly quicken, does it? I'm guessing that you don't lean forward in your chair, eager to open the file and see what exciting new numbers the worksheet is likely to present. ...
- Tags: Page, Microsoft Office, Data, Information, Microsoft Excel, Microsoft Excel 2007, Cell, Text Box, Katherine Murray
- Blog posts 2007-08-28
- Apply the D.I.C.E. framework to determine your best server operating system solution
- This blog post is also available in PDF form as a TechRepublic download, which includes the sample Excel D.I.C.E. worksheet.Your business has grown to the point where a few file shares on your desktops and a router giving you DHCP addresses is no longer sufficient. You need to move to...
- Tags: Operating System, Server OS, Server, Joshua Hoskins
- Blog posts 2007-08-17
- Apply the D.I.C.E. framework to determine your best anti-spam solution
- This blog post is also available in PDF form as a TechRepublic download, which includes the sample Excel D.I.C.E. worksheet.Everyone hates spam. It fills up your inbox, and you have to waste your time deleting it. If you own your own business, you want to make all of your people...
- Tags: Solution, Anti-spam, Product, Anti-spam Solution, Joshua Hoskins
- Blog posts 2007-07-31
- Print all Excel worksheets in color
- In our company we have set the print server drivers for color printers to print in black and white it is more economical that way.That means when you need to print an Excel worksheet in color, you just need to change the printer properties in the Print windows and choose...
- Tags: Printers, macreardon@..., Microsoft Excel, printer, worksheet
- Discussion threads 2007-07-24
- Apply the D.I.C.E framework to determine your best anti-virus solution
- This blog post is also available in PDF form as a TechRepublic download.If you use PCs for work, then you must deal with the constant threat of viruses. Not only can they take an individual computer down, but they can also wreck havoc on your network. They can delete files...
- Tags: Virus, Security, Antivirus
- Blog posts 2007-07-23
- Apply the D.I.C.E framework to determine your best back up server solution
- Your company's data is important, but how well do you protect it? What would happen in case of a fire, or if an employee accidentally or purposely deleted a large amount of data? You need a backup solution, but what do you pick? How do you even begin to traverse...
- Tags: storage, disaster recovery
- Blog posts 2007-07-18
- Set Excel text boxes to reflect data updates
- Excellent tip!to date, I've been using a macro for that as I could not find a way for the text box to update automagically. And it's so simple...Thanks a lot!RE: Set Excel text boxes to reflect data updatesVery goodRE: Set Excel text boxes to reflect data updatesWhy would you want...
- Tags: Wyrmlord, Set Excel, data update, worksheet
- Discussion threads 2007-06-27
- Set Excel text boxes to reflect data updates
- Have your Excel text box change with your data! Here's how to create dynamic text boxes in Excel, while giving yourself the freedom to format them to fit your style.Excel's text boxes do not have to be static; that is, you can have the text within the boxes change automatically...
- Tags: Sales strategy, Microsoft Office, text box, Microsoft Excel, worksheet, Monthly Sales, Sales Summary
- Technical articles 2007-06-26
- How to add a dropdown list to an Excel cell
- Things To KnowIf you're using this tip, there are a few things to be aware of.You don't need to setup the list of options on a worksheet, you can just type the items into the Source box on the Data Validation dialog. ie Enter Yes,No,Don't Know to get these options.If...
- Tags: Microsoft Excel, gbentley@..., worksheet, Data Validation
- Discussion threads 2007-06-26
- Turn off gridlines in your Excel applications
- Gridlines in your Excel worksheets can be quite distracting. Mary Ann Richardson explains how to make gridlines invisible in Excel 2002, 2003, and 2007. Your users may find it easier to work with your worksheet applications if they can't see the gridlines. For example, let's say you...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, gridline, worksheet, Microsoft Office Suite Excel Tips Newsletter, Office Suites, Software
- Technical articles 2007-06-05
- How do I... Use pre-built style features to format Excel 2007
- This article is also available as a TechRepublic download and as a TechRepublic gallery.Formatting an Excel worksheet to look professional and at the same convey the vital information you want to communicate with your audience has always been a bit of a challenge. With the release of Microsoft Office 2007,...
- Tags: Office 2007, Microsoft Office, Excel 2007, Excel
- Blog posts 2007-06-05
- Sorting data in one worksheet in another
- I have a worksheet with a drop down list containing about 10 items. Obviously as the list is used these items are selected and the list could typically look like this:dogscatspigs catscatsdogselephants.For each of these animals there is also a name, which could be different.On a separate worksheet I want...
- Tags: rianschoeman@..., worksheet
- Discussion threads 2007-05-15
- 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
- Inserting Worksheet Tabs in Excel 2003
- I have a user who needs to insert additional worksheets in a new workbook each month. But, they want to rename Sheet 1 to the first day of the month (i.e. 3-1-07), and then easily update the rest of the worksheets to be the rest of the days of...
- Tags: excel, excel 2003, laura.laughery.gud4@..., Microsoft Excel, sheet tabs, software, worksheet, worksheets
- Discussion threads 2007-03-02
- Help With an Excel Formula
- I have created a spreadsheet for our little league baseball stats. I have different worksheets for each team (18 worksheets for 18 teams). I am trying to set up one of the Worksheets to have the league leaders in each category (i.e. home runs, hits, strikeouts, etc.) Is there a...
- Tags: worksheet, thomas.bowling@..., software, Microsoft Excel, VLOOKUP
- Discussion threads 2007-02-23
- Microsoft Excel 2003
- I have a workbook with several worksheets, within the workbook I have a master worksheet that has a compilation of all the other worksheets. What I need to happen is I want to add the total columns in the other worksheet and display the totals on the master worksheet; the...
- Tags: worksheet, tru.notoma@..., IBCT NG, windows, windows xp, security, software, career, it management, hardware, networking, excel, e-mail, microsoft office 2003, workbook, Microsoft Corp., Microsoft Excel, cell
- Discussion threads 2007-02-22
