Friday, March 8, 2019

Excel sheet trics

1. Absolute reference

Absolute Reference

See the formula in cell E3 below.
1. To create an absolute reference to cell H3, place a $ symbol in front of the column letter and row number ($H$3) in the formula of cell E3.


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)