Figuring Out the Excel 2007 Formula Bar
The Formula bar in Microsoft Office Excel 2007 displays the cell address and the contents of the current cell. Use the Formula bar to enter or edit formulas and cell entries and assign names to cells. [more…]
Customizing the Excel 2007 Quick Access Toolbar
The Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use often. By default, the Quick Access toolbar [more…]
Using AutoSum for Quick Calculations in Excel 2007
To quickly sum a row or a column of values in an Excel 2007 worksheet, you can use the AutoSum button (the one with the on it) in the Editing group of the Home tab of the Ribbon. When you click this button [more…]
Working with the Excel 2007 Mini Toolbar
Microsoft Office Excel 2007 makes it easy to apply common formatting changes to a cell selection right within the Worksheet area, thanks to its new mini toolbar feature. [more…]
Using the Clipboard Task Pane in Excel 2007
The Office Clipboard can store multiple cuts and copies from any Office program running under Windows, not just Excel 2007. In Excel, this means that you can continue to paste stuff from the Office Clipboard [more…]
Examining the Excel 2007 Status Bar
The Status bar appears at the bottom of the Microsoft Office Excel 2007 window and keeps you informed of Excel’s current mode and any special keys you engage. In addition, you can use the status bar to [more…]
Introducing the Excel 2007 Ribbon
The Ribbon interface in Microsoft Office Excel 2007 radically changes how you work. You no longer need to find on which pull-down menu or toolbar a command resides. Instead, the Ribbon shows you the most [more…]
Manipulating the Excel 2007 Office Button
In the top-left corner of the Excel 2007 window, you find the Office button (the round button with the Office four-color icon), which provides access to common file-related commands. The Office button [more…]
Using Contextual Tools in Excel 2007
Microsoft Office Excel 2007 displays contextual tools with tabs and commands that help you work with a particular object that you select in the worksheet — such as a graphic image you’ve added or a chart [more…]
Zooming into Your Excel 2007 Worksheets
You can use the Zoom slider on the Status bar in Microsoft Office Excel 2007 to increase the magnification in a worksheet or shrink it down to the tiniest size to get an overall picture of the worksheet [more…]
How to Leave Your E-mail on the ISP Server
When you’re traveling, you may want to check your e-mail but still keep it available to view from your desktop computer when you get back home. You can do so by keeping all your e-mail on your ISP's e-mail [more…]
Exploring the Excel 2007 Program Window
When you start Microsoft Office Excel 2007, you see the first of three worksheets (named Sheet1) in a workbook file (named Book1) inside a program window. The Excel 2007 program window is made up of the [more…]
How to Disable Automatic Checking in Outlook Express
When your laptop is connected to the Internet all the time, especially at the office, you probably have your e-mail program configured to check for new messages every so often. On a laptop with a dial-up [more…]
How to Disconnect from Your Dial-up Account after Checking E-mail
When you're using a dial-up account from your laptop, keep in mind that you don't need to be connected to the Internet while you read your e-mail. Especially given how much power the modem draws, you should [more…]
How to Send All Your E-mail in One Batch
As you peruse your e-mail on your laptop, you read messages, reply to messages, and then click the Send button to send those messages. But rather than cause your e-mail program to dial in, connect, send [more…]
How to Skip E-mail Messages That Are Too Big
If you use a dialup modem, you probably don't want to waste time downloading huge files. Some e-mail programs have a settings option that automatically manages e-mails with large attachments. For example [more…]
How to Omit Your E-mail Password
When you are traveling with your laptop, you can make your e-mail more secure by omitting your password. At home or in your office, having Windows remember your Internet and e-mail passwords is handy — [more…]
How to Customize the Excel 2010 Quick Access Toolbar
The Quick Access toolbar in Excel 2010 appears above the Ribbon and includes buttons for commonly used commands. By default, the Quick Access toolbar contains only the Save, Undo, and Redo commands, but [more…]
