How to use Excel
October 8, 2024Close and Open Workbooks in Excel VBA
The Close and Open Method in Excel VBA can be used to close and open workbooks. Remember the Workbooks collection contains all the Workbook objects that are currently open.
Library
Page 17 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 17/29
How to use Excel
October 8, 2024Import/Export Text Files - Excel Tutorial
This article describes how to import or export text files in Excel. Text files can be comma separated (.csv) or tab separated (.txt)
How to use Excel
October 8, 2024How to use XLOOKUP in Excel
If you have Excel 365 or Excel 2021 use XLOOKUP instead of VLOOKUP. The XLOOKUP function is easier to use and has some additional advantages.
How to use Excel
October 8, 2024Formula Auditing in Excel
Formula auditing in Excel allows you to display the relationship between formulas and cells. The example below helps you master Formula Auditing quickly and easily.
How to use Excel
October 8, 2024Turn off Scroll Lock in Excel
When Scroll Lock is turned on you can use the arrow keys to scroll through the worksheet without changing the active cell. Excel displays Scroll Lock in the status bar.
How to use Excel
October 8, 2024Split Worksheet in Excel
You can split your Excel worksheet into panes to view multiple distant parts of your worksheet at once. Simply use the split bar to change the size of each pane.
How to use Excel
October 8, 2024Highlight Active Cell in Excel VBA
Below we will look at a program in Excel VBA that highlights the row and column of the Active Cell (selected cell). This program will amaze and impress your boss.
How to use Excel
October 8, 2024Advanced Filter in Excel
This example teaches you how to apply an advanced filter in Excel to only display records that meet complex criteria.
How to use Excel
October 8, 2024Make a Read-only Workbook in Excel
This example shows you how to make your Excel workbook read-only. Users without a password can still save changes by creating a new copy of the workbook.
How to use Excel
October 8, 2024Default Templates in Excel
Book.xltx and Sheet.xltx are two special templates you can create and add to the XLStart folder. As a result Excel uses Book.xltx as the basis for new workbooks and Sheet.xltx as the basis for new worksheets.
How to use Excel
October 8, 2024BeforeDoubleClick Event in Excel VBA
Code added to the Worksheet BeforeDoubleClick Event will be executed by Excel VBA when you double click a cell on a worksheet.
How to use Excel
October 8, 2024Save in Excel 97-2003 Format
If you save your Excel files in 97-2003 format (.xls instead of the new .xlsx format) users who do not have Excel 2007 or later installed on their computer can still open your Excel files.
How to use Excel
October 8, 2024Insert Row Shortcut in Excel
To quickly insert a row in Excel select a row and use the shortcut CTRL SHIFT +. To quickly insert multiple rows select multiple rows and use the same shortcut.
How to use Excel
October 8, 2024How to Add a Column in Excel
To add a column in Excel right-click the column letter and click Insert. When you insert a column or row cell references update automatically.
How to use Excel
October 8, 2024Sales Calculator in Excel VBA
Below we will look at a program in Excel VBA that calculates the total sales of each employee over a period of three years.
How to use Excel
October 8, 2024Box and Whisker Plot in Excel
This example teaches you how to create a box and whisker plot in Excel. A box and whisker plot shows the minimum value first quartile median third quartile and maximum value of a data set.
How to use Excel
October 8, 2024Possible Football Matches in Excel VBA
Below we will look at a program in Excel VBA that shows a print preview of all the possible football matches from a list of teams.
How to use Excel
October 8, 2024Solve a System of Linear Equations in Excel
This example shows you how to solve a system of linear equations in Excel. For example we have the following system of linear equations:
How to use Excel
October 8, 2024Tax Rates in Excel VBA
Below we will look at a program in Excel VBA that calculates the tax on an income. The following tax rates apply to individuals who are residents of Australia.
How to use Excel
October 8, 2024Data Validation in Excel
Use data validation in Excel to make sure that users enter certain values into a cell.
How to use Excel
October 8, 2024Sort Birthdays in Excel VBA
Below we will look at a program in Excel VBA that sorts birthdays by months first and days second (so we ignore years). We want the birthday with the lowest month number at the first position. If there are birthdays with equal month numbers we want the birthday with the lowest day number first. Are you ready?
How to use Excel
October 8, 2024Text to Columns in Excel
To separate the contents of one Excel cell into separate columns you can use the 'Convert Text to Columns Wizard'. For example when you want to separate a list of full names into last and first names.
How to use Excel
October 8, 2024Color Scales in Excel
Color Scales in Excel make it very easy to visualize values in a range of cells. The shade of the color represents the value in the cell.
How to use Excel
October 8, 2024Debugging in Excel VBA
This example teaches you how to debug code in Excel VBA. By pressing F8 you can single step through your code.