Understanding the MS Office Interface

Sorted by:  

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…]

How to Start an Office 2013 Application in Windows 8

The most straightforward way to start an Office 2013 application is to select it from the Windows 8 Start screen. You can browse through the list of programs, or you can start typing the application’s [more…]

How to Start an Office 2013 Application in Windows 7

The most straightforward way to start an Office application is to select it from the Windows 8 Start screen. These instructions are for opening and closing Office 2013 applications for [more…]

How to Move Around in Office 2013

As you work in one of the Office 2013 applications, you may add so much content that you can’t see it all onscreen at once. You might need to scroll through the document to view different parts of it. [more…]

9 Common Tabs and Tasks in Office 2013 Applications

Office 2013 contains separate applications that share many common commands and features. Excel, Word, and PowerPoint are all very similar in their basic functionality and appearance. The methods for how [more…]

15 Terms to Know for Office 2013

The Office 2013 interface is consistent across all Office programs and includes the Ribbon, the File menu, Zoom controls, and standard dialog boxes for saving and opening files. Here are 15 terms you need [more…]

How to Customize the Quick Access Toolbar in Office 2016

No matter where you go in Office 2016, you see the Quick Access toolbar in the upper-left corner of the screen. This toolbar offers the Save, Undo, and Redo buttons, as well as the Touch/Mouse Mode button [more…]

How to Customize the Status Bar in Office 2016

The status bar along the bottom of the Office 2016 window gives you information about the file you're working on. The Word status bar, for example, tells you which page you're on, how many pages are in [more…]


Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com