Jump to content


Contributors to this blog

Tutorial 3 - Entering Formula & introduction to cell referencing

Sign in to follow this  
Saurabh Jain

299 views

In this tutorial we will learn to write basic formulas and introduction to cell referencing

  • Relative referencing which is the default referencing
  • Absolute referencing
  • Mixed Referencing

 

 

 

Important points

4 type of referencing can be  cycle through f4 key -  when we are in edit mode of cell  - (use f2 to enter into edit mode) -    A1 , $a$1 , A$1, $A1 

Shortcut Ctrl + ~  (tilde which is just above 1 in windows)

pl download file

 

 

 

 

Sign in to follow this  


0 Comments


Recommended Comments

There are no comments to display.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...