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 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 5, 2021 | Excel Tips & Tricks
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...
by Ilker | Jul 5, 2021 | Excel Tips & Tricks
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...
by Ilker | Jul 2, 2021 | Excel Tips & Tricks
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...
by Ilker | Jul 2, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to convert date to text in Excel. Download Workbook Date and time in Excel Excel stores date and time values as numbers. They will be displayed in regular date or time format, because Excel automatically applies number...
by Ilker | Jul 1, 2021 | Excel Tips & Tricks
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. Download Workbook Preparation before creating a To-Do list Start by creating a 3-column range for the to-do list. These columns...
by Ilker | Jun 28, 2021 | Excel Tips & Tricks
How to add watermark in Excel Image or video watermarks are commonly used for copyright protection or marketing. Although Excel has watermark support, it’s not very easily accessible. In this guide, we’re going to show you how to add watermark in Excel and also...
by Ilker | Jun 23, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to get filename from path in Excel. We will cover how to do this with and without VBA. Download Workbook File path and file name A file path is a string identifier that specifies the unique location in a file system. It...
