Home // Blog & Excel Tips // Including Max and Min in your Status Bar

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Including Max and Min in your Status Bar

Comments Closed
Uncategorised

In the newer versions of Excel, the Status Bar (bottom right portion of screen which shows the SUM and AVERAGE if you highlight a group of number cells) can be customised to include a number of useful calculations. In Excel 2003, you had to choose either SUM or AVERAGE or COUNT etc. Only one at a time.

Now in Excel 2007 and Excel 2010, you can include all these items to see them at the same time. So when you highlight a group of number cells you can see:

Average,

Count,

Numerical Count,

Maximum,

Minimum, and

Sum.

This means that you can quickly get a sense of a group of cells without building formula (or pulling out your calculator!)

 

Learn more at our live advanced Excel courses in South Africa. Visit www.AuditExcel.co.za Live Excel Training page