Categorize Numbers Form For Free

Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done.

Organize your data in a new way with smart categories. For example, if you track business sales in a spreadsheet, create a category that groups sales by department. You can also add subcategories, summarize categorized data, create charts based on the categories in your table, and more.

Create groupsSelect the rows you want to group in your table.Move the pointer over the empty square to the left of the selection, click the arrow that appears, then choose Create Group for Selected Rows. The new group is given a placeholder name, such as Group 1, in the source column and in the summary row.

Create a category with existing dataTap or click the table you want to categorise, tap or click the Organise button and then click or tap Categories.Tap or click Add a Category.Choose a column from the list.Click or tap the Disclosure triangle next to a group name to collapse or expand the rows in that group.Oct 8, 2021

Modify axis labelsTap the chart, then tap .Tap Style, then tap Labels.Do any of the following: Modify markings on the Value (Y) axis: Tap Value Labels under Value (Y) Axis.Use the controls to make any adjustments.If you turn on Axis Name, Numbers adds a placeholder axis name to the chart.

Types of numbersNatural Numbers (N), (also called positive integers, counting numbers, or natural numbers); They are the numbers {1, 2, 3, 4, 5, 2026}Whole Numbers (W).Integers (Z).Rational numbers (Q).Real numbers (R), (also called measuring numbers or measurement numbers).

Sort data in a columnTap the table, then tap the letter above the column with the data you want to sort by.Tap. at the bottom of the screen, then tap an option: Sort Ascending: Sorts the table rows in alphabetical order (A to Z) or by increasing numerical values based on the data in the selected column.