Microsoft Office Excel 2007 offers a variety of keyboard shortcuts for selecting a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view [more…]
Before you can enter your worksheet data in Microsoft Office Excel 2007, you must know how to select cells in a worksheet. The cell cursor is a black border that surrounds the active cell [more…]
In Microsoft Office Excel 2007, you can select commands on the Ribbon by using keyboard shortcuts. Press the Alt key followed by letter keys displayed on the Ribbon to select the desired Excel command [more…]
Excel 2007's AutoCorrect feature already knows to automatically fix two initial capital letters in an entry, to capitalize the names of the days of the week, and to replace a set number of text entries [more…]
If you want to start Microsoft Office Excel 2007 by clicking a single button, you can add the Excel icon to the Quick Launch toolbar. The Quick Launch toolbar resides to the immediate right of the Start [more…]
You can look at the worksheets you create with Excel 2007 from any number of perspectives. You can change the view so that you see — or don’t see — page breaks, grid lines, and dialog boxes, and you can [more…]
Possibly the most useful — and used — function in Excel 2007 is the one that helps you create formulas so that you add, count, average, and generally do math functions with the data in your Excel worksheets [more…]
Excel 2007 is an excellent tool for building spreadsheets, or worksheets as Excel calls them. Excel 2007 offers hot keys as well as the command Ribbon introduced in Office 2007 to help you create a new [more…]
Sometimes you want to make changes to the information you put into your Excel 2007 worksheets and workbooks (called spreadsheets in the world outside Excel). When that’s the case, you can use the handy [more…]