How to use Excel
October 10, 2024Sort a Range in Excel VBA
You can use the Sort method in Excel VBA to sort ranges in Excel. This article provides clear and practical examples to help you get started with sorting ranges using Excel VBA.
Library
Page 7 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 7/29
How to use Excel
October 10, 2024Percentage Discount in Excel
If you know the original price and the discounted price you can calculate the percentage discount. If you know the original price and the percentage discount you can calculate the discounted price etc.
How to use Excel
October 10, 2024StatusBar Property in Excel VBA
The StatusBar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro. This way you can let the user know that a macro is still running.
How to use Excel
October 10, 2024Convert Numbers to Text in Excel
In Excel numbers are right-aligned and text is left-aligned. This example teaches you how to convert numbers to 'text strings that represent numbers'.
How to use Excel
October 10, 2024Create a Calendar in Excel
This example describes how to create a calendar in Excel (2024 calendar 2025 calendar etc). If you are in a hurry simply download the Excel file.
How to use Excel
October 10, 2024How to AutoFit Columns in Excel
You probably know how to change the width of a column in Excel but do you also know how to automatically fit the widest entry in a column?
How to use Excel
October 10, 2024Loan Calculator in Excel VBA
This page teaches you how to create a simple loan calculator in Excel VBA. The worksheet contains the following ActiveX controls: two scrollbars and two option buttons.
How to use Excel
October 10, 2024How to use the Excel SWITCH function
The SWITCH function in Excel looks up a specified value in a list of values and returns the result corresponding to the first match found.
How to use Excel
October 10, 2024Share Excel Data with Word Documents
Learn how to share Excel data with Word documents and other files.
How to use Excel
October 10, 2024Option Explicit in Excel VBA
We strongly recommend to use Option Explicit at the start of your Excel VBA code. Using Option Explicit forces you to declare all your variables.
How to use Excel
October 10, 2024Negative Numbers to Zero - Excel Formula
A clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.
How to use Excel
October 10, 2024Step Keyword in Excel VBA (Easy For Loop)
You can use the Step keyword in Excel VBA to specify a different increment for the counter variable of a loop.
How to use Excel
October 10, 2024Zoom in and out in Excel
In most cases you can use the minus and plus symbols in the status bar to quickly zoom the document. Use the buttons on the View tab to zoom to a specific percentage and to zoom to a selection.
How to use Excel
October 10, 2024Freeze Panes in Excel
If you have a large table of data in Excel it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.
How to use Excel
October 10, 2024How to Calculate Age in Excel
To calculate age in Excel use the DATEDIF function and TODAY. You can also use the age formula further down to calculate a person’s exact age in years months and days. Enter the date of birth into cell A2.
How to use Excel
October 10, 2024Password Protect an Excel File
Encrypt an Excel file with a password so that it requires a password to open it. To password protect an Excel file execute the following steps.
How to use Excel
October 10, 2024Days until Birthday in Excel
To calculate the number of days until your birthday in Excel execute the following steps.
How to use Excel
October 10, 2024Custom Average Function in Excel VBA
Below we will look at a program in Excel VBA which creates a user defined function that calculates the average of a randomly selected range excluding one or more values that are outliers and shouldn't be averaged.
How to use Excel
October 10, 2024Create a Bar Chart in Excel
A bar chart is the horizontal version of a column chart. Use a bar chart if you have large text labels. To create a bar chart in Excel execute the following steps.
How to use Excel
October 10, 2024Formula Errors in Excel
This chapter teaches you how to deal with some common formula errors in Excel. Let's start simple.
How to use Excel
October 10, 2024Absolute Value in Excel
The ABS function in Excel returns the absolute value of a number. In other words: the ABS function removes the minus sign (-) from a negative number making it positive.
How to use Excel
October 10, 2024CurrentRegion Property in Excel VBA
This example illustrates the CurrentRegion property in Excel VBA. The current region is a range bounded by any combination of blank rows and blank columns.
How to use Excel
October 10, 2024AutoRecover in Excel
Excel periodically saves a copy of your Excel file. Learn how to recover a file that was never saved and how to recover a file that has been saved at least once.
How to use Excel
October 10, 2024Cell Background Colors in Excel VBA
Changing background colors in Excel VBA is easy. Use the Interior property to return an Interior object. Then use the ColorIndex property of the Interior object to set the background color of a cell.