Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is use of $ applied on Alphabets using formula in excel ?

Microsoft Excel Computer Science Formula Language Microsoft Office Computer Skills
user-image
Question added by Imran Ahmed , Manager-Planning & Delay Analyst , Nesma United Industries (NUI) Saudi Arabia
Date Posted: 2016/07/31
Upvote (0) Views (6) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Furkan Ahmad
by Furkan Ahmad , Operations Supervisor , Naqel Express

f4 is used to lock the formula

Tomasz L
by Tomasz L , Reporting Specialist , Outworking

$ is used to block the cells (rows or columns). Very useful tool when you manipulate the formulas.

Write Your Answer
More Questions Like This