Skip to content

Excel 2016 – mixed references

October 13, 2017

Understanding absolute and relative references in Excel is critical.  You can either lock in a cell address in a formula with the F4 key (PC) or CMT T (mac).  You can also lock in a row or a column.  Video details this:

Advertisements

From → Excel, PC tips

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: