excel posts on CNET - Page 15


Find cell values easily using Excel's Lookup Wizard

Microsoft Excel can handle data tables with hundreds or even thousands of rows and columns. That's great, unless you're trying to find a specific cell's value, which could have you scrolling up and down, left and right looking for that needle of data in a haystack of cells. If your table is formatted correctly, you can use Excel's Lookup Wizard to display the data in a cell automatically.

To see if you have the Lookup Wizard installed in Excel 2003, click Tools and look for a Lookup option, probably at the bottom of the menu. In … Read more

Five great freebies improve your Office experience

Microsoft Office is so jam-packed with features that an entire industry has been created to help people find the ones they need. (An example is Addintools' $30 Classic Menu for Office 2007.) Why would anyone suggest that you add even more functions to Office apps? Because the best free Office add-ins can save you considerable time and trouble, without costing you a red cent. Here are five of my favorite Office helpers.

Poll attendees to find the best time for a meeting Everybody's busy, as anyone who has ever tried to schedule a meeting with more than two attendees … Read more

Attackers targeting Microsoft Office Excel

Microsoft issued a security advisory late Tuesday that malicious attackers are targeting versions of its Office Excel with vulnerabilities.

Microsoft Office Excel 2003 with Service Pack 2; Excel Viewer 2003; Excel 2002; Excel 2000; and Microsoft Excel 2004 for the Mac are affected by the security vulnerabilities, according to the advisory.

People who open a malicious e-mail attachment or visit a malicious Web site may find that their systems are compromised and that arbitrary remote code is executed. Computers configured to allow the user to have administrative user rights are at greater risk that those with few user rights on … Read more

Five easy Excel formatting tricks

I've never trained an elephant, but I imagine the process is similar to that of getting your Microsoft Excel worksheet to look just right. Here are five of my favorite Excel formatting tricks.

Double-click to fit columns and rows When you enter or paste text and numbers into Excel, the cells don't expand to fit their contents. The fast way to autofit columns and rows is to hover your mouse over the header border between the column and its neighbor to the right, or between two rows at the far left of the worksheet. When the resize icon … Read more

Create a keyboard shortcut to paste plain text

Last week I described the PureText utility that lets you paste plain text in Word and other applications via a keyboard shortcut. You can create a macro to get the same functionality in Word and Excel, without having to download anything.

(Note that the original post of this tip reported that PureText required that you click its icon in your system tray before you press the shortcut keys to paste plain text. This is true only if you open the destination app after the material you want to paste has been added to the clipboard. If both the source and … Read more

Office Live Workspace (almost) brings Office 2007 online

Microsoft is stepping closer to providing anywhere access to Office files. The free Office Live Workspace (more here), which lets people share work in Word, Excel and PowerPoint online, is expanding today to invite more beta testers.

You can sign up to try the work in progress at OfficeLive.com, although access may not be immediate. A final version is set for next spring.

When Office 2007 debuted nearly a year ago, it seemed curious that Microsoft offered no easy, one-click option for accessing work from the Web. Meanwhile, Zoho built an add-in for Office 2007, as Google Docs & Spreadsheets and other tools allowed people to share as well as compose work within a browser.

The free, ad-supported Office Live Workspace is a bridge to Office software, not a browser-based replica. Workspace synchronizes changes made to files stored both on a desktop and at Office Live's servers, including Outlook contacts and events. It works with Windows XP SP2, 2003 Server, or Vista with Internet Explorer 6 and Firefox 2 or higher (required for users of Mac OS 10.2 and up).

The online tools preview Word, Excel, and PowerPoint files as well as PDFs, PNGs, and JPGs. Workspace is meant to work in tandem with Word, Excel and PowerPoint XP, 2003, or 2007 running locally on a PC. You can preview, not edit, documents from a browser. Web Notes, on the other hand, do enable the creation and formatting of small text documents online.

Office Live Workspace emphasizes collaboration rather than composition. To share documents with other people, you can send them a secure URL without requiring them to sign in with a Windows Live ID. Everyone with access to the workspace can make and view each others' comments.

Those invited for editing can make changes to the work, as long as they have Word, Excel, and PowerPoint on their hard drive. Office Live Workspace handily preserves the Track Changes feature from Office apps while also keeping five histories of a file. And the Share View screen allows control of another user's PC.

Another desktop component of this service is the Office Live Add-In for Microsoft Office. This is a quick download, although you'll have to restart the system afterward. Once it's installed, a Save to Office Live option will appear under the Office button within Word, Excel, or PowerPoint, with the subsequent dialog box showing your available workspaces.

Workspaces are collections of documents. Ten templates are built to manage a classroom, sports team, travels, job search, household, and so forth. For example, a travel workspace will include an expense report spreadsheet with Word files for an itinerary, packing list, and personal data. You can store a maximum of 500 workspaces containing 500 documents each for a total of 500 MB per account and 25 MB per file.

Office users who learn about these tools are likely to come to depend upon them to stash their work online with a few, quick clicks. Workplaces that use Microsoft's staple software will probably find Workspace a fine collaboration tool that makes it easy to take work away from the office.

This is a well-designed service, but I'd still like something not only to store work, but to let me make edits without opening local applications. What if you only want to correct a misspelled byline in a 20 MB report? You'll have to open Word, since Office Live Workspace doesn't even allow light, text only edits within a browser. I'll continue to lean on Google Docs for that.

Office Live Workspace, by the way, is not to be confused with Office Live Small Business, which offers a free domain name and Web design templates.

Please see more images after the jump.… Read more

Microsoft upgrades its Office for Mac upgrade offer

Correction 2:10 p.m. PDT: This blog initially misstated the savings for buyers of Office 2004 for Mac Student and Teacher edition if they choose to upgrade to the 2008 Special Media Edition. The savings would be $350.

Microsoft has improved on an earlier offer to those who buy Office 2004 for Mac before the new version of Office is released in January.

In September, the company said it would offer buyers of Office 2004 an upgrade to the comparable version of Office 2008 for the cost of shipping and handling.

Now, those who purchase Office 2004 for Mac … Read more

Mac Office 2008 adds Excel templates, supports Exchange

Microsoft is revealing more details about new features in its Office for Mac 2008 suite, due for a release early next year.

Excel 2008 for Mac will offer worksheet templates with baked-in calculations designed to make it easier to balance household finances, manage inventory and other common tasks. The new Ledger Sheets features will include a gallery of elements, shifting formulas to the background.

In addition, the Entourage e-mail client will offer more support for Microsoft Exchange, which traditionally has enabled non-Mac PC users to make appointments and share notes and files with each other.

Each version of Office for … Read more

Microsoft fixes Excel math bug

After discovering two weeks ago that the latest version of Excel had a problem with math, the software maker said the spreadsheet is once again ready to resume its spot at the head of the class.

Late Tuesday, Microsoft posted patches to its Web site that fix the arcane math flaw in Excel 2007 and Excel Services 2007.

"Thank you for your patience," Microsoft's David Gainer said in a blog posting announcing the fix.. The bug caused the software to display improper results when calculating numbers around 65,535 and 65,536. The company said the fix … Read more

Beyond Microsoft Office: We compare 9 productivity suites

Microsoft Word, Excel, PowerPoint and their Office allies can be great applications, but not everybody needs everything they offer. How do you know where to start when shopping for alternative software? You'll save money with a different brand, but will it do the trick? Should you buy boxed software, download freebies for your hard drive, access browser-based apps, or juggle all of the above?

We've reviewed nine productivity suites--including downloads and online services--and cooked up a jumbo chart mixing up their gumbo of features and file formats. IBM's release of Lotus Symphony beta added more spice to … Read more