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

Chapter 3. Entering and Editing Data > Rearranging Worksheet Data

Rearranging Worksheet Data

When you create a new worksheet, it's always beneficial to spend some time planning the layout. What is the purpose of the worksheet? Think about what information you need to enter and what information you need to calculate. Spend some time considering the best way to set up and enter the data. Of course, if you've already entered your data, you can easily rearrange it afterwards to suit your needs. Excel has plenty of commands, such as Cut, Copy, and Paste, that you can use to move data around.

Using Cut, Copy, and Paste

Excel provides some shortcuts for entering the data, for example, the Copy command. Say your budgeted amounts for your categories are the same from month to month. Rather than type them over and over again, you can copy the values. (You also can fill data as a shortcut for entering information. See the "Speeding Up Data Entry" section earlier in this chapter.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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