Excel 2010 Workbooks

View:  
Sorted by:  

Excel 2010 Data-Entry Etiquette

To begin to work on a new Excel 2010 spreadsheet, you simply start entering information in the first sheet of the Book1 workbook window. Here are a few simple guidelines [more…]

How to Save an Excel 2010 Workbook as a PDF or XPS File

Microsoft Excel 2010 lets you save your workbook files directly in the PDF (Portable Document Format) or XPS (XML Paper Specification) file format. These formats enable people to open and print your Excel [more…]

How to Create a New Workbook in Excel 2010

If you’re working in Microsoft Excel 2010 and want to begin work in a new Excel workbook file, you can easily create a new workbook. To do so, you can use a command on the File tab or a keyboard shortcut [more…]

How to Change the Default File Location in Excel 2010

When you first start using Microsoft Excel 2010, Excel wants to save files in the Documents (Windows 7 or Vista) or the My Documents folder (Windows XP) under your user name on your hard drive. So, for [more…]

How to Save an Excel 2010 Workbook

As you work in Microsoft Excel 2010, remember to save your work often or you risk losing your data if the computer crashes or the power goes out. When you save an Excel workbook for the first time, you [more…]

How to Open an Existing Workbook in Excel 2010

You use the Open dialog box in Office Excel 2010 to open an existing workbook. The appearance and functionality of the Open dialog box differs slightly depending on whether you're running Excel 2010 on [more…]

Document Recovery in Excel 2010

Excel 2010 offers a document recovery feature that can help you if your computer crashes due to a power failure or an operating system freeze or shutdown. Excel's AutoRecover feature saves your workbooks [more…]

Comparing Two Excel 2010 Worksheets Side by Side

You can use the View Side by Side command button on the View tab in Excel 2010 to quickly and easily do a side-by-side comparison of any two worksheet windows that you have open. When you click this button [more…]

Dealing with Excel 2010 File Formats

Microsoft Excel 2010 supports the use of an XML-based file format called the Microsoft Office Open XML format. This file format carries the filename extension [more…]

How to Search for Workbooks in Excel 2010

If you want to open a workbook in Excel 2010 but can't remember the filename or location, you can use the Search feature in Microsoft Windows to find the missing workbook. To use the Search feature, you [more…]

Specifying Workbook Properties in Excel 2010

In Excel 2010, you can use the Document Information Panel to add or change workbook properties such as the Author, Title, Keywords, Status, and Comments that relate to a specific workbook. Adding [more…]

How to Protect an Excel 2010 Workbook

Excel 2010 includes a Protect Workbook command that prevents others from making changes to the layout of the worksheets in a workbook. You can assign a password when you protect an Excel workbook so that [more…]

How to Hide and Unhide Rows and Columns in Excel 2010

You can hide and unhide rows or columns in Excel 2010 when you don’t want part of the worksheet to be visible or when you don’t want certain data (such as salary information) to appear in printed reports [more…]

How to Hide and Unhide Excel 2010 Worksheets

In Excel 2010, you can hide any worksheet in a workbook to remove it from view so that others cannot see the data it contains. You can unhide the worksheet at any time. [more…]

How to Rename an Excel 2010 Worksheet

The sheet names that Excel 2010 uses for the tabs in a workbook (Sheet1 through Sheet3) are not very descriptive. Luckily, you can easily rename a worksheet tab to whatever helps you remember what the [more…]

How to Arrange Windows in Excel 2010 Workbooks

You can open multiple workbook windows in Excel 2010 and arrange them into windows of varying displays so that you can view different parts of a worksheet from each workbook on the screen at one time. [more…]

How to Insert a Hyperlink to a Different Cell in an Excel 2010 Workbook

You can insert a hyperlink in Excel 2010 that anyone can click to jump to a different cell in the current workbook. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic [more…]

How to Insert a Hyperlink to a File or Web Site in Excel 2010

You can insert a hyperlink in Excel 2010 that anyone can click to jump to Web sites or open other files. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic object, such [more…]

How to Insert a Link to Send an E-mail in an Excel 2010 Worksheet

You can insert a "mailto" hyperlink in Excel 2010 that anyone can click to create an e-mail to a specific address. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic object [more…]

Creating Your Own Excel 2010 Templates

When you can't find a ready-made Excel 2010 template that fits the bill, create your own templates from sample workbooks that you create or that your company has on hand. The easiest way to create your [more…]

How to Move or Copy Excel 2010 Worksheets to Other Workbooks

In Excel 2010, you may need to move or copy a particular worksheet from one workbook to another. You can use the Move or Copy dialog box to simplify the process. [more…]

How to Freeze Panes in an Excel 2010 Worksheet

The Freeze Panes command in Excel 2010 lets you freeze portions of a worksheet, typically column and row headings, so that you can view distant parts of the worksheet while the headings remain in place [more…]

How to Split an Excel 2010 Worksheet Window

In Excel 2010, you can split the worksheet window into separate panes and scroll the worksheet in each pane so that you can easily compare data from two separate worksheet locations. You can make the panes [more…]

How to Use Templates in Excel 2010

Excel 2010 provides templates, ready-made worksheets for common uses. These predesigned templates contain standard or boilerplate text, but you can modify them to fit your needs. You can use the templates [more…]

Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software
Great Gadget Giveaway -- Enter to Win!

Inside Dummies.com