Interrupt a Macro in Excel
You can interrupt a macro in Excel at any time by pressing Esc or Ctrl + Break.
How to use Excel
Learn how to use Excel like a pro with easy-to-follow tutorials and tips — spreadsheets, charts, pivot tables, and macros.
ROWS: 506UPDATED: OCT 2024SECTION: 01 · PAGE 5/22
October 11, 2024
How to use the Excel PMT function
The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. This page contains many easy to follow PMT examples.
Round to Nearest Multiple in Excel
This example illustrates three functions to round numbers to a multiple of x in Excel. MROUND CEILING and FLOOR.
Path and FullName Property in Excel VBA
The Path property in Excel VBA returns the complete saved path to the workbook (Excel file). The FullName property in Excel VBA returns the complete saved path including the name of the workbook.
Insert Page Numbers in Excel
This example teaches you how to insert page numbers in Excel. On the View tab in the Workbook Views group click Page Layout to switch to Page Layout view.
Currency Converter in Excel VBA
Below we will look at a program in Excel VBA which creates a Userform that converts any amount from one currency into another.
Last Day of the Month in Excel - EOMONTH function
To get the date of the last day of the month in Excel use the EOMONTH (End of Month) function.
Select Entire Rows and Columns in Excel VBA
This example teaches you how to select entire rows and columns in Excel VBA. Are you ready?
How to Filter Data in Excel
Filter your Excel data to only display records that meet certain criteria. This is page 1 of 10 in our comprehensive filtering course. Click any single cell inside a data set. On the Data tab in the Sort & Filter group click Filter.
Paste Special Shortcuts in Excel
Use the shortcut Ctrl + Alt + V to display the Paste Special dialog box in Excel. Next press an underlined letter to paste formulas values formatting etc.
Formula Bar in Excel
The formula bar in Excel displays the value or formula of the active cell. You can use the formula bar to enter or edit formulas. The formula bar is located below the ribbon and above the worksheet area.
Dynamic Array Formulas in Excel
Dynamic array formulas entered into a single cell fill multiple cells. This behavior in Excel 365/2021 is called spilling.
How to use the Excel ADDRESS function
The ADDRESS function in Excel creates a cell reference as text based on a given row and column number. By default the ADDRESS function creates an absolute reference.
Thermometer Chart in Excel
This example teaches you how to create a thermometer chart in Excel. A thermometer chart shows you how much of a goal has been achieved.
Today's Date in Excel
To enter today's date in Excel use the TODAY function. To enter the current date and time use the NOW function. To enter the current date and time as a static value use keyboard shortcuts.
Add a Trendline in Excel
This example teaches you how to add a trendline to a chart in Excel. First select the chart. Next click the + button on the right side of the chart click the arrow next to Trendline and then click More Options.
How to use TEXTSPLIT in Excel
Use the TEXTSPLIT function in Excel 365 to split text into rows or columns using delimiters. This guide teaches you how to use the TEXTSPLIT function starting with simple text splits and moving on to more advanced formulas.
Instr Function in Excel VBA
Use Instr in Excel VBA to find the position of a substring in a string. The Instr function is quite versatile.
Solver in Excel
Excel includes a tool called Solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
How to use the Excel COUNTIF function
The powerful COUNTIF function in Excel counts cells based on one criteria. This page contains many easy to follow COUNTIF examples.
Separate Strings in Excel VBA
Below we will look at a program in Excel VBA that separates strings.
Function Keys in Excel
Function keys in Excel allow you to do things with your keyboard instead of your mouse to increase your speed.
Prime Number Checker in Excel VBA
Below we will look at a program in Excel VBA that checks whether a number is a prime number or not.
Substring in Excel
There's no SUBSTRING function in Excel. Use MID LEFT RIGHT FIND LEN SUBSTITUTE REPT TRIM and MAX in Excel to extract substrings.