• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Spreadsheet Software > Editing Spreadsheets

Editing Spreadsheets

Another feature that can save you much time is the spreadsheet's ability to copy labels, numbers, and formulas from one location to another. For example, you might want to list your petty cash expenses by months, with each month in a separate column. Rather than recreating the labels and formulas for each month, you could copy the entire first month's information and paste it into the next column or the next group of columns. The spreadsheet software automatically compensates for the differences in cell labels from column to column and row to row and adjusts the new column so that the formula calculates the numbers in the new column, not in the original month column. The commands for selecting, copying, and pasting can all be found in the control panel of the spreadsheet.

Arranging Layout

Arranging your layout to look the way you want is another useful feature of an electronic spreadsheet. You can change the contents of any cell; add or delete rows or columns; and copy, cut, and paste data from one cell, row, column, or block to another similar area.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint