This builtin is not currently supported: Animation
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
- Article Categories
- Book Categories
- Collections
- Custom Solutions
- Log In
- Main Menu
Article Categories
- Main Menu
Book Categories
Diane Koers
Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988 that services the central Indiana area. Her are of expertise h as long been in the word processing, spreadsheet, and graphics area of computing as well as in providing training and support for Peachtree Accounting Software. Diane's authoring experience includes more than 30 books on topics such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of her books have been translated into other languages such as Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Articles & Books From Diane Koers
Step by Step / Updated 01-25-2017
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 metadata such as this can help you to better identify and manage your workbook files.Click the File tab, and from the Info panel, choose Properties.
Step by Step / Updated 03-27-2016
Excel 2010, like the Office versions before it, has a lare number of built-in keyboard shortcuts that let you choose any Excel command without removing your fingers from the keyboard. The most common Excel commands have always had Ctrl-key shortcuts (such as Ctrl+S to Save), and those shortcuts still work. But now you can use keyboard shortcuts to access uncommon Excel commands.
Step by Step / Updated 03-27-2016
Excel 2010 provides several different formats in which to display dates and times in a worksheet. Some date formats appear automatically based on how you type a date entry in a cell. For example, if you type 9/10 in a cell, Excel interprets this as a date and changes the entry to 10-Sep (or whatever your default date format is).
Step by Step / Updated 03-27-2016
The Ribbon interface in Microsoft Office Excel 2010 may seem tricky to navigate until you get used to how commands are organized. The File tab on the left side of the Ribbon provides access to commands related to file management, such as opening, saving, printing, sharing, and closing files.
Let’s take a tour of the Ribbon:Click the File tab in the Ribbon.
Step by Step / Updated 03-27-2016
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.
All formula references to a hidden worksheet are still valid even when a worksheet is hidden.Click anywhere on the worksheet that you want to hide.
Step by Step / Updated 03-27-2016
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 — hidden rows and columns do not print.
You cannot hide selected cells; only entire columns or rows.Select the column or row headings you want to hide.
Step by Step / Updated 03-27-2016
You may find data in Excel 2010 worksheets easier to view if it's sorted on a particular column, in ascending or descending order. Excel sorts in the following pattern: numbers, spaces, special characters (such as ! " # $ % & * ) and finally, alphabetic letters.
Sorting data in ascending order sorts text from A to Z; numeric information from low to high; and dates with the earliest date first.
Step by Step / Updated 03-27-2016
Excel 2010 includes access to a thesaurus via the Research task pane if you need to find a word with a similar meaning to a word on your worksheet. Using the thesaurus is a simple process.Select the word you want to replace with another word.If multiple words appear in the cell, double-click the cell and then drag over the word you want to look up.
Step by Step / Updated 03-27-2016
If your Excel 2010 worksheet has become quite large, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box lets you tell Excel what column to sort on next if two cells in the main sort column contain the same value or data.
Although the most common sort is by rows, you can also sort by columns.
Step by Step / Updated 03-27-2016
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 object, such as a shape or clip art object.
Follow these steps to insert a hyperlink to another cell in a worksheet:Select a cell or graphic to which you want to attach a hyperlink.