All Microsoft Excel Versions Tips (1171 tips)
Keyboard Formula Shortcuts- Joining text using formula in Microsoft Excel
- Shortcuts for opening the Function Arguments window in Microsoft Excel
- Inserting/Editing Formulas
- Shortcuts to see the Help for the Syntax Function in Microsoft Excel
- Change slash separator in date with period in Microsoft Excel
- Displaying the serial number behind Date format in Microsoft Excel
- Calculating Differences Between Dates
- Adding a Custom Function That Returns the Quarter Number
- Calculate number of minutes between dates - time in Microsoft Excel
- Working Out a Person's Age in Microsoft Excel
- Calculating the Date at the End of a Month
- Extract The Year, Month, or Day From A Date
- Access ThisWorkbook module directly from Excel
- Access the Private module of a Worksheet Object while in Excel
- Adding a Custom Keyboard Shortcut
- Selecting cells that only contain Text in Microsoft Excel
- Finding/Finding & Replacing in a Single Sheet or in All Sheets
- Extracting Characters from Text Using Text Formulas
- Convert text to lower case in Microsoft Excel
- Counting how many times specific character appears in cell in Microsoft Excel
- How to extract a file name from a path in Microsoft Excel
- Extract the first word in a cell in Microsoft Excel
- Extract the last word in a cell in Microsoft Excel
- Extract all the words except the first in Microsoft Excel
- Extract the first, middle and last name in Microsoft Excel
- Count the number of words in a cell in Microsoft Excel
- Using the Validation Input Message as a Cell Comment
- Applying Formatting Only to Cells Containing Text
- The Best Shortcut Keys in Microsoft Excel
- Moving to the Last (or First) Cell in a Range
- Selecting Cells in Horizontal or Vertical Ranges
- Selecting a Range of Non-Adjacent Cells
- Selecting the Current Region/List
- Fast Typing in Selected Area
- Selecting Cells from Any Cell to the Last Cell in the Sheet's Used Range
- Selecting a Column(s) or Row(s) Using Keyboard Shortcuts
- Selecting a row or rows in Microsoft Excel
- Hiding/Unhiding a Row(s) or Column(s)
- Hiding or unhiding a column or columns in Microsoft Excel
- Fast Copying & Pasting in Adjacent Cells
- Copying & Pasting Cell Content to Thousands of Cells
- Moving Between Open Workbooks
- Quickly Entering Text into Cells from a List of Previous Entries or a Validation List
- Preventing Moving to the Next Cell After Typing
- Combining Text from Different Cells
- Displaying the Format Cells Dialog Box
- Change the cell formatted from date format to number format in Microsoft Excel
- Displaying the Serial Number Behind the Date
- Changing the Default Date Separator from a Slash to a Dot When Entering a Date into a Cell
- Change slash separator in date with period in Microsoft Excel
- Displaying the serial number behind Date format in Microsoft Excel
- Shortcuts for opening the Function Arguments window in Microsoft Excel
- Shortcuts to see the Help for the Syntax Function in Microsoft Excel
- Creating Charts with F11 in Microsoft Excel
- Sizing Charts with the Window in Microsoft Excel.
- Setting the Default Chart Type in Microsoft Excel
- Printing a Chart in Microsoft Excel
- Preventing charts from being printed in Microsoft Excel
- Using the Keyboard to Select Chart Items in Microsoft Excel
- Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
- Moving the Chart to a Different Place in the Sheet in Microsoft Excel
- Adding a Linked Picture to a Chart in Microsoft Excel
- Updating Charts by Dragging and Dropping in Microsoft Excel
- Displaying Numbers in Thousands in a Chart in Microsoft Excel
- Opening a Linked Workbook in Microsoft Excel
- Opening/Closing a Workbook(s)
- Select bottom right end corner of the used area Microsoft Excel
- Copying/Moving a Cell(s) Between Sheets/Workbooks
- Hiding Outline Symbols
- Adding Groups and Outlines Manually
- Insert or delete a Row/Column in Microsoft Excel
- Quick Move to end of range of cells in Microsoft Excel
- Quickly Selecting a Range of Cells
- Selecting Special Cells
- Selecting All Sheet Cells
- Fast Copying & Pasting Right or Down in a List
- Keyboard shortcut to insert Current Date / Current Time
- Formula View
- Enter data on many cells at once
- Converting number to Dollar currency format
- COPY/ PASTE VALUE keyboard shortcut
- Fast switching between large number of worksheets
- keyboard multiple select entire row w/o click and drag
- Keyboard shortcut for applying Array
- Viewing Selecting Data in a Sheet
- Changing the Default Auto-Save File Location
- Opening a template file automatically upon starting Microsoft Excel
- Opening a Linked Workbook in Microsoft Excel
Excel Importing Text Files
- Problem: The Minus Sign Appears to the Right of the Number
- Problem: Date Formatting Cannot Be Changed
- Problem: Values Not Formatting as Numbers
- Deleting Empty Rows
- Create and Add a Function for Reversed Text Characters in Microsoft Excel
General Topics in VBA
- Set the Background Color according to the date using VBA in Microsoft Excel
- Change font color based on Date using VBA in Microsoft Excel
- Set background color depending on value verification using VBA in Microsoft Excel
- Set up yellow background color for header in an AutoFilter table using VBA in Microsoft Excel
- Display message if column total is exceeded using VBA in Microsoft Excel
- Display a record with a right mouse click using VBA in Microsoft Excel
- Replace value from validation list with a number using VBA in Microsoft Excel
- Prevent entry of invalid values using VBA in Microsoft Excel
- Merge cells without loosing values using VBA in Microsoft Excel
- Validation list without empty cells using VBA in Microsoft Excel
- Create worksheets from a list of names using VBA in Microsoft Excel
- Open data in two dimensional array and save in sheet using VBA in Microsoft Excel
- Generate total for dynamic area using VBA in Microsoft Excel
- Search, enter, and delete values using VBA in Microsoft Excel
- Display AutoFilter criteria after filtering using VBA in Microsoft Excel
- Turn off warning messages using VBA in Microsoft Excel
- Determine the screen size using VBA in Microsoft Excel
- Restore the position in the window using VBA in Microsoft Excel
- Turn off warning messages using VBA in Microsoft Excel
- Determine the type of operating system using VBA in Microsoft Excel
- Playing MIDI-files using VBA in Microsoft Excel
- Playing WAV-files using VBA in Microsoft Excel
- Playing sound notes using VBA in Microsoft Excel
- Basic information about OLE automation using VBA in Microsoft Excel
- Convert negative values treated as text using VBA in Microsoft Excel
- Insert pictures using VBA in Microsoft Excel
- Private Profile Strings using INI-files using VBA in Microsoft Excel
- Private Profile Strings using Words System.PrivateProfileString using VBA in Microsoft Excel
- Private Profile Strings using the Registry using VBA in Microsoft Excel
- Restore the VBE windows to their default positions using VBA in Microsoft Excel
- Array variables using VBA in Microsoft Excel
- Display all installed fonts (Word) using VBA in Microsoft Excel
- Display all installed fonts (Excel) using VBA in Microsoft Excel
- Open and close the CD-ROM tray using VBA in Microsoft Excel
- Change the cursor appearance to hourglass using VBA in Microsoft Excel
- Eliminate screen flashing while running a macro using VBA in in Microsoft Excel
- Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
- Using the Macro Recorder in Microsoft Excel
- Entering the Current Time into a Cell
- Displaying the Serial Number Behind the Time
- Totaling Time Values
- Converting Time to Decimal Values
- Calculating the Difference Between Hours
- Rounding Hours Up
- Converting a Number to a Time Value
- Calculating Time Differences Between Regions of the World
- Negative times in Microsoft Excel
- Calculate number of minutes between dates - time in Microsoft Excel
- Entering Formulas More Quickly by Shortening Sheet Names
- Changing an Absolute Reference to a Relative Reference or Vice Versa
- Copying a Formula from a Cell While Keeping the Absolute Reference or Relative Reference
- Nesting Formulas
- Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
- Moving Between Precedent and Dependent Cells
- Avoiding Error Displays when Formulas Return Result Calculations
- Selecting/Formatting Cells Containing Errors
- Circular References
- Pasting Values
- Selecting Cells That Contain Formulas
- Formatting Cells Containing Formulas
- Protecting Cells Containing Formulas in a Protected Sheet
- Displaying Formula Syntax
- Printing Formula Syntax
- Adding, Subtracting, Multiplying and Dividing Without Using Formulas
- Multiplying a Range by -1 in One Operation
- Performing a Quick Calculation in the Formula Bar
- Coloring One Record in Each Group in a Range
- Converting Text to Its Proper Case
- Return text up to the second space in Microsoft Excel
- Converting Text to Uppercase
- Convert text to lower case in Microsoft Excel
- How to change column number with letter in Microsoft Excel
- How to extract a file name from a path in Microsoft Excel
- Return the cell reference as text in Microsoft Excel
- Create a hyperlink from a string in Microsoft Excel
- Sum total stock value for any part in Microsoft Excel
- Seeing Calculation Results Immediately
- Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References
- The Power Combination
- Add a cell, Row or a column in Microsoft Excel
- Copying or Moving a Sheet
- Creating Charts with F11 in Microsoft Excel
- Removing icons from toolbars in Microsoft Excel
- Opening a saved Workbook in Microsoft Excel
- Showing All Items When Choosing from a Menu
- Iteration
- Adding a Combo Box
- E-mailing an Excel Workbook, Sheet, Data or Chart
- PDF2XL and PDF2XL OCR
- Fast switching between large number of worksheets:-
- Subset Sum Problem
- Dynamic Cascading Drop Downs (getting around the INDIRECT() problem)
- Adding two cells trick
- calendar with tasks for each day
- "Mirror" of filtered data, using formulas.
- UK Postcode Distance Calculator
- Create time stamp
- Resetting last used cell
- Mouseless tip on Excel Comments
- Print your entire Workbook
- Printing cell comments
- Zipping through sheet tabs
- Saving The Current Workbook With A New Filename
- Print closed workbook
- Auto-complete data
- Printing cell comments
- Validating Text Entries
- Preventing Duplicates While Entering Data
- Validating text entries in Microsoft Excel
- Copying and Pasting Validation list only in Microsoft Excel
- Automatically Wrapping Text in a Cell
- Manually Wrapping Text in a Cell
- Preventing Text from Spilling Over
- Adding a Shortcut for Wrapping Text
- Changing the Indentation in a Cell
- Dividing a First Left Heading Title
- Transposing Cells
- Changing a Numeric Heading to Text
- Combining Text and Formatted Values
- Combining Text and a Formatted Date
- Extracting Characters from Text Without Using Formulas
- Separating First and Last Names Using Formulas
- Separating First and Last Names Without Using Formulas
- Entering the Current Date into a Cell
- Quickly Typing Dates into Cells
- Filling a Range with a Series of Dates
- Searching for text in Microsoft Excel
- Using a Picture to Watch Cell Values in Other Sheets
- Linking a Cell to a Text Box
- Copying a Cell Comment
- Deleting All Cell Comments in a Sheet
- Adding Data, Charts, or Other Information to a Cell Comment
- Inserting a Copied Cell(s) Without Overwriting Existing Data
- Add space between characters and numbers in Microsoft Excel
- Copying Cell Content Across Sheets
- Validating Number Entries
- Quickly Entering a Long Company or Person Name
- Validating Date Entries
- Identifying all the merged cells
- Completing partially-filled data
- Clearing cells
- Toggle between edit and select mode for formulae
- Editing a formula using keyboard
- Add and Save new Workbook using VBA in Microsoft Excel
- Search value in external workbook and paste with format style using VBA in Microsoft Excel
- Getting Values From A Closed Workbook using VBA in Microsoft Excel
- Change the worksheet codemodule names using VBA in Microsoft Excel
- Use listboxes with multiple choices using VBA in Microsoft Excel
- Use messageboxes using VBA in Microsoft Excel
- Use the built-in dialogs using VBA in Microsoft Excel
- Basic file and folder examples using VBA in Microsoft Excel
- Determine if a file is in use using VBA in Microsoft Excel
- File names and folder names using VBA in Microsoft Excel
- List files in a folder with Microsoft Scripting Runtime using VBA in Microsoft Excel
- List files in a folder with Office 97 or later using VBA in Microsoft Excel
- Select filenames using VBA in Microsoft Excel
- Select folder names using VBA in Microsoft Excel
- Log files using VBA in Microsoft Excel
- Close a workbook using VBA in Microsoft Excel
- Create new workbooks using VBA in Microsoft Excel
- Determine if a workbook exists using VBA in Microsoft Excel
- Determine if a workbook is already open using VBA in Microsoft Excel
- Read information from a closed workbook using VBA in Microsoft Excel
- Save a workbook backup using VBA in Microsoft Excel
- Sort the worksheets in a workbook using VBA in Microsoft Excel
- Delete sheets without confirmation prompts using VBA in Microsoft Excel
- Determine if a sheet exists in a workbook using VBA in Microsoft Excel
- Log files using VBA in Microsoft Excel
- Add special symbols to the number format
- Format number in joining text with linked number in Microsoft Excel
- Rounding Numbers to Thousands
- Rounding Numbers to Millions
- Rounding Numbers to Thousands with Hundreds as a Decimal
- Rounding Numbers to Millions with Thousands as a Decimal
- Formatting a Negative Number with Parentheses
- Replacing Zeros with Dashes in Number Formatting
- Changing the Cell Formatting from Date to Number
- Change the cell formatted from date format to number format in Microsoft Excel
- Adding special symbols to the number format in Microsoft Excel
- Coloring Numbers Based on Specific Criteria
- Color numbers based on the value result in Microsoft Excel
- Copying Formatting
- Changing the Default Style
- Hiding the Display of Zero Values
- Creating and Saving Custom Styles
- Copying Styles from One Workbook to Another
- Create styles directly from cells in Microsoft Excel
- Displaying Figures in Financial Reports Rounded to Thousands
- Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
- Coloring Rows Based on Text Criteria
- Applying Colors to Maximum/Minimum Values in a List
- Use the format painter to copy column widths and row heights in Microsoft Excel
- Coloring Even Numbered Rows in a List
- Inserting Special Symbols into Custom Formats
- Symbols Used to Create Custom Formatting
- Using the Round Function to Round Numbers to Thousands
- Customizing Date Formatting
- Add a fancy line for Presentation
- Format even numbers
- Color Alternate Rows with Conditional Formatting
- Custom Format to show Units without changing Number to Text
- Centre a title across a worksheet
- Spice up the borders
- Color sheet tabs
- Quickly apply currency number format
Excel Sorting
- Sorting Rules & List Structure
- How Excel Sorts Lists
- Sorting by Columns
- Sorting by Custom Lists
- Drawing Lines Between Sorted Groups
- Unintentionally Creating Links Between Workbooks
- Quickly Creating Links Between Ranges
- Canceling the Update Links Message While Opening a Linked Workbook
- Converting Uppercase Letters to Lowercase
- Finding and Deleting Unwanted and Orphaned Links
- Changing the Source Link
- Copying, Cutting and Pasting (Moving)
- Adding the Camera icon to the toolbar in Microsoft Excel
- Changing the Name of the Cell Comment's Author
- Changing the Default Cell Comment Format
- Opening Workbooks from a List of Hyperlinks
- Changing the font size of the Sheet name in Microsoft Excel
- Show the full name ( path and workbook name ) in the menu bar in Microsoft Excel
- Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
- "Tearing Off" Paletts from Toolbars
- Customizing an Icon
- Adding the Properties Icon to the Standard Toolbar
- Removing Personal Information from a Workbook
- Adding the Page Setup Icon to the Excel Menu Bar
- Adding the Page Setup Icon to the Excel Menu Bar
- Dual Monitors - Trouble Displaying separate spreadsheets on each Monitor
- Quick way to Split Excel Window
- Format all worksheets of a workbook in a Single Go
- Hide Data in Cell from praying eyes
- Hiding formula
- Change Column/Row Header Styles
- Excel Scheduler Process to Run the Excel WorkBook Macro
- mirror
- Create Controls at Runtime/Expanding Forms/Floating Toolbar/PTO Calendar
- Shrink cell data
- Change the default number of worksheets
- Unhide multiple columns at once
- Separating Positive and Negative numbers and add Running Balance column
- Reversing The Order Of Values In A List
- Rounding Numbers that Meet Specified Criteria
- Ranking Numbers in a Dynamic List
- Counting the number of cells containing a substring
- Sum Total Sales Except for One Specified Item
- Dividing an Amount into Equal Payments While Avoiding Division / Rounding Errors
- Counting values meeting multiple criteria in different columns.
- Counting the Number of Values between Two Specified Values in a List
- Counting Rows that Match Specific Criteria for Each Column
- Retrieving Unique Values From A List
- Retrieving Every nth Value In a Range
- Finding Minimum / Maximum Values
- Avoiding Errors When Counting Date Values That Meet Specified Criteria
- Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
- Simplifying Formulas by Reducing the Complexity of IF Functions
- Calculating the Average of Every Nth Value
- Counting the Number of Values Between Upper and Lower Limits
- Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
- Indicators for the maximal and minimal values
- Creating Formulas that Only Return Results from Non-Blank Cells
- Calculating the Average for Numbers Meeting Specified Criteria
- Checking For Duplicate Values Within A Range
- Retrieving an Item from a List that Meets Multiple Criteria
- Performing calculations based on multiple criteria, using SUMPRODUCT function
- Retrieving the Value of the First Nonblank Cell in a List
- Retrieving From List By Position
- Calculating an Average, Only Including Prices on Which There Was no Discount
- Nesting OR and AND Functions to Meet Multiple Criteria
- Ranking Salespeople According To Sales Figure
- Retrieving the Closest Larger and Closest Smaller Values from a List When There Is No Exact Match
- Finding the Largest Number among Those Meeting Specified Criteria
- Counting Rows of Even Numbers in Two Parallel Ranges
- Disregarding blank cells when performing calculations on a range.
- Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas
- Extracting a substring
- Summing How Many Points Scored by a Specified Team in Specified Games
- Counting the Number of Players According to Their Score in a Particular Quarter
- Reversing Strings
- Correcting Formatting Errors
- Rounding the Calculation of Retail Price and Sales Tax
- Counting the Number of Students who Answered "A" to the Second Question
- Checking For Sequences Within A Sorted List
- Retrieving a value from a reference grid according to index values
- Finding a substring within a string
- Extracting last Word
- Validating Data To Be Unique In A Range
- Random Selection from a List
- Avoiding #DIV/0! Errors when Dividing by Zero
- Ignoring #DIV/0! Errors when Performing Calculations
- Eliminating Errors Resulting from If Functions with Multiple Conditions
- Avoiding Errors when Counting Date Values that Meet Specified Criteria
- Avoiding Errors when Subtracting Times
- Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found
- Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors
- Using a VLOOKUP Formula to Check If a Value Exists
- Checking If Matching Numbers Exist in Different Ranges
- Sorting Numbers in Ascending or Descending Order
- Sorting Numbers Based on Their Frequency within a List
- Reversing the Order of Values in a List
- Shuffling a List of Values
- Retrieving Unique Values from a List
- Retrieving List Values that Do Not Appear in a Second List
- Retrieving Values that are Common to Two Lists
- Creating a List of All Non-Blank Cells in a Column
- Retrieving Values from a List that are Greater than a Specified Number
- Checking for Sequences within a Sorted List
- Checking for Duplicate Values within a Range
- Identifying Duplicate Rows within a Range
- Determining and Indicating the Number of Times Each Value Has Been Entered in a List
- Transposing an Entire Range of Data into a Single Column
- Transposing a Column into Successive Rows of a Specified Length
- Transposing a Range in Ascending Order
- Transposing Values from Columns into Rows, and Vice Versa
- Calculating Average Annual Growth
- Calculating the Average Growth of a Child
- Finding Specified Items in a List and Averaging their Associated Values
- Excluding Exceptional Values when Calculating an Average
- Averaging Values that Correspond with the X Largest Values in a Dynamic Range
- Calculating the Average of a Range of Numbers, Excluding the Minimal Value
- Calculating the Lowest Common Multiple (LCM)
- Returning the Nth Largest / Smallest Values in a Range
- Rounding Up / Down to the Nearest Multiple of a Specific Number
- Rounding a Value to Make It Divisible by a Specified Number
- Ranking a List of Numbers
- Calculating Commissions Based on Sales Rank
- Selecting a Set of Random Numbers, Avoiding Duplicates
- Adjusting Values Returned by the RAND Function
- Randomly Selecting a Value from a Range
- Calculating Net Sale Price According to Text Criteria
- Calculating the Proportion of Characters from One String that Appears in another String
- Calculating the Remaining Credit after Each Purchase
- Calculating Total Annual Payment Based on Cumulative Monthly Payments
- Placing the Previous Payment Date beside Each Pay Date in a List
- Restricting the Automatic Recalculation of Volatile Functions
- Calculating the Percentage of Cells in a Range that Contain a Specified String
- Calculating the Absolute Difference between Each List Value and the Minimum Value in the List
- Determining Divisibility
- Multiplying Values from Two Matrixes that Occupy Corresponding Addresses
- Converting Decimal Fractions to Fractions of a Specified Number
- Simplifying Formulas by Defining Names for Often-Repeated Parts
- Converting Units
- Calculating Total Income Tax
- Always having Current Date / Current Time in worksheet
- Cell Function Returns Sheet Name, Workbook Name and Path
- Problem: Unnecessary Empty Characters in Cells
- Add Combo Box to a Sheet in Microsoft Excel
- Repeat your last Command / Action
- Camera Tool
- Calculate selected formula portion
- Name Box for quick navigation and range selection
- ALT key to show Dictionary
- Stock Quote fetching
- let excel talk to you
- Excel Calendar + Memo
- Listing/Renaming Files in a folder from excel
- Monthly expense report for colleagues
- Calculating just the worksheet NOT whole workbook
- Summing Rounded Numbers
- Fast Summation
- Summing values in vertical and horizontal ranges in Microsoft Excel
- Summing data by selecting cells in Microsoft Excel
- Inserting Subtotals Quickly
- Extending the Range of the SUM Formula
- Summing Values at the Intersection of Two or more Ranges
- Summing data from a cell in a number of sheets in Microsoft Excel
- The SUMIF Formula – Using Comparison Operators ( ) as Criteria
- Totaling Two Ranges Using the SUMIF Formula
- Summing Using Text Characters as Criteria
- Summing the Visible Filtered List
- Summarize data according to criteria from the data table using Sumif formula, Offset formula and Combo Box in Microsoft Excel
- Summing a range containing errors and values in Microsoft Excel
- Summing using multiple criteria in Microsoft Excel
- Sum the largest two numbers in range in Microsoft Excel
- Summing Values from Cells in Different Sheets
- Summing Stock Lists
- Simplifying complicated multiplication calculations using the SUMPRODUCT function
- Using multiple criteria in SUMIF Function
- Avoiding the #VALUE! Error When Adding Cells That May Contain Blanks
- Summing Values from Two Ranges, Based on Two Criteria
- Summing matching values in multiple rows
- Summing Values from a List Containing Numerical and Textual Substrings
- Summing Annual Expenses by Respective Quarters
- Summing Values in a Range Containing Redundant Spaces
- Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
- Summing A Dynamic Range of Numbers According To Criteria
- Summing Values In a Range Specified By Indirect Cell References
- Summing the Number of Hours an Employee Worked During a Two Week Period
- Quick Filtering Using the AutoFilter Icon
- Saving Filtering Criteria
- Filtering by the Date Field
- Coloring and Filtering Lists According to Criteria
- Filtering by More Than Two Criteria
- Filtering a Range into a List of Unique Records
- Filtering a List into Unique Records Using the COUNTIF Formula
- Count unique items using Advanced Filtering
- Highlight a selected range with a MsgBox using VBA in Microsoft Excel
- Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
- Combine column text and replace using VBA in Microsoft Excel
- Copy all rows of a column without a value using VBA in Microsoft Excel
- Compare two worksheet ranges using VBA in Microsoft Excel
- Compare two worksheets using VBA in Microsoft Excel
- Convert between column numbers and column references using VBA in Microsoft Excel
- Copy row heights and column widths using VBA in Microsoft Excel
- Delete rows and columns using VBA in Microsoft Excel
- Determine if a cell is within a range using VBA in Microsoft Excel
- Row and column background color using VBA in Microsoft Excel
- Set row height and column width in millimeters using VBA in Microsoft Excel
- Create an addin in Excel 97, 2000, 2002 using VBA in Microsoft Excel
- Delete rows with blank cells in a certain column using VBA in Microsoft Excel
- Copy a range with one Area to a Database sheet using VBA in Microsoft Excel
- Copy a range with more Areas to a Database sheet using VBA in Microsoft Excel
- Copy a Row or Rows to a Database sheet using VBA in Microsoft Excel
- Copy a Column or Columns to a Database sheet using VBA in Microsoft Excel
- Copy cells from the ActiveCell Row to a Database sheet using VBA in Microsoft Excel
- Copy Selection to a Database sheet using VBA in Microsoft Excel
- Copy Selection to a Database sheet using VBA in Microsoft Excel
- Copy a range on the place of the Activecell to a Database sheet using VBA in Microsoft Excel
- Copy a range of each sheet into one sheet using VBA in Microsoft Excel
- Copy the CurrentRegion of a cell of each sheet into one sheet using VBA in Microsoft Excel
- Copy the UsedRange of each sheet into one sheet using VBA in Microsoft Excel
- Copy a row or rows of each sheet into one sheet using VBA in Microsoft Excel
- Copy from row till the last row with data into one sheet using VBA in Microsoft Excel
- Copy a column or columns from each sheet into one sheet using VBA in Microsoft Excel
- Copy a Range from each workbook in a folder using VBA in Microsoft Excel
- Copy a row or rows from each workbook in a folder using VBA in Microsoft Excel
- Copy a column or columns from each workbook in a folder using VBA in Microsoft Excel
- Copy a sheet from each workbook into your workbook in a folder using VBA in Microsoft Excel
- Copy a range from each workbook with a file name starting with ? in a folder using VBA in Microsoft Excel
- Copy cells to all workbooks in a folder using VBA in Microsoft Excel
- Change all the cells in the ActiveSheet to values using VBA in Microsoft Excel
- Change only the CurrentRegion of the ActiveCell to values using VBA in Microsoft Excel
- Change all cells in a range to values using VBA in Microsoft Excel
- Change range with more then Area to values using VBA in Microsoft Excel
- Change cells in the Activecell rowrange to values using VBA in Microsoft Excel
- Change a Row or Rows to values to values using VBA in Microsoft Excel
- Change a Column or Columns to values using VBA in Microsoft Excel
- Change the selection with one or more areas to Values using VBA in Microsoft Excel
- Making a Cell the First Cell in the Active Window
- Getting last blank cell
- Some handy Personal Macros: Return Column Letter for column number.
- Double Click to add/remove Tick
- Automating the Insertion of the Euro Symbol
- Use AutoCorrect to enter special symbols in Microsoft Excel
- Counting the Number of Cells Containing Text in a Range
- Comparing Lists Using the COUNTIF Formula
- COUNT Formulas
- Counting how many times specific character appears in cell in Microsoft Excel
- Count the number of cells in a range in Microsoft Excel
- Count the number of blank cells in a range in Microsoft Excel
- Count the number of cells containing data in a range in Microsoft Excel
- Count the number of cells with numeric data in a range in Microsoft Excel
- Count the number of cells in a range containing all types of Errors in Microsoft Excel
- Count how many numbers are in series of numbers when a certain criteria is set in Microsoft Excel
- Count the number of values between a lower and upper limit in Microsoft Excel
- Count the number of times dates in certain month appears in range in Microsoft Excel
- Counting the Number of Items Sold Every Half Hour
- Counting Unique Numeric Values or Unique Data in a List
- Creating Progressively Incremented Counting Criteria
- Counting the Values that Match Criteria in a Filtered List
- Creating a Summary Table of a Student Questionnaire
- Counting the Number of YES Responses in a Student Questionnaire
- Counting Unique "X" and "O" Occurrences in a Matrix
- Creating a Counting Grid
- Countdown in status bar using VBA in Microsoft Excel
- Give a non-Excel look by Hiding the Active Menu And Using Full Screen using VBA in Microsoft Excel
- Change the availability for a menu item using VBA in Microsoft Excel
- Change the availability for the CommandBars using VBA in Microsoft Excel
- Change the availability for the shortcut menus using VBA in Microsoft Excel
- Change the state of a custom CommandBar button using VBA in Microsoft Excel
- Determine which CommandBar button that started a macro using VBA in Microsoft Excel
- Display a CommandBar centered on the screen using VBA in Microsoft Excel
- Edit the tooltip for toolbarbuttons using VBA in Microsoft Excel
- Pass arguments to macros from buttons and menus using VBA in Microsoft Excel
- Display a message on the statusbar using VBA in Microsoft Excel
- Adding the Subtotals Icon to the Menu Bar
- Hiding Subtotal Level Buttons
- Quickly Removing Subtotals
- Adding Subtotals to Primary and Secondary Fields
- Adding Additional Functions to Subtotals
- Adding Subtotals to a Date Field
- Printing Each Subtotal Group on a Separate Page
- Copying the Subtotals Summary
- Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
- Deleting the Word "Total" from the subtotal List
- Applying Styles to Subtotal Rows
- Applying Colors to Subtotal Rows
- Coloring Two Subtotal Levels in Different Colors
Excel Array Formulas
- Array Formulas – the Technical Side
- Counting Based on Multiple Criteria
- Count the number of cells in a range containing all types of Errors in Microsoft Excel
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum positive value in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- Count the number of times dates in certain month appears in range in Microsoft Excel
- Simplifying Formulas by Reducing the Complexity of IF Functions
- Calculating the Average Difference between List Price and Sale Price
- Counting the Number of Combined First and Last Names Matching Criteria in a Dynamic Range
- Ignoring Blank Cells when Performing Calculations
- Checking for the Presence of Specified Values Within a Range
- Finding the Score that Was the Nth Highest for a Specified Team
- Calculating the Average Value in Every Nth Column, Excluding Zeros
- Rounding Time Intervals to the Nearest Specified Time Increment
- Adding the Auto Outline, Clear Outline, and Show Outline Symbols Icons to the Toolbar
- Copying or Applying Color to Groups and Outlines
- Change the value/content of several UserForm-controls using VBA in Microsoft Excel
- Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel
- Fill a ListBox with unique values from a worksheet using VBA in Microsoft Excel
- Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
- Prevent a UserForm from closing when the user clicks the x-button using VBA in Microsoft Excel
- Return a userdefined cell reference from a dialog using VBA in Microsoft Excel
- Create User Forms in Microsoft Excel
- Increasing/Decreasing the Screen Magnification Percentage
- Selecting a Sheet in the Workbook
- Selecting a sheet from shortcut menu in Microsoft Excel
- Quickly Selecting a Range in the Workbook
- Opening a Template File Automatically When Starting Microsoft Excel
- Changing the font size of the Sheet name in Microsoft Excel
- Create a hyperlink from a string in Microsoft Excel
- Selecting a Sheet from a Sorted Sheets List
- Changing the Default Number of Sheets in a New Workbook
- Sorting Sheets in Ascending Order
- Grouping/ Ungrouping Sheets
- Inserting a New Sheet from a Template Sheet
- Changing the Number of Files Shown in the Recently Used File List
- Auto-Recovering/ Auto-Saving a Workbook
- Recovering Data from a Corrupted Workbook That Cannot Be Opened
- Displaying the Workbook's Path in the Address Box
- Saving a Customized Workbook as a Template
- Opening a Copy of an Existing Workbook
- Using a Workspace to Open a Number of Workbooks at Once
- Displaying Formulas and Values of the Same Cells
- Reducing the Workbook Size for Quick Sending via E Mail
- E-mailing an Excel Workbook, Sheet, Data or Chart
- Fast switching between large number of worksheets
- Hiding sheets
- Create eventmacros for the Application object using VBA in Microsoft Excel
- Chart object events using VBA in Microsoft Excel
- Prevent that an automacro/eventmacro executes using VBA in Microsoft Excel
- Workbook events using VBA in Microsoft Excel
- Worksheet events using VBA in Microsoft Excel
- Create a Custom Function
- Create and Add a Function for Reversed Text Characters in Microsoft Excel
- Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
- Add unique values using VBA in Microsoft Excel
- Add values from the previous or next worksheet using VBA in Microsoft Excel
- Sum by color using VBA in Microsoft Excel
- Count by color using VBA in Microsoft Excel
- Count cells in a range from all worksheets using VBA in Microsoft Excel
- Count unique values using VBA in Microsoft Excel
- Calculate a weeks start date using VBA in Microsoft Excel
- Calculate holidays using VBA in Microsoft Excel
- Calculate the count of workdays between two dates using VBA in Microsoft Excel
- Weeknumbers using VBA in Microsoft Excel
- Time intervals using VBA in Microsoft Excel
- Look up unique values using VBA in Microsoft Excel
- Return every n-th item using VBA in Microsoft Excel
- Return unique items using VBA in Microsoft Excel
- Return error values from user defined functions using VBA in Microsoft Excel
- Return random numbers using VBA in Microsoft Excel
- Userdefined functions from other workbooks using VBA in Microsoft Excel
- Worksheet functions in VBA macros using VBA in Microsoft Excel
- Sum the digits numbers in a cell using custom VBA function in Microsoft Excel
- How to Use Your Excel Add-In Functions in VBA
- Writing Your First VBA Function in Excel
- Changing the Font Size of the Sheet Name
- Displaying zero values in Microsoft Excel
- Changing the Standard Font
- Removing icons from toolbars in Microsoft Excel
- Removing Icons Performing Two Different Tasks
- Icons Disappearing from the Toolbar
- Adding icons (boxes) to the menu bar in Microsoft Excel
- Adding and Saving a New Customized Toolbar
- Backing Up Customized Changes to Toolbars and Menus
- Opening a template file automatically upon starting Microsoft Excel
- Coloring Numbers Based on Specific Criteria Using Conditional Formatting
- Using the COUNT Functions
- Counting the Number of Values Below or Above Average
- Counting Values that Appear Only Once in
- Counting the Number of Times a Specified Substring Appears within a Range of Strings
- Counting the Number of Cells Containing Text
- Counting the Number of Cells Containing Text
- Counting the Number of Times a Substring Appears Within a String
- Counting the Number of Strings which Contain Numbers Meeting Criteria
- Counting Date Values by Specified Date Criteria
- Counting the Number of Dates with Matching Month Criteria
- Counting Time Values in Terms of Hourly Increments
- Counting the Number of Values Meeting Criteria, but Only for Every 3rd Cell in a Range
- Counting the Number of Values from Multiple Worksheets that Match Criteria
- Counting the Number of Unique Items Sold by Each Salesperson
- Using Date & Time Criteria to Count Entries in a Combined Date & Time List
- Counting the Number of Times Any of the Numbers in First List Appears within Second List
- How to Use Your Excel Add-In Functions in VBA
- Writing Your First VBA Function in Excel
- An Improved Custom Random Numbers Function
- Summing the Values of Cells Occurring at the Intersection of Ranges
- Summing Values from Different Sheets for the Same Cell Address
- Creating a Summing Formula that Automatically Adjusts to a Dynamic Range
- Summing the Absolute Values of All Numbers in a Range
- Summing Subtotals Only from Range
- Modifying a SUMPRODUCT function to Return a Sum Rather than a Count
- Summing Rounded Numbers
- Summing Values Based on Text Criteria
- Summing Numerical Substrings
- Summing Values Using Indirect Cell References
- Summing Across Multiple Sheets
- Summing from Closed Workbooks
- Summing Positive and Negative Numbers Separately
- Summing Corresponding Values in Multiple Columns
- Summing Sales Amounts According to Product Category and Customer Name
- Summing Total Sales, Based on Quantity & Price
- Summing How Many Points Scored by a Specified Team in Specified Games
- Summing Expenses Accumulated to a Specified Month
- Calculating Monthly and Accumulated Income, Based on Specified Month
- Summing Groups of Every N Values in a Row
- Summing the Last N Values in a Column
- Summing the N Largest Values in a Range
- Creating a List in which Each Number is the Sum of the Previous N Numbers
- Calculating the Week Number
- Calculating the Quarter Number
- Extract the first word in a cell in Microsoft Excel
- Extract the last word in a cell in Microsoft Excel
- Extract all the words except the first in Microsoft Excel
- Extract the first, middle and last name in Microsoft Excel
- Count the number of words in a cell in Microsoft Excel
- Add space between characters and numbers in Microsoft Excel
- Forecasting Daily Budget
- Ignoring Blank Cells when Performing Calculations
- Avoiding the #VALUE! Error when Adding Cells that May Contain Blanks
- Counting unique entries in a range
- Applying Quick Sum Formula
- Count of uniques among duplicates
- Get adjacent value of a cell having minimum value in a range
- Get filename from path
- Lookup & return Multiple Results
- Personal Notes or Hidden Text in a Excel Formula
- Count filtered cells using SUBTOTAL
- Repeat entries in a column
- Offset function in excel
- Hide excel formulae
- Debug #VALUE Error
- Debug #REF Error
- Debug #NULL! Error
- Debug #NAME? Error
- Debug #N/A Error
- Debug #NUM Error
- Debug #DIV!0 Error
- Setting Excel To Calculate Manually
- Quickly sum non-contiguous cells
- Reference one cell only for date
- Which function to be entered as Array formula?
- Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel
- Consolidating Lists
- Comparing Lists
- Comparing Three or More Lists in Microsoft Excel
- Using Different Functions to Consolidate Lists
- Consolidating Lists While Adding Links to the Source Data
- Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
- Summing Stock Lists
- Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side
- Summing Monthly Trial Balance Figures
- Using Different Functions to Consolidate Lists
- Range Name Syntax
- Defining a Range Name
- Deleting a Range Name
- Automatically Defining Names for Ranges in Lists
- Using a Range Name in a Formula
- Saving a Frequently Used Formula/Numeric Value in the Define Name Dialog Box
- Automatically Updating a Range Name Reference
- Selecting range using F8 Key
- Format table depending on number formats using VBA in Microsoft Excel
- Set up conditional formatting for an area with VBA in Microsoft Excel
- Adjust row height of merged cells using VBA in Microsoft Excel
- List all fonts available in Excel using VBA in Microsoft Excel
- Conditonal Formatting using Microsoft Excel VBA
- Adding a Comment to a Formula
- Filtering is limited to 999 items in Microsoft Excel
- Changing the Cell Comment Shape
- how to figure out that worksheet is set to Manual Calculation mode
- Using F2 to edit ranges in Name Manager and Conditional Formatting
- Change the Task's progress bar colours by clicking it
- Creating a PivotTable Report
- Getting Drill-Down Details
- Grouping the Date Field by Number of Days
- Pivot Table - Grouping dates by weeks in Microsoft Excel
- Adding a Running Balance Calculation Column
- Adding a Calculated Percentage Field
- Setting the Number of Fields Displayed in the Page Layout
- Retrieving Data from a PivotTable Report
- Rules for Organizing the Source Data in Excel Sheets
- PivotTable Report Terminology
- Automatically Refreshing a PivotTable Report
- Adding/Deleting Subtotals
- Hiding Items
- Displaying the Top/Bottom Number of Items
- Formatting a PivotTable Report
- PivotTable report - Inserting a Chart
- Adding Sub-Details to an Item
- PivotTable report - Grouping Text Fields
- PivotTable report - Adding a Calculated Field
- PivotTable report - Grouping the Date Field by Days, Months, Quarters, and Years
- PivotTable report - Grouping the Date Field by Week Number
- PivotTable report - Grouping the Date Field by Quarters in a Fiscal Reporting Year
- PivotTable report - Adding a Data Field That Calculates the Difference Between Two Data Fields
- Adding a Data Field That Calculates Percentages from One Item of the Row Field
- PivotTable report - Adding a Data Field That Calculates Percentage Difference from the Previous Item
- PivotTable report - Adding a Data Field That Calculates the Difference from the Previous Item
- Automatic Report formatting using option buttons
- Prevent Unauthorized Opening of Workbook
- Protecting a Workbook
- Protecting and Unprotecting Workbooks in Microsoft Excel
- Protecting Sheets / Cells in Microsoft Excel
- Moving Between Unprotected Cells in a Protected Sheet
- Protecting Data by Hiding a Row(s) and Column(s)
- Preventing Movement in Protected Areas in Microsoft Excel
- Forgotten Your Password?
- Limiting the Movement in a Protected Sheet
- Limiting the Movement in an Unprotected Sheet
- Preventing Hidden Sheets from Appearing
- Protecting Cells Containing Formulas in an Unprotected Sheet
- Delete all cells with today's date using VBA
- Search and copy date values using VBA
- Create day sheets of a month without weekends and holidays using VBA
- Show the time in the Format hh:mm:000 using VBA
- Enter the holiday according to the Table in the holiday-list using VBA
- List and add the days of months in a set period using VBA in Microsoft Excel
- Enter the Weekdays Mon - Fri in a Worksheet using VBA in Microsoft Excel
- Times Format MM.SS.### using VBA in Microsoft Excel
- Replace all "u" with "U" up to today's date using VBA in Microsoft Excel
- Sort by birthday using VBA in Microsoft Excel
- Execute Command/Sub-Procedure Using Timer in VBA
- Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
- Calculations with one thousandth fractions of seconds by Custom Function using VBA
- Change text in header when printing using VBA in Microsoft Excel
- Conditional formatting depending on a cell comment using VBA in Microsoft Excel
- Change the default printer using VBA in Microsoft Excel
- Insert headers and footers using VBA in Microsoft Excel
- Print all workbooks in a folder using VBA in Microsoft Excel
- Print multiple selections on one sheet using VBA in Microsoft Excel
- Print the pages in reverse order using VBA in Microsoft Excel
- Select a printer tray before printing using VBA in Microsoft Excel
- Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
- Add unique values using VBA in Microsoft Excel
- Add values from the previous or next worksheet using VBA in Microsoft Excel
- Sum by color using VBA in Microsoft Excel
- Count by color using VBA in Microsoft Excel
- Count cells in a range from all worksheets using VBA in Microsoft Excel
- Count unique values using VBA in Microsoft Excel
- Calculate a weeks start date using VBA in Microsoft Excel
- Calculate holidays using VBA in Microsoft Excel
- Calculate the count of workdays between two dates using VBA in Microsoft Excel
- Weeknumbers using VBA in Microsoft Excel
- Time intervals using VBA in Microsoft Excel
- Look up unique values using VBA in Microsoft Excel
- Return every n-th item using VBA in Microsoft Excel
- Return unique items using VBA in Microsoft Excel
- Return error values from user defined functions using VBA in Microsoft Excel
- Return random numbers using VBA in Microsoft Excel
- Userdefined functions from other workbooks using VBA in Microsoft Excel
- Worksheet functions in VBA macros using VBA in Microsoft Excel
- Printing Cell Comments
- Adding the Path Address to the Header/Footer
- Identifying and selecting the print area in a sheet in Microsoft Excel
- Adding a Picture to a Header/Footer
- Preventing a Printed Area from Extending onto an Extra Page
- Printing page number in the opposite direction in landscape layout page in Microsoft Excel
- Removing All Page Breaks from the Sheet
- Inserting a Watermark Behind the Text
- Preventing the Printing of Objects
- Unhide rows and columns by using Custom Views in Microsoft Excel.
- Quickly Printing a Page from the Workbook Using a Custom View
- Use the continuous page numbers technique in Report Manager in Microsoft Excel.
- Printing a Chart in Microsoft Excel
- Preventing charts from being printed in Microsoft Excel
- Displaying zero values in Microsoft Excel
- Hiding Gridlines on the Screen and When Printing
- Printing a Filtered List
- Printing a PivotTable Report
- Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
- Copying the Page Setup to Other Sheets
- Printing a Page Number in Portrait While the Page Is in Landscape Layout
- Hiding Data Before Printing
- Printing Non-Continuous Areas
- Adding Continuous Page Numbers While Printing
- Saving Defined Page Setups for Future Printing
- Quickly Printing a Page from the Workbook Using a Custom View
- Printing an Already Saved Report Using Report Manager
- Creating a Custom Report Manager
- Adding the Custom Views Icon to the Excel Menu Bar
- Put a line at Foot of print page
- Formulas to calculate Loan payments in Microsoft Excel
- Create an Amortization Schedule in Microsoft Excel
- Rounding Numerical Substrings
- Averaging Sales Totals by Day of the Week
- Creating a Dynamic Inventory List Based on Daily Sales
- Using Financial Functions
- Calculating Canadian Mortgage Payments
- Mail one Sheet using VBA in Microsoft Excel
- Mail Sheet Array using VBA in Microsoft Excel
- Mail the selection using VBA in Microsoft Excel
- Mail every Worksheet with address in cell A1 using VBA in Microsoft Excel
- Mail sheet(s) to one or more people using VBA in Microsoft Excel
- Mail the Activeworkbook using VBA in Microsoft Excel
- Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
- Convert time to a serial value in Microsoft Excel
- Adding Time Values from Separate Hours and Minutes Columns
- Calculating Total Time Worked on a Specific Day
- Adding a Number to a Formatted Time Value
- Separating First and Last Names
- Finding the maximum value of all those meeting a certain criteria.
- Multiplying time values and numbers.
- Converting Time Values from One Time Zone to Another
- Subtracting Times
- Calculating the Number of Business Days in a Specified Period
- Calculating the Number of Weekday Hours Between Two Dates
- Avoiding Errors When Subtracting Times
- Calculating the Week Number Corresponding with a Specific Date
- Calculating Hours Worked
- Calculating Absolute Difference between Two Time Values
- Entering Dates Quickly
- Calculating Number of Days, Weeks, Months and Years between Dates
- Calculating a Date Based on Year, Week Number and Day of the Week
- Finding the Last Day of a Given Month
- Calculating the Number of Business Days in a Specified Period
- Calculating a Project's End Date
- Calculating a Required Date According to Two Criteria
- Indicating Due Payments, Based on the Current Date
- Calculating the Date of the Nth Specific Day of the Month
- Eliminating Negative Values from Date Subtractions
- Avoiding Negative Values when Calculating the Number of Days between Two Dates
- Avoiding False Results when Counting Dates Matching Specified Criteria
- Calculating the Week Number Corresponding with a Specific Date
- Determining whether Two Given Dates Occur within the Same Week
- Finding the Number of Days in a Given Month
- Finding the Serial Number of the Last Day of the Month
- Adding a Specified Number of Months to a Date
- Converting a Month's Serial Number into Its Corresponding Name
- Calculating the Quarter Number for Calendar and Fiscal Year
- Converting a Date into a String, Indicating the Quarter Number and Year
- Determining Which Quarter a Specified Date Corresponds With
- Converting Older Dates to the Current Year
- Converting a Julian Date to a Calendar Date
- Entering Times Quickly
- Entering Times Quickly
- Adding Time Values
- Adding Text Values Representing Time
- Adding Time Values from Separate Hours and Minutes Columns
- Adding a Number to a Formatted Time Value
- Subtracting Times
- Converting a Decimal Value to a Time Value
- Converting Text Representing Minutes and Seconds into Numerical Values
- Converting Times to Decimal Values
- Calculating Military Time Intervals
- Converting Time Values from One Time Zone to Another
- Creating a World Time Converter
- Rounding Times Down to the Nearest 30 Seconds
- Rounding Times Down to a Specified Time Increment
- Rounding Hours Up
- Calculating a Building's Occupancy Rate at Specified Times
- Creating Date and Time Stamp
- Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
- Combining Data from Separate Columns into a Single Date and Time Value
- Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
- Calculating the Number of Weekday Hours between Two Dates
- Separating Dates and Times
- Creating a Date and Time Matrix
- Creating a Timesheet
- Finding the First Login and Last Logout Times of Employees
- Calculating Total Time Worked on a
- Calculating the Number of Hours Worked Based on a System of Letter Codes
- Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates
- Calculating Daily Pay, Incorporating Variable Hourly Rates
- Determining Whether a Person Worked a Full or Partial Shift
- Determining Whether a Worked Shift Was Morning, Afternoon or Night
- Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
- Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts
- Counting Vacation or Sick Days within a Specified Time Period
- Calculating Hourly Productivity
- Avoiding Errors when Using the And Function to Combine Multiple Conditions in Array Formulas
- Replacing Data Markers with Pictures in Microsoft Excel
- Autoexpanding a Date Type Chart using Microsoft Excel
- Copying a series from one chart to another in Microsoft Excel
- 'Simple Gantt' - Small, feature rich gantt chart requiring minimal formatting - finally!
- Function for returning the computer name using VBA in Microsoft Excel
- Function for returning the user name using VBA in Microsoft Excel
- Sum the digits numbers in a cell using custom VBA function in Microsoft Excel
- An Improved Custom Random Numbers Function
- Problem: The Characters Are in Reverse Order
- Explanatory Formulas
- Combine the VLookup and Match formulas in Microsoft Excel
- Combine the Index and Match formulas in Microsoft Excel
- Vlookup Formula – Organizing the Data Table
- Vlookup Formula – Eliminating Errors
- Index Formula vs. Vlookup Formula
- Retrieve information from a range in another Excel File when the Path & File Name strings stored in various cells.
- Use VLOOKUP Function as an alternative to a number of nested IF functions.
- Using VLOOKUP and ISNA functions to find matching values in different sheets
- Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors
- Retrieving a Price Value By Looking at Two Difference Data Tables
- Altering the results returned by VLOOKUP.
- Retrieving an Item from a List that Meets Multiple Criteria
- Retrieving A Value From A Reference Grid, Using Indexes Listed In Another Range
- Retrieving Sale Price Based On Item And Color Criteria
- Retrieving Values Using Range Names as References
- Retrieving Values Using References Based on Row and Column Numbers
- Retrieving Each Second Number from Two Lists
- Retrieving Values Using Range Names as References
- Retrieving Values Using Range Names as References
- Retrieving Values from Different Sheets Using the Sheet Name as a Reference
- Retrieving Values from another Sheet Using Date as Sheet Name Reference
- Retrieving a Specific Cell from Multiple Sheets
- Retrieving Values from another Excel Workbook Using Text References
- Retrieving the Price for a Specified Item and a Specified Brand
- Retrieving from List by Position
- Ranking Salespeople According to Sales Figure
- Retrieving the Player Who Scored the Highest Number of Points
- Retrieving File Name by Matching a Given Page Number in a Book
- Retrieving Grade Value for Corresponding Mark
- Retrieving the Most Frequent Occurrence for Each Category
- Retrieving the Last Value and the Last Character in a Row
- Retrieving the Last Value in a Dynamic List
- Retrieving the Value of the First Non-Blank Cell in a List
- Retrieving the Most Recent Payment Made by Client
- Retrieving the Closest Larger / Closest Smaller Values from a List when there is No Exact Match
- Retrieving the First Value in a List that is Greater / Smaller than a Specified Number
- Finding the Maximal / Minimal String, Based on Alphabetic Order
- Retrieve Value Using Case-Sensitive Lookups
- Retrieving the Minimal / Maximal Values from a Filtered List
- Retrieving Smallest Nth Value Match Within a List
- Finding Every Third Number and Returning the Largest of Them
- Retrieving the Nth Value in a Row / Column
- Retrieving Every Nth Value in a Range
- Retrieve the Distance between Any Two Cities from Distance Table
- Retrieving Matching Values From Not Adjacent List
- Retrieving an Item from a List that Meets Multiple Criteria
- Retrieving an Item from a List that Meets Multiple Criteria
- Retrieving Sale Price Based on Item and Color Criteria
- Retrieving a Price from a List that Matches both Category and Item Criteria
- Retrieving the Entire Row of a Matched Value
- Returning the Entire Contents of the Row Containing the Highest Math Grade
- Retrieving a Price Value by Looking at Two Difference Data Tables
- Retrieving the Column Header of the Next Non-Blank Cell in a Row
- Finding the First Value in a Row and Retrieving the Header for That Column
- Retrieving the Column Header that Corresponds with a Matched Value
- Retrieving the Column Header of the Largest Value in a Row
- Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
- Advanced VLOOKUP
- Create and Add a Function for Reversed Text Characters in Microsoft Excel
- Export data from Excel to Access (ADO) using VBA in Microsoft Excel
- Export data from Excel to Access (DAO) using VBA in Microsoft Excel
- Import data from Access to Excel (ADO) using VBA in Microsoft Excel
- Import data from Access to Excel (DAO) using VBA in Microsoft Excel
- Import data from a closed workbook (ADO) using VBA in Microsoft Excel
- Import data from a text file (ADO) using VBA in Microsoft Excel
- Transfer data from a recordset to a worksheet (ADO) using VBA in Microsoft Excel
- Use a closed workbook as a database (ADO) using VBA in Microsoft Excel
- Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
- Replace text in a text file using VBA in Microsoft Excel
- Distribute Data from a List of the day to day sheets using VBA
- Replace text in a text file using VBA in Microsoft Excel
- Add page breaks to sorted data using VBA in Microsoft Excel
- Return text up to the second space in Microsoft Excel
- Find if a character is in a cell in Microsoft Excel
- Find if a character is in a range in Microsoft Excel
- Find the most commonly repeated string in a column in Microsoft Excel
- Parsing text to the right of a search criteria - delimiter in Microsoft Excel
- Count the number of times in particular date a text appear in adjacent column in Microsoft Excel
- Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula.
- Make LEFT Function recognize a number
- Calculating the Average of Every Nth Value, Excluding Zeros
- Removing Redundant Characters from a Range of Cells and Resetting the Format
- Avoiding Problems when Numeric Values are used as Text
- Counting number of unique entries in a specified range.
- Splitting a Full Address into Three Separate Cells
- Creating New IP Addresses
- Counting the Number of Excel Files in a List According to File Type and Date Criteria
- Altering results returned in case of an error.
- Retrieve Value Using Case-Sensitive Lookups
- Creating email address
- Separating a Number Into Digits
- Separtaing A String Into Substrings.
- Restricting Cell Entries to Text Only
- Restricting the Number of Characters Entered into a Cell
- Preventing Duplicates When Entering Data
- Combining Text and Formatted Numbers into a Single Entity
- Combining Text and a Formatted Date into a Single Entity
- Combining Numbers that Have Leading Zeros
- Combining the Contents of Every N Number of Cells into One Value
- Encoding a Sequence of Letters
- Combining Text and Numerically Calculated Results into One Output String
- Formulas Erroneously Appearing as Text
- Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells
- Checking Whether Cells in a Range are Blank, and Counting the Blank Cells
- Removing Hidden Apostrophes from Imported Numbers
- Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters
- Extracting the First N Number of Words from a String
- Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
- Replacing Substrings with Numbers from Adjacent Cells
- Performing Numeric Operations on Substrings
- Searching a String for a Matching Word from another String
- Find the Alphabetically Lowest Letter in a List
- Identifying Numeric Values within a Range Formatted as Text
- Identifying the Case of Letters within Strings
- Finding the Relative Position of Numbers within a String
- Searching a String for a Specific Substring
- Determining Long Distance Phone Calls, Based on the Number Dialed
- Rearranging a String in Alphabetic Order
- Reversing the Word Order within a String
- Retrieving the Cell Address of the Largest Value in a Range
- Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up
- Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
- Cell protection only for formulas using VBA in Microsoft Excel
- Check if a VBProject is protected using VBA in Microsoft Excel
- Simplifying Formulas by Reducing the Complexity of IF Functions
- Simplifying Formulas by Reducing the Complexity of IF Functions
- Create Conditional Formula
- Nesting OR & AND Functions to Meet Multiple Criteria
- Nesting OR & AND Functions to Meet Multiple Criteria
- Checking for the Presence of Specified Values within a Range
- How to eliminate N/A error result when using Vlookup formula in Microsoft Excel
- How to change error result calculation when using Vlookup formula to 0 or empty cell in Microsoft Excel
- Find the address of the max value in range in Microsoft Excel
- List all the workbook links in a workbook using VBA in Microsoft Excel
- List, change or delete external formula references (links) using VBA in Microsoft Excel
- Seperating Website Name or URL from Text
- Control Excel from Word using VBA in Microsoft Excel
- Control Outlook from Excel using VBA in Microsoft Excel
- Control Word from Excel using VBA in Microsoft Excel
- Determine if an application is available using VBA in Microsoft Excel
- Copy worksheet information to Word using VBA in Microsoft Excel
- Launch Word file from Excel VBA
- How secure is the addin source code? using VBA in Microsoft Excel
- What is an addin? in Microsoft Excel
- Build an Excel Add-In in Microsoft Excel
- Add a procedure to a module using VBA in Microsoft Excel
- Add content to a module from a file using VBA in Microsoft Excel
- Copy modules from one workbook to another using VBA in Microsoft Excel
- Create a new module using VBA in Microsoft Excel
- Delete a module using VBA in Microsoft Excel
- Delete a procedure from a module using VBA in Microsoft Excel
- Delete all macros in a workbook/document using VBA in Microsoft Excel
- Delete module content using VBA in Microsoft Excel
- Insert a new module from a file using VBA in Microsoft Excel
- Class modules using VBA in Microsoft Excel
Other Q&A Formulas
- How to calculate VAT / Tax and net sale price in Microsoft Excel
- Calculate Average Speed in Microsoft Excel
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum positive value in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- Get the value of the last non blank cell in a column in Microsoft Excel
- Generate a random value between two limits in Microsoft Excel
- Get the Row number of the last non blank cell in a column in Microsoft Excel
- Rounding numerical calculation results in Microsoft Excel
- Calculate commission percentage based on a commission schedule in Microsoft Excel
- Square root and cube root in Microsoft Excel
- How to find the minimum value in range while ignoring 0 value in Microsoft Excel
- Find duplicates items in combine columns in Microsoft Excel
- Find the value in the first non blank cell in range in Microsoft Excel
- Find the last numeric value in a range in Microsoft Excel
- Inserting the path where the Workbook is saved to the title bar or the status bar using VBA in Microsoft Excel
- Copy the contents of the previous row to the next row
- Hide columns using a button
- Create hyperlinked sheet list
- Split data by certain number of rows
- Removing entries in column B that match column A
- Open multiple files at once
- Find Range Function
- Some Handy Personal Macros: Clear-Duplicates-Below-Selection
- Some handy Personal Macros: Text version of the Large Function
- how to extract a list of all the files and folders within a Windows OS folder onto Excel
- Pull data from a closed workbook
