Page 216 - Excel 2013 All-in-One For Dummies

198 A Spreadsheet with a View
After clicking OK in the Insert dialog box, Excel moves down the existing entries as follows:
✦ 2000 David Court and $450,000 previously in cells A5 and B5 to A8 and B8, respectively
✦ 892 Miller Lane and $285,500 previously in cells A6 and B6 to A9 and B9; respectively
✦ The total of $1,160,500 previously in cell B7 to B10.
This leaves the previously occupied range A5:B7 with six blank cells, where I
can enter the following values:
✦ 34 6th Avenue and $125,000 in new blank cells A5 and B5, respectively
✦ 347 Oak Road and $350,000 in new blank cells A6 and B6, respectively
✦ 25 Smith Ranch and $285,000 in new blank cells A7 and B7, respectively
As you can see, the sum formula in the last cell in this column, cell B10, has automatically been recalculated so that the total reflects the addition of the missing values that I entered in the newly inserted cells.
If you know that you want to move existing cells down with the Shift Cells Down option when inserting new cells in the current cell selection, you don’t have to bother with opening the Insert dialog box at all: Simply click the Insert button (rather than its drop-down button), and Excel instantly inserts new cells while moving the existing ones down.
A Spreadsheet with a View
The biggest problem with editing is finding and getting to the place in the worksheet that needs modification and then keeping your place in the work- sheet as you make the changes. This problem is exacerbated by the fact that you probably often work with really large spreadsheets, only a small portion of which can be displayed at any one time on your screen.
Excel provides a number of features that can help you find your way and keep your place in the spreadsheet that needs editing. Among these are its Zoom feature, which enables you to increase or decrease the magnification of the worksheet window, thus making it possible to switch from a really up- close view to a really far-away view in seconds, and its Freeze Panes feature, which enables you to keep pertinent information, such as column and row headings, on the worksheet window as you scroll other columns and rows of data into view.