Excel Tricks. Locking in Cell References by paulag

View this thread on: hive.blog | peakd.com | ecency.com

excel · @paulag · Jun 21 '17 (edited)

$1.36

Excel Tricks. Locking in Cell References

Locking in cell references in Excel allows you copy formulas but keep certain cells locked. It allows you build dynamic formulas.

 A locked in cell is known as an absolute cell reference.  

If the cell is not locked in it is known as a relative cell reference.

Every Excel user should know how to do this

<iframe width="560" height="315" src="https://www.youtube.com/embed/TqtmmJSjrLs" frameborder="0" allowfullscreen></iframe>


If you liked this video please do upvote and follow me to learn more on Excel @paulag

👍 minnowsupport, masaa, clayboyn, heretickitten, paul-gillbanks, nuagnorab, lances, diana.catherine, maninayton, swolesome, goingmobile, guiltyparties, kingmotan, looftee, fisteganos, banjo, elliotjgardner, luishurtado39, worldtraveler, hopehuggs, ethical-ai, jhermanbeans, jwmackay, dianargenti, whatamidoing, jeanelleybee, strem, rouketas, varunsangwan, qwasert, aneeb, sidwrites, steemitboard, fronttowardenemy, albertvhons, stefan.steynberg, gbenga, abcdoctor, beng05

`author`	paulag
`permlink`	excel-tricks-locking-in-cell-references
`category`	excel
`json_metadata`	{"tags":["excel","business","video","whalepower","tutorial"],"users":["paulag"],"image":["https://img.youtube.com/vi/TqtmmJSjrLs/0.jpg"],"links":["https://www.youtube.com/embed/TqtmmJSjrLs"],"app":"steemit/0.1","format":"markdown"}
`created`	2017-06-21 09:29:00
`last_update`	2017-06-21 09:58:48
`depth`	0
`children`	5
`last_payout`	2017-06-28 09:29:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	1.074 HBD
`curator_payout_value`	0.282 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	519
`author_reputation`	274,264,287,951,003
`root_title`	"Excel Tricks. Locking in Cell References"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	5,476,729
`net_rshares`	96,191,606,202
`author_curate_reward`	""

properties (23)vote details (39)

voter	rshares	pct
paul-gillbanks	1,340,759,343	1%
diana.catherine	803,115,619	0.85%
rouketas	173,122,758	8.59%
heretickitten	1,407,692,415	1.71%
ethical-ai	372,383,158	8.59%
jhermanbeans	313,960,229	0.85%
worldtraveler	409,384,758	1.71%
clayboyn	2,352,905,412	8.59%
dianargenti	239,736,667	0.85%
hopehuggs	386,798,906	0.85%
swolesome	702,905,009	5.15%
fisteganos	506,438,717	0.85%
stefan.steynberg	76,227,106	2.57%
steemitboard	110,268,599	2%
maninayton	783,069,322	1.71%
lances	818,527,626	0.85%
banjo	467,904,433	8.59%
fronttowardenemy	91,921,507	0.85%
varunsangwan	156,891,562	4.29%
gbenga	65,353,047	0.85%
goingmobile	673,384,361	4.29%
looftee	544,301,798	0.85%
sidwrites	135,012,244	0.85%
jwmackay	279,861,599	1.71%
albertvhons	80,908,436	0.85%
abcdoctor	58,995,424	8.59%
whatamidoing	205,781,650	2.57%
luishurtado39	428,484,640	8.59%
jeanelleybee	202,373,884	8.59%
beng05	54,653,275	8.59%
masaa	8,754,287,410	20%
qwasert	155,616,730	1.71%
guiltyparties	620,611,073	100%
nuagnorab	1,165,087,912	100%
strem	186,510,282	8.59%
minnowsupport	69,903,859,044	8.59%
aneeb	145,088,159	100%
elliotjgardner	431,267,100	8.59%
kingmotan	586,154,988	100%

@masaa · Jun 21 '17 (edited)

$0.62

Absolutely helpful.  Waiting for more. Will have to watch again.

👍 masaa

`author`	masaa
`permlink`	re-paulag-excel-tricks-locking-in-cell-references-20170621t111930068z
`category`	excel
`json_metadata`	{"tags":["excel"],"app":"steemit/0.1"}
`created`	2017-06-21 11:19:39
`last_update`	2017-06-21 11:20:21
`depth`	1
`children`	1
`last_payout`	2017-06-28 11:19:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.618 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	64
`author_reputation`	93,435,805,483
`root_title`	"Excel Tricks. Locking in Cell References"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	5,485,009
`net_rshares`	44,063,246,633
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
masaa	0 B		44,063,246,633	100%

@paulag · Jun 21 '17

Thank you so much.  I was starting to wonder if my Excel posts were reaching anyone!  Please resteem and help me get reach

properties (22)

`author`	paulag
`permlink`	re-masaa-re-paulag-excel-tricks-locking-in-cell-references-20170621t112625777z
`category`	excel
`json_metadata`	{"tags":["excel"],"app":"steemit/0.1"}
`created`	2017-06-21 11:26:18
`last_update`	2017-06-21 11:26:18
`depth`	2
`children`	0
`last_payout`	2017-06-28 11:26:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	122
`author_reputation`	274,264,287,951,003
`root_title`	"Excel Tricks. Locking in Cell References"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	5,485,576
`net_rshares`	0

@nuagnorab · Jun 21 '17

$0.03

Great content! Would love to see more especially how to tackle specific business problems.

👍 paulag, nuagnorab

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
nuagnorab	0 B		1,174,997,338	100%
paulag	0 B		1,316,136,953	100%

@paulag · Jun 21 '17

Thank you @nuagnorab.  I hope to cover a lot, from Excel to Excel Power Tools and Power BI.  Hope you enjoy the posts :-)

properties (22)

`author`	paulag
`permlink`	re-nuagnorab-re-paulag-2017621t2153400z-20170621t195145836z
`category`	excel
`json_metadata`	{"tags":["excel"],"users":["nuagnorab"],"app":"steemit/0.1"}
`created`	2017-06-21 19:51:39
`last_update`	2017-06-21 19:51:39
`depth`	2
`children`	0
`last_payout`	2017-06-28 19:51:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	121
`author_reputation`	274,264,287,951,003
`root_title`	"Excel Tricks. Locking in Cell References"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	5,538,404
`net_rshares`	0

@paul-gillbanks · Jun 22 '17

If you haven't Register your membership , please do so.

This post have been Prove Read , Upvoted & Manual Curated.
Thanks for using #whalepower Tag and share with the Whale Power Community, Upvote , Reblogged , comment when ever you can.
Curated By @paul-gillbanks for #whalepower Tag
Founder @bullionstackers
Latest Blog – Please Click to Read
* [Compulsory Free #whalepower Registration Membership](https://steemit.com/whalepower/@bullionstackers/compulsory-to-register-for-exclusive-free-membership-for-hf19)
* [@bullionstackers Joint Ventures with @paul-gillbanks in #whalepower Curation](https://steemit.com/whalepower/@paul-gillbanks/good-news-for-whalepower-community)

properties (22)