Excel resources

Excel Tips & Tricks

Articles, examples, and practical guidance from the SpreadsheetWeb team.

Page 40 of 60 · 540 articles

how to calculate percentage in excel
Ilker · Oct 1, 2019

How to calculate percentage in Excel

In this article, we are going to show you how to calculate percentage in Excel. You can show numbers as percentages without any calculation.

cm to inches
Ilker · Sep 24, 2019

How to convert cm to inches, and vice versa

In this guide, we are going to show you how to convert cm to inches and inches to centimeters using Excel, with the help of various methods.

How to create check boxes in Excel (Tick boxes)
Ilker · Sep 13, 2019

How to create check boxes in Excel (Tick boxes)

In this guide, we're going to show you how to create check boxes in Excel and customize them.

How to create radio buttons in Excel
Ilker · Sep 12, 2019

How to create radio buttons in Excel (Option Buttons)

In this guide, we are going to show you how to create radio buttons (option buttons) in Excel.

Ilker · Sep 10, 2019

How to create a bell curve in Excel

In this guide, we are going to show you how to create a bell curve in Excel with a real world use case scenario as an example.

center across selection
Ilker · Sep 3, 2019

How to use Center Across Selection, an alternative to Merge Cells

In this guide, we are going to show you how to use Center Across Selection in Excel, an alternative to Merge Cells.

change text orientation in excel
Ilker · Sep 2, 2019

How to change text orientation in Excel

In this guide, we are going to show you how to change text orientation in Excel and use angled headers through different methods.

hide zeros in excel
Ilker · Aug 29, 2019

How to hide zeros in Excel

In this guide, we’re going to show you how to hide zeros in Excel with the use of three different methods that cover cells or worksheet.

tab navigation
Ilker · Aug 23, 2019

How to navigate between worksheets in Excel

In this guide, we are going to show you various methods for tab navigation between worksheets in Excel using shortcuts and hyperlinks.