by Ilker | Jul 15, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to compress Excel files without using a third-party software. Remove unnecessary data Here are some tips for removing unnecessary data in your workbook. Diagnose your worksheets and get rid of any irrelevant data. Consider...
by Ilker | Jul 12, 2021 | Excel Tips & Tricks
You can’t send emails directly form Excel, but there are a few ways to trigger the default mail client on your computer. In this guide, we’re going to show you how to send email in Excel. Download Workbook Send email with attachment If you want to send the file...
by Ilker | Jul 9, 2021 | Excel Tips & Tricks
A toggle button allows selecting from two options: They are like on/off switches or Play/Pause buttons. In this guide, we’re going to show you how to insert a toggle in Excel. Download Workbook Excel supports toggle buttons as development tools.You can assign them...
by Ilker | Jul 8, 2021 | Excel Tips & Tricks
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...
by Ilker | Jul 8, 2021 | Excel Tips & Tricks
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...
by Ilker | Jul 7, 2021 | Excel Tips & Tricks
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,...
by Ilker | Jul 7, 2021 | Excel Tips & Tricks
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...
by Ilker | Jul 6, 2021 | Excel Tips & Tricks
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...
by Ilker | Jul 6, 2021 | Excel Tips & Tricks
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...
