Excel.Xpress

ACCESSING YOUR WORKBOOK STATISTICS

Workbook Statistics is an amazing feature in Excel that provides you with the counts and other information about your current worksheet and the entire workbook.

For instance, if you receive a workbook from a colleague and you want to know how many sheets it contains without scrolling through, try Workbook Statistics and get the result in splits of seconds.

STEPS:
1. Select the "Review" tab as highlighted on the attached image

2. Select "Workbook Statistics" which is directly under the "Insert" tab

Automatically, the information displays.

Shortcut Keys: Ctrl + Shift + G

NOTE: This same method of accessing Workbook Statistics is not available in Excel 2013 and older versions.

Try this out and share the valuable information you got about your workbooks/worksheets.

There are basically 2 types of References in Excel. Relative and Absolute References. To expressly switch between Relative and Absolute, use F4 key.