Techno-Tip #6 - Cell Reference in Excel

_Techno-Tip #6 by CA Ravindra Patil (92093-00789)                        (10-03-2018)_

*Cell Reference in Excel*

1. Excel has a cell reference style C1R1
    Where C1=Column 1 & R1=Row 1
2. When we drag/copy and paste the formula cell reference also change automatically.
     e.g. C1=A1+B1, if we copy cell C1 & paste in cell F5 formula will change to D5+E5 it’s called              relative reference

3.  If you want to make the cell reference as absolute reference (means reference will not change             with drag/ copy & paste) we have to assign $ sign to column & row label
     e.g. C1=$A$1+$B$1, here if you copy formula of cell C1 & paste in F5, formula in cell F5 will              be F5=$A$1+$B$1

4.  If you want to freeze column only assign $ to column label only
     e.g. C1=$A1+$B1 here columns as freeze, when you copy & paste cell C1 to cell F5 formula will          be F5=$A5+$B5 column will not change to D5+E5

5. If you want to freeze row only assign $ to row label only.
    e.g. C1=A$1+B$1, here Rows are freeze, when you copy & paste cell C1 to F5 formula will be            F5=D$1+E$1 rows will not be change from Row 1 to Row 5.



Note: - [$ sign can be assigned by pressing F4 key in cell reference] [one time F4 column & row will be freeze] [two times row will be freeze] [three times column will be freeze] [four times $ will be removed]

Comments

Post a Comment

Popular posts from this blog

Techno-Tip #8 - How to open New version Tally data in Old version of Tally

Techno-Tip #8 by CA Ravindra Patil (92093-00789)                         (16-09-2018) How to open New version Tally data in Old version of Tally Paste data into data directory Open tally If any company automatically opened close it by pressing Alt+F1 Now you will be at “Company Info.” Window Press Alt + Ctrl + R – it will navigate to Rewrite Company Select the company to rewrite It will as “Rewrite?” select Yes It will ask “Backup before rewriting?” select Yes Select the destination folder to backup if not already selected or simply type C:\ or D:\ or E:\ Your company is not rewritten. Open the company and enjoy your work.
Read more

Techno-Tip #9 - How to remove tally vault password?

Techno-Tip #9 by CA Ravindra Patil (92093-00789)                         (21-01-2019) How to remove tally vault password? 1.        Open company with tally vault password. 2.        Press Alt+F3 for Company Info Menu. 3.        Select Change Tally Vault option. 4.        Type Current Password. 5.        Keep Blank at rest of the fields. 6.        Select yes at "Change?" Window. 7.        It will create new Company with new number without vault password. 8.        Now you can delete old company with vault password. 9.        Open the company without vault and enjoy your work.
Read more