Determine the Excel Printing Area

Determine the Excel Printing Area

Continuing the previous post related to the Page Setup – Sheet command window, we will discuss the Print Area or the printing area of ​​the excel worksheet. This Print Area is one of the printing tricks in Excel that we can do by determining the printing area that we want.

To open the Page Setup – Sheet command window, go to the Page Layout > Page Setup menu and select the Sheet tab.

http://www.excel-foraccounting.com/determine-excel-printing-area.html

Looking for Maximum and Minimum Values

Looking for Maximum and Minimum Values

The following excel formula trick is how to find a value, maximum and minimum value in a range of values. This trick can be used by school teachers who are accustomed to processing student data related to the highest and lowest grades of students, or by anyone who wants to determine the lowest and highest data values ​​as analysis material, such as sales value and so on.

For more details, how can I illustrate this case as shown in the following table.

http://www.excel-foraccounting.com/maximum-minimum-values.html