Using Excels CELL Function To Track Changes To Your Workbook

51Likes

41,948Views

2014Feb 24

While most Excel users have likely never used the CELL function, it can be extremely useful in providing information about a specific cell or about the last cell changed in the workbook. In this short tip, you will learn how to use CELL to track changes to your workbook, including the last cell changed and the new value in that cell.

Info Type and Reference

0:33

Contents Address and File Name

0:58

Track the Last Cell Changed in a Workbook

1:49

Watch Window

2:47

Transcript

Follow along using the transcript.

K2 Enterprises

5.09K subscribers

K2's Best Practices For Formatting Excel PivotTables

K2 Enterprises

399 views3 years ago

Using Excels CELL Function To Track Changes To Your Workbook

Key moments View all

Info Type and Reference

Info Type and Reference

Info Type and Reference

Contents Address and File Name

Contents Address and File Name

Contents Address and File Name

Track the Last Cell Changed in a Workbook

Track the Last Cell Changed in a Workbook

Track the Last Cell Changed in a Workbook

Watch Window

Watch Window

Watch Window

K2 Enterprises

Using Excels CELL Function To Track Changes To Your Workbook

Key moments

Info Type and Reference

Info Type and Reference

Info Type and Reference

Contents Address and File Name

Contents Address and File Name

Contents Address and File Name

Track the Last Cell Changed in a Workbook

Track the Last Cell Changed in a Workbook

Track the Last Cell Changed in a Workbook

Watch Window

Watch Window

Watch Window

Description

Key moments View all

Info Type and Reference

Info Type and Reference

Info Type and Reference

Contents Address and File Name

Contents Address and File Name

Contents Address and File Name

Track the Last Cell Changed in a Workbook

Track the Last Cell Changed in a Workbook

Track the Last Cell Changed in a Workbook

Watch Window

Watch Window

Watch Window

K2 Enterprises

Transcript

K2's Best Practices For Formatting Excel PivotTables

Key moments

Key moments