How to automate Goal Seek in Excel

How to automate Goal Seek in Excel

Goal Seek runs calculations repeatedly (iteratively) to find possible outcome values for your inputs. In this guide, we’re going to show you how to automate Goal Seek in Excel. Download Workbook Scenario Let’s take a look at a basic example. There are two inputs...
How to insert picture into cell in Excel

How to insert picture into cell in Excel

By default, images in Excel float on the worksheet. This means that you can move it freely, but you can’t fix the image within a specific cell. In this guide, we’re going to show you how to insert picture into cell in Excel. Download Workbook Before start...
How to AutoFit rows using macros in Excel

How to AutoFit rows using macros in Excel

In this guide, we’re going to show you how to autofit rows using macros in Excel. Download Workbook Autofit Method You can use the AutoFit feature by calling the method with same name: AutoFit. The AutoFit method is defined under Range object which represents a cell,...
How to AutoFit columns using macros in Excel

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. Download Workbook Autofit Method You can use the AutoFit feature by calling the method with same name: AutoFit. The AutoFit method is defined under the Range object, which represents...
How to insert a list box in Excel

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. Download Workbook Developer...
How to insert an option button in Excel

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. Download Workbook Developer Tab and Option...
How to convert text to speech in Excel

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. Download Workbook Testing text to speech Follow the steps below to quickly test the text to speech functionality. Select...
How to display fractions in Excel

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. Download Workbook Using number formatting to display fractions Excel stores and calculates any numerical value...
How to add header and footer in Excel

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...