Viruses Explained What are Trojans? What are Worms? What are Rootkits? Free AntiVirus Latest Virus Threats Top 10 Anti Virus Malware Tutorials
Spyware Explained Malware Tutorials Free Anti Spyware Manual Tips
FREE Anti Virus FREE Anti Spyware FREE Online Scanners Definition Updates Manual Updates BootUp Anti Virus Portable Protection Rootkit Removal Top Security Tips
HTML Tutorial WORD Tutorial EXCEL Tutorial Computer Beginners Windows Registry Top Security Tips Malware Tutorials
Web Templates Word Templates Word Processing

Home Page
Free Anti Virus
Free Anti Spyware
Free Online Scanners
Free USB Anti Virus
Bootable Anti Virus
Rootkit Removal
Latest Virus Threats
Viruses Explained
Spyware Explained
Windows Registry
Top 10 Antivirus
Manual Updates
Definition Updates
Malware Tutorials

Computer Basics
HTML Tutorials
Free Web Templates
Word Tutorials
Excel Tutorials

CV Creation
Free CV Templates
Free CV Examples

   IP: 54.162.139.105

Excel Basics   AutoSum   Formulas   AutoFill  

Excel Pointers:

The very first thing to understand before you do anything is to understand the different pointers in Excel. They are easy to understand so just follow the list below.



1: The main pointing tool used to highlight individual or mulitple cells for working on.

2: Important to know the difference between this and the first one. When a cell is highlighted by using number 1, the bottom right of the cell will have a small black square. If you drag the pointer tool (number 1) onto this box then the pointer tool will change to number 2.

Number 2 is used to anticipate the next cell status, e.g. by typing in Monday in a cell and using number 2 to drag to the next cell it will anticipate Tuesday and so on to the next cell.

3: The I beam used to type data into a cell the same as if you were using a Word document. Double click the cell to see the I beam.

4: Drag the pointer to top of column or start of row when you see the black arrow, then you can left click to highlight whole Column or Row.

5: Drag the pointer between any column at the top of the columns to see this double pointing arrow. Then you can left click to stretch or narrow the column to the left .

Excel Cell Reference:

Excel uses Columns and Rows signified by Letters for the Columns and Numbers for the Rows.

Also you must understand with Excel is that all the boxes you see are referred to as cells and they all have their own individual name or reference.

When you open the Excel Application by default the top left cell will be highlighted which is A1. A being the column and 1 being the Row. See below and also notice that the letter on the horizontal bar and the number on the vertical bar are coloured to show the reference to that cell.



See below that you can highlight what ever cell you want and the same features apply as in the above example. You use the bold white cross pointer to click on and highlight the cell you want.



By holding down the left click and dragging the pointer cross you can highlight multiple cells see below. Further on in this lesson you will see why you would need to do this highlighting with data inside the cells.