Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 28 of 60 · 540 articles
How to count cells by font color in Excel
In this guide, we're going to show you how to count cells by font color in Excel.
How to count colored cells in Excel
In this guide, we're going to show you how to count colored cells in Excel.
How to refer a range or a cell in Excel VBA
Learn how to refer a range or a cell in Excel VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to fill blank cells simultaneously using Find & Select in Excel
Learn how to fill blank cells simultaneously using Find & Select in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to format numbers as file sizes in Excel
In this guide, you'll learn how to format numbers as file sizes in Excel with help of custom number formatting and conditional formatting.
How to populate alphabet letters in Excel in 3 ways
In this guide, we're going to show you how to populate Alphabet letters in Excel. This article contains SEQUENCE, CHAR and CODE functions.
How to remove all rows containing specific value in Excel
Learn how to remove all rows containing specific value in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create recursive functions in Excel with LAMBDA
In this guide, we're going to show you how to create recursive functions in Excel with help of LAMBDA Function.
How to calculate the Ackermann function in Excel
In this guide, we're going to show you how to calculate Ackermann function in Excel with the LAMBDA function.