Cm to inches in Excel (Easy Converter)
1 cm = 0.3937 inch and 1 inch = 2.54 cm. Use a simple formula the CONVERT function or download our free unit converter to convert from cm to inches or vice versa.
How to use Excel
Learn how to use Excel like a pro with easy-to-follow tutorials and tips — spreadsheets, charts, pivot tables, and macros.
ROWS: 506UPDATED: OCT 2024SECTION: 01 · PAGE 4/22
October 11, 2024
Count Cells with Text in Excel - Easy Formulas
This page illustrates multiple ways to count cells with text in Excel. Visit our page about the COUNTIF function to count cells that contain specific text.
Range Object in Excel VBA
The Range object which is the representation of a cell (or cells) on your worksheet is the most important object of Excel VBA. This chapter gives an overview of the properties and methods of the Range object.
Paste Options in Excel
This example illustrates the various paste options in Excel. Cell B5 below contains the SUM function which calculates the sum of the range B2:B4. Furthermore we changed the background color of this cell to yellow and added borders.
InputBox Function in Excel VBA
You can use the InputBox function in Excel VBA to prompt the user to enter a value.
Dependent Combo Boxes in Excel VBA
Below we will look at a program in Excel VBA which creates a Userform that contains dependent combo boxes.
How to Roll two Dice in Excel
This example teaches you how to simulate the roll of two dice in Excel. If you are in a hurry simply download the Excel file.
Copy Visible Cells Only in Excel
By default Excel copies both visible and hidden cells. However it is possible to copy visible cells only.
Standard Deviation in Excel
This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using the STDEV.S function in Excel.
Two-column Lookup in Excel
This example teaches you how to perform a two-column lookup in Excel. See the example below. We want to look up the salary of James Clark not James Smith not James Anderson.
Weekday Formulas in Excel
Use WEEKDAY NETWORKDAYS and WORKDAY to create cool weekday formulas in Excel. Are you ready to improve your Excel skills?
How to Change Case in Excel
To change the case of text in Excel use LOWER UPPER or PROPER. If you're not a formula hero use Flash Fill to change case in Excel.
Cell Styles in Excel
Quickly format a cell by choosing a cell style. You can also create your own cell style in Excel. Quickly format a range of cells by choosing a table style.
How to Unhide Sheets in Excel
Unhiding sheets in Excel is easy. A workbook must contain at least one visible worksheet. To unhide sheets execute the following steps.
How to Print Sheets in Excel
This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.
Worksheets in Excel
A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
Weekdays in Excel VBA
Below we will look at a program in Excel VBA that calculates the number of weekdays between two dates.
Logical Operators in Excel VBA
The three most used logical operators in Excel VBA are: And Or and Not. As always we will use easy examples to make things more clear.
Sum with Or Criteria - Excel Formulas
Summing with Or criteria in Excel can be tricky. This article shows several easy to follow examples.
Workbook Themes in Excel
Excel offers themes to change the look of your workbook with the click of a button. Each theme consists of 12 colors two fonts (Headings and Body) and effects for shapes and SmartArt.
DateDiff Function in Excel VBA
The DateDiff function in Excel VBA can be used to get the number of days weeks months or years between two dates. You can also use the DateDiff function to calculate the time difference between two times.
Font Color in Excel VBA
The Font property of the Range object in Excel VBA gives access to a lot of other properties. That is because the Font property returns an object itself; the Font object. The Font object has many properties like the Color property and the Bold property.
t-Test in Excel
This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal.
Use Relative References in Excel VBA
By default Excel records macros in absolute mode. However sometimes it is useful to record macros in relative mode. This program teaches you how to do this. If you don't know how to record a macro we highly recommend you to read this example first.