Microsoft Excel 97 Tips (1069 tips)

Excel Keyboard Shortcuts

• 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

• Access ThisWorkbook module directly from Excel
• Access the Private module of a Worksheet Object while in Excel
• Adding a Custom Keyboard Shortcut

• 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

• 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

• 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

• PDF2XL Enterprise

• 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

• 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

• 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

• 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

• Rounding Prices to the Nearest Nickel, Dime, Quarter and Dollar

• Reducing the Used Area in a Sheet
• 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

• 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

• 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

• 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

• 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
• Adding Euro format 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

• Creating a Timesheet

• 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

• Sorting Rules & List Structure
• How Excel Sorts Lists
• Sorting by Columns
• Sorting by Custom Lists
• Drawing Lines Between Sorted Groups

• 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

• 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

• 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

• Cell Function Returns Sheet Name, Workbook Name and Path
• Problem: Unnecessary Empty Characters in Cells
• Add Combo Box to a Sheet in Microsoft Excel

• 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

• 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

• 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

• 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

• 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

• 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

• Creating, and using a Visual Basic Combo/ Edit box

• Adding the Auto Outline, Clear Outline, and Show Outline Symbols Icons to the Toolbar
• Copying or Applying Color to Groups and Outlines

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• How to Use Your Excel Add-In Functions in VBA
• Writing Your First VBA Function in Excel
• An Improved Custom Random Numbers Function

• 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

• 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
• Getting Continuously Refreshed Data from a Web Site in Excel 97
• Filtering is limited to 999 items in Microsoft Excel
• Changing the Cell Comment Shape

• 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

• 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

• 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

• 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

• 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
• Inserting a picture (company logo) in Microsoft Excel 97 and 2000
• 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

• 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 Nu