Resources
How to AutoFit columns using macros in Excel
In this guide, we’re going to show you how to autofit columns using macros in Excel. Autofit...
How to insert a list box in Excel
List boxes are form controls that allow you to see all options at once. You can set a list box to force the user select only one option or allow multiple selections. In this guide, we’re going to show you how to insert a list box in Excel. [button...
How to insert an option button in Excel
Option buttons are a common input control in forms. It allows the users to see all available options and ensure that only one option is selected. In this guide, we’re going to show you how to insert an option button in Excel. [button...
How to convert text to speech in Excel
Excel has supported text-to-speech since 2003. In this guide, we’re going to show you how to convert text to speech in Excel using commands or VBA. [button link="https://www.spreadsheetweb.com/wp-content/uploads/2021/07/How-to-convert-text-to-speech-in-Excel.zip"...
How to display fractions in Excel
Excel usually converts fractions automatically when you enter a date or text value. In this guide, we’re going to show you how to display fractions in Excel. [button...
How to add header and footer in Excel
Because Excel is not a word processor, you may not think if you can add header and footer to your print pages. But you can add and customize them almost you can do in Word. In this guide, we’re going to show you how to add header and footer in Excel. Header and Footer...
How to convert date to text in Excel
In this guide, we’re going to show you how to convert date to text in Excel. Date and time in Excel...
How to create a To-Do list in Excel
In this guide, we’re going to show you how to create a To-Do list in Excel with the help of checkbox controls and conditional formatting. [button link="https://www.spreadsheetweb.com/wp-content/uploads/2021/07/How-to-create-a-To-Do-list-in-Excel.xlsx" type="big"...
How to insert a checkbox in Excel
Checkbox type of input controls are commonly used for answering Yes/No questions, True/False questions, or just checking items off a list. In this guide, we’re going to show you how to insert a checkbox in Excel. [button...