# Solid geometry formulas sheet in Excel (free)

> Free Excel sheet for solid geometry: area and volume formulas for nine solids with solved examples, Euler's table, 13 calculators and a 40-question quiz.

Source: https://softwiro.com/blog/solid-geometry-rules-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Solid geometry rules in Excel (free): areas and volumes with examples and a calculator

Nine solids with lateral area, total area, volume and a solved example, plus calculators with a unit setting, a quiz and review dates.

15 November 2026 5 min read

## In short

- Nine solids with lateral area, total area, volume, diagonal and a solved example for each.
- Fourteen facts about lines and planes, and a table of ten polyhedra checking V - E + F = 2.
- Thirteen calculators with a length-unit setting, volume in litres, an angle between a line and a plane, and unit conversions.
- A 40-question self-test with a hidden answer key and a score per branch.
- A general summary, not an official syllabus; check your school textbook.

You want to review the area and volume formulas before the exam in one place: each solid's formula with its symbols, a solved example, then your own dimensions with the unit checked. The free [solid geometry rules sheet](https://softwiro.com/templates/solid-geometry-rules) does that for nine solids, with facts about lines and planes and Euler's formula. It is a general summary, not an official syllabus for any particular grade; check your school textbook.

## The problem it solves

A student knows the volume of a cylinder is πr²h and then slips in applying it: using the diameter instead of the radius, mixing the slant height with the vertical height in a cone or pyramid, adding the base area once instead of twice for a prism, or writing a volume in square units. The formulas are scattered across a textbook and a notebook. The sheet puts each solid in one row and a solved example beside it.

## How the sheet works, step by step

1. Open المجسمات (Solids) and review the solid you are studying: symbols, lateral area, total area, volume and its solved example.
2. Open حقائق وأويلر (Facts and Euler) to review facts about lines, planes and angles and the table of vertices, edges and faces.
3. Pick the solid in بحث (Lookup) and its formulas and example appear.
4. In حاسبات (Calculators) choose the length unit, then type the solid's dimensions and the areas, the volume and the volume in litres appear.
5. Take the 40-question اختبار ذاتي (Self-test) and log your score in المتابعة (Progress).
6. Open الملخص (Summary) to see each solid's volume from the examples, the growth of volume with radius, and your result.

## What is in each sheet

- Solids: 9 solids: cube, cuboid, right prism, cylinder, regular pyramid, cone, sphere, hemisphere and frustum of a cone.
- Facts and Euler: 14 facts about lines and planes, and a table of ten polyhedra that calculates V − E + F.
- Calculators: 13 calculators, including the angle between a line and a plane and volume and area conversions.
- Self-test, Progress and Summary: questions with a hidden answer key, review dates, and your result per branch with four charts.

## Walk-through on the sample numbers (sample data)

The figures below come from the sample copy inside the sheet, in cm, which is what you see before typing anything.

- Cube: edge 5 gives a total surface area of 150 and a volume of 125, which is 0.125 litres.
- Cuboid 6 × 4 × 3: total area 108, volume 72 and diagonal about 7.8102.
- Prism: base area 6, base perimeter 12 and height 10 give a lateral area of 120, a total area of 132 and a volume of 60.
- Cylinder r = 7, h = 10: total area about 747.70 and volume about 1539.38 cm³, which is about 1.5394 litres.
- Regular pyramid with a square base of side 6 and height 4: slant height 5, total area 96 and volume 48.
- Cone r = 3, h = 4: slant height 5, total area about 75.40 and volume about 37.70.
- Sphere r = 6: surface area about 452.39 and volume about 904.78. The hemisphere has a volume of about 452.39 and a total area of about 339.29.
- Frustum R = 5, r = 2, h = 4: slant height 5, volume about 163.36 and total area about 201.06.
- Angle, conversion and Euler: a line with a vertical distance of 3 and a projection of 4 has length 5 and makes an angle of about 36.87 degrees with the plane. 2500 cm³ is 2.5 litres, and for the cube 8 − 12 + 6 = 2.
- Sample quiz: 35 of the 40 questions are answered and 27 are correct, so the score is 67.5% of all questions. By branch: cube and prism 7 of 12, cylinder and cone 8 of 12, pyramid and sphere 7 of 9, facts, Euler and units 5 of 7.
- Progress: three topics are due for review on 2026-11-15, and the average progress score is 70.0%.

## Common mistakes

- Mixing the two heights: volume uses the vertical height h, while the lateral area of a cone or pyramid uses the slant height l.
- Diameter instead of radius: r is the radius and the diameter is twice that.
- Forgetting both bases: the total area of a prism or cylinder adds the area of two bases, not one.
- Units of volume: area is in square units (cm²) and volume in cubic units (cm³); every 1000 cm³ is one litre.
- The hemisphere: its total area is 3πr², the curved surface 2πr² plus the base πr².

## When to move from the sheet to a system

The sheet is enough for a student revising alone or a teacher preparing a summary for a class. If you want to follow dozens of students, with an interactive drawing of the solid, step-by-step solutions and a dashboard showing the class's weak formulas, that needs a program with a login for each user, and Softwiro can [build one your way](https://softwiro.com/contact). To organise study time try the [study planner sheet](https://softwiro.com/templates/study-planner), and to record exam dates the [exam schedule sheet](https://softwiro.com/templates/exam-schedule). These pages are in Arabic.

## Next step

Download the sheet and pick one solid you have not mastered. Read its example in "Solids", enter dimensions from your textbook in "Calculators" and compare with the book's answer, take the quiz and log your score in "Progress". You then have your first written review date.

## Common questions

**Does the sheet match my grade's syllabus?** It is a general summary, not an official syllabus for any particular grade; check your school textbook, since some books take π = 22/7.

**How do I change the unit?** Pick mm, cm, dm or m in the top cell of "Calculators".

**Which solids does Euler's formula hold for?** Convex polyhedra.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: solid geometry (1/3)](https://softwiro.com/uploads/cheatsheets/solid-geometry-rules/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/solid-geometry-rules/en-1.jpg)[![Cheat sheet: solid geometry (2/3)](https://softwiro.com/uploads/cheatsheets/solid-geometry-rules/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/solid-geometry-rules/en-2.jpg)[![Cheat sheet: solid geometry (3/3)](https://softwiro.com/uploads/cheatsheets/solid-geometry-rules/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/solid-geometry-rules/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### Does the sheet match my grade's syllabus?

It is a general summary, not an official syllabus for any particular grade; check your school textbook. Some books take pi as 22/7 or 3.14 while the sheet uses the exact value, so the last decimals can differ from your book's answer.

### How do I change the length unit?

In the Calculators sheet pick the unit (mm, cm, dm or m) in the top cell. Areas then show in square units such as cm², volumes in cubic units such as cm³, and the volume in litres is worked out from the unit you chose.

### Which solids does Euler's formula hold for?

V - E + F = 2 holds for convex polyhedra, including prisms, pyramids and the ten solids in the table. You can type the counts of any other solid into the Euler calculator to check.

### How do I type my answer in the quiz?

Type the result as a number with no unit, to two decimals, or the coefficient of pi where the question asks for it; it is accepted within a tolerance of 0.02. For choice questions pick from the drop-down.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
