Microsoft Excel 2010 Formatting made easy
Free Microsoft Office Tutorials
We are now going to take some time to look at the worksheet and in particular we will be focusing on Excel 2010 formatting within that sheet .
The cell is a container that can hold:
- Text and Numbers
- Formatting attributes
- Formulas and Function
Cells are cross-referenced by the intersection of columns and rows. So every cell has its own name. There are 1 million rows and 16,000 columns on a worksheet. Please refer to the illustration below.
The contents of a cell are shown in the formula bar. The location is in the name box.
Some trivia: If you were to add the number 1 to every cell on a worksheet at a rate of one per second then it would take you 544 years to fill the sheet. There is an incredible amount of space 17 billion cells reside on every sheet and each has their specific location and reference. That is incredible is it not? You can have multiple sheets in a workbook, so the scope for handling data is enormous.
Please watch this video tutorial for an overview of Microsoft Excel 2010 Formatting .
You can activate the cut copy and paste functions from the ribbon. Image above shows all of the options including the paste special options
By right clicking the activated cell or range you will be presented with a dialogue box that also allows you to cut copy and paste.
The illustration above shows the options on the ribbon and on the right click dialogue box.
Image above. Instead of cutting and pasting you may prefer to just move the data to a new location. To do this highlight the cell wall range then the move the cursor to the border of that range and when it changes to an arrow, drag the data to the new location.
Image above. You can also copy and paste by using the fill handle. When you move your cursor to the corner of the activated cell range, the cursor changes to a cross, you can now copy the data by dragging the cross over the area to which you want the data copied.