SpreadsheetWeb blog
Practical thinking for spreadsheet-powered teams
Deep guides on Excel, Google Sheets, web applications, product workflows, and the quiet technical traps worth knowing about.
Page 25 of 55 · 1315 articles
How to insert a Slider in Excel
A slider is a control to select a numeric value from a range. In this guide, we’re going to show you how to insert a slider in Excel.
How to insert a button in Excel
Learn how to insert a button in Excel. This practical guide covers the required setup, step-by-step process, and useful Excel options.
Function: QUOTIENT
In this guide, we’re going to show you how to use the QUOTIENT function and also throw in some tips and error handling methods.
How Big is the Global Low-Code/No-Code Market and How Fast is it Growing?
A focused overview of how Big is the Global Low-Code/No-Code Market and How Fast is it Growing, explaining the main ideas, practical considerations, and relevant examples.
How to send email in Excel
In this guide, we’re going to show you how to send email in Excel.
How to insert a toggle in Excel
In this guide, we’re going to show you how to insert a toggle in Excel.
How to automate Goal Seek in Excel
In this guide, we’re going to show you how to automate Goal Seek in Excel.
How to AutoFit rows using macros in Excel
Learn how to autoFit rows using macros in Excel. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to AutoFit columns using macros in Excel
Learn how to autoFit columns using macros in Excel. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to insert a list box in Excel
In this guide, we’re going to show you how to insert a list box in Excel.
How to insert an option button in Excel
In this guide, we’re going to show you how to insert an option button in Excel.
How to convert text to speech in Excel
In this guide, we’re going to show you how to convert text to speech in Excel with either commands or VBA macros.
How to display fractions in Excel
In this guide, we’re going to show you how to display fractions in Excel and way of use fraction numbers in text.
How to convert date to text in Excel
n this guide, we’re going to show you how Excel evaluates date and time and ways to convert date to text in Excel.
How to create a To-Do list in Excel
Learn how to create a To-Do list in Excel. This practical guide covers the required setup, step-by-step process, and useful Excel options.
How to insert a checkbox in Excel
In this guide, we’re going to show you how to insert a checkbox, also known as a tick box or checkmark box or selection box in Excel.
How to save Excel charts as image
In this guide, we’re going to show you how to save Excel charts as image and ways of exporting to other softwares.
How to add watermark in Excel
In this guide, we’re going to show you how to add watermark in Excel as well as the way of removing it.
How to get filename from path in Excel
Learn how to get filename from path in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to display File Open dialog in VBA
In this guide, we’re going to show you how to display File Open dialog in VBA along with filtering and multi-selection samples.
How to open workbook in VBA
In this guide, we’re going to show you how to open workbook in VBA and example usage scenario.
How to insert specific number of columns in Excel
In this guide, we’re going to show you how to insert specific number of columns in Excel dynamically with VBA.
How to insert specific number of rows in Excel
In this guide, we’re going to show you how to insert specific number of rows in Excel dynamically with VBA.
How to use regular expressions in Excel
In this guide, we’re going to show you how to use regular expressions in Excel with example VBA codes and scenarios.