Jump to content

Contributors to this blog

Tutorial 3 - Entering Formula & introduction to cell referencing

Sign in to follow this  
Saurabh Jain


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  


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.

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...