Excel Tips and Tricks
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://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 link="https://spreadsheetweb.com/wp-content/uploads/2021/07/How-to-display-fractions-in-Excel.xlsx"...
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://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...
How to save Excel charts as image
Excel is one of the most common platforms for creating charts. In this guide, we’re going to show you how to save Excel charts as an image. [button link="https://spreadsheetweb.com/wp-content/uploads/2021/06/How-to-save-Excel-charts-as-image.xlsx " type="big"...