Format & Arrange:

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

You often think of a better way of arranging things just about the time you are nearly finished with your spreadsheet. Or, after you have used the spreadsheet awhile, you see that you need a more convenient way to arranging the data.

Rather than starting over from the beginning, it is easier to move your data. Excel makes it easy to move, add, delete, and copy rows, columns, or selected cells - without messing up your lovely formulas. Of course, there are a few oddities you need to understand.

You can cut and paste or copy and paste, using  the toolbar buttons Buttons: Cut, Copy, Paste or the shortcut keys CTRL + X, CTRL + C, CTRL +V.

You can even drag selected cells to new locations.

If the destination cells already have data in them, however, you must make a decision. You can either replace what is in the cells or you can insert your data and move the existing data out of the way. There is a restriction. You can only shift the existing data to the right or down. This means you must think before you move.

Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel BasicsTo subtopics    

Project 3: Format & Arrange
    Format CellsTo subtopics
    Format ChartTo subtopics
    Arrange Open arrow to subtopics
    ExercisesTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics