|  

» My Bookmarked Tips

My Tips is a feature that allows you to bookmark your favorite tips on our website. Simply click on the icon when viewing a tip to bookmark it.

• You may later access the bookmarked tips by clicking on the My Tips tab.
• The tips will be bookmarked for all future visits to our website.


Delete Tip from MyTips Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the Top/Bottom Number of Items
Delete Tip from MyTips Show the time in the Format hh:mm:000 using VBA
Delete Tip from MyTips Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel
Delete Tip from MyTips Calculating the Average Value in Every Nth Column, Excluding Zeros
Delete Tip from MyTips Moving Between Unprotected Cells in a Protected Sheet
Delete Tip from MyTips Selecting Special Cells
Delete Tip from MyTips Calculating an Average, Only Including Prices on Which There Was no Discount
Delete Tip from MyTips Counting the Number of Combined First and Last Names Matching Criteria in a Dynamic Range
Delete Tip from MyTips Calculating a Required Date According to Two Criteria
Delete Tip from MyTips Get the value of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Copy cells to all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Performing Numeric Operations on Substrings
Delete Tip from MyTips Counting Date Values by Specified Date Criteria
Delete Tip from MyTips Change a Row or Rows to values to values using VBA in Microsoft Excel
Delete Tip from MyTips Summing Groups of Every N Values in a Row
Delete Tip from MyTips COUNT Formulas
Delete Tip from MyTips Copying Formatting
Delete Tip from MyTips Find the minimum positive value in Microsoft Excel
Delete Tip from MyTips Return the cell reference as text in Microsoft Excel
Delete Tip from MyTips Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
Delete Tip from MyTips Quickly Typing Dates into Cells
Delete Tip from MyTips Sort the worksheets in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Default Auto-Save File Location
Delete Tip from MyTips Creating email address
Delete Tip from MyTips List of File Formats that are Supported in Excel 2007
Delete Tip from MyTips Counting the Number of Values from Multiple Worksheets that Match Criteria
Delete Tip from MyTips Redondeando Números a Millones con Miles como Decimal
Delete Tip from MyTips Summing Stock Lists
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet
Delete Tip from MyTips Summing Using Text Characters as Criteria
Delete Tip from MyTips Copy all rows of a column without a value using VBA in Microsoft Excel
Delete Tip from MyTips Reemplazando Ceros con signos “-“ en el Formato Numérico
Delete Tip from MyTips ”Desprender” Paletas desde la Barra de Herramientas
Delete Tip from MyTips Array variables using VBA in Microsoft Excel
Delete Tip from MyTips Converting Times to Decimal Values
Delete Tip from MyTips Counting the Number of YES Responses in a Student Questionnaire
Delete Tip from MyTips Defining a Range Name
Delete Tip from MyTips Set background color depending on value verification using VBA in Microsoft Excel
Delete Tip from MyTips Moving the Chart to a Different Place in the Sheet in Microsoft Excel
Delete Tip from MyTips Converting Time to Decimal Values
Delete Tip from MyTips Delete all macros in a workbook/document using VBA in Microsoft Excel
Delete Tip from MyTips Search and copy date values using VBA
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page in Excel 2007
Delete Tip from MyTips Opening a Copy of an Existing Workbook
Delete Tip from MyTips Seleccionando una Columna(s) o Fila(s) Utilizando Métodos Abreviados
Delete Tip from MyTips How to change column number with letter in Microsoft Excel
Delete Tip from MyTips Finding the Maximal / Minimal String, Based on Alphabetic Order
Delete Tip from MyTips Quickly Selecting a Range of Cells
Delete Tip from MyTips Seeing Calculation Results Immediately
Delete Tip from MyTips Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found
Delete Tip from MyTips Count cells in a range from all worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Pasting Values
Delete Tip from MyTips Hiding Subtotal Level Buttons
Delete Tip from MyTips Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Fast Copying & Pasting Right or Down in a List
Delete Tip from MyTips Change a Column or Columns to values using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Auto Outline, Clear Outline, and Show Outline Symbols Icons to the Toolbar
Delete Tip from MyTips Coloreando un Registro en Cada Grupo en un Rango
Delete Tip from MyTips Copying Styles from One Workbook to Another in Excel 2007
Delete Tip from MyTips Use the format painter to copy column widths and row heights in Microsoft Excel
Delete Tip from MyTips Hiding Subtotal Level Buttons in Excel 2007
Delete Tip from MyTips Converting Units
Delete Tip from MyTips Showing All Items When Choosing from a Menu
Delete Tip from MyTips Nesting OR and AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Removing the Smart Tag Indicator
Delete Tip from MyTips Adding Euro format to the number format in Microsoft Excel
Delete Tip from MyTips Quitando el Indicador de Etiqueta Inteligente
Delete Tip from MyTips How to change error result calculation when using Vlookup formula to 0 or empty cell in Microsoft Excel
Delete Tip from MyTips Symbols Used to Create Custom Formatting
Delete Tip from MyTips Check if a VBProject is protected using VBA in Microsoft Excel
Delete Tip from MyTips Add a New Comment in Excel 2007
Delete Tip from MyTips Replace text in a text file using VBA in Microsoft Excel
Delete Tip from MyTips Counting Time Values in Terms of Hourly Increments
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
Delete Tip from MyTips Mail the Activeworkbook using VBA in Microsoft Excel
Delete Tip from MyTips Inserting/Editing Formulas in Excel 2007
Delete Tip from MyTips Copying & Pasting Cell Content to Thousands of Cells
Delete Tip from MyTips Retrieving Grade Value for Corresponding Mark
Delete Tip from MyTips Password to prevent opening a workbook in Microsoft Excel
Delete Tip from MyTips Calculating the Average of Every Nth Value
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page
Delete Tip from MyTips Removing icons from toolbars in Microsoft Excel
Delete Tip from MyTips Import data from a closed workbook (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Mail Sheet Array using VBA in Microsoft Excel
Delete Tip from MyTips Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in All Sheets
Delete Tip from MyTips Converting a Julian Date to a Calendar Date
Delete Tip from MyTips Customizing an Icon
Delete Tip from MyTips Ranking Numbers in a Dynamic List
Delete Tip from MyTips Combine the VLookup and Match formulas in Microsoft Excel
Delete Tip from MyTips Table Tools Ribbon in Excel 2007
Delete Tip from MyTips Unnecessary Blank Characters in Cells in Excel 2007
Delete Tip from MyTips Transposing a Column into Successive Rows of a Specified Length
Delete Tip from MyTips Deleting a Range Name
Delete Tip from MyTips Selecting a sheet from shortcut menu in Microsoft Excel
Delete Tip from MyTips Inserting a picture (company logo) in Microsoft Excel 97 and 2000
Delete Tip from MyTips Selecting a Column(s) or Row(s) Using Keyboard Shortcuts
Delete Tip from MyTips Add a cell, Row or a column in Microsoft Excel
Delete Tip from MyTips Protecting Cells Containing Formulas in a Protected Sheet
Delete Tip from MyTips Sorting Numbers Based on Their Frequency within a List
Delete Tip from MyTips Basic information about OLE automation using VBA in Microsoft Excel
Delete Tip from MyTips Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Delete Tip from MyTips Identifying and selecting the print area in a sheet in Microsoft Excel
Delete Tip from MyTips Finding the Score that Was the Nth Highest for a Specified Team
Delete Tip from MyTips Restore the position in the window using VBA in Microsoft Excel
Delete Tip from MyTips Creating PivotTable in Excel 2007
Delete Tip from MyTips Printing a Chart in Microsoft Excel
Delete Tip from MyTips Generate total for dynamic area using VBA in Microsoft Excel
Delete Tip from MyTips Enter the Weekdays Mon - Fri in a Worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Grouping the Date Field by Number of Days in Excel 2007
Delete Tip from MyTips Filtering by More Than Two Criteria
Delete Tip from MyTips Change range with more then Area to values using VBA in Microsoft Excel
Delete Tip from MyTips Transposing Cells in Excel 2007
Delete Tip from MyTips Adding the Page Setup Icon to the Excel Menu Bar
Delete Tip from MyTips PivotTable report - Adding a Calculated Field
Delete Tip from MyTips Selecting a Sheet in the Workbook
Delete Tip from MyTips Separtaing A String Into Substrings.
Delete Tip from MyTips Extracting a substring
Delete Tip from MyTips Count the number of times in particular date a text appear in adjacent column in Microsoft Excel
Delete Tip from MyTips Selecting Special Cells in Excel 2007
Delete Tip from MyTips Inserting Page Numbers in Excel 2007
Delete Tip from MyTips Sorting by Custom Lists in Excel 2007
Delete Tip from MyTips Unhide rows and columns by using Custom Views in Microsoft Excel.
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout in Excel 2007
Delete Tip from MyTips Summing Monthly Trial Balance Figures
Delete Tip from MyTips Chart object events using VBA in Microsoft Excel
Delete Tip from MyTips Adding Data, Charts, or Other Information to a Cell Comment in Excel 2007
Delete Tip from MyTips Determine which CommandBar button that started a macro using VBA in Microsoft Excel
Delete Tip from MyTips Quickly Printing a Page from the Workbook Using a Custom View
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Creating and Saving Custom Styles
Delete Tip from MyTips Separating First and Last Names Without Using Formulas
Delete Tip from MyTips Put a line at Foot of print page
Delete Tip from MyTips Control Word from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Copying a Cell Comment in Excel 2007
Delete Tip from MyTips Range Name Syntax
Delete Tip from MyTips Adding a Picture to a Header/Footer
Delete Tip from MyTips Rounding Numbers that Meet Specified Criteria
Delete Tip from MyTips Searching a String for a Specific Substring
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Getting Values From A Closed Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Control Excel from Word using VBA in Microsoft Excel
Delete Tip from MyTips Copying the Subtotals Summary in Excel 2007
Delete Tip from MyTips Determine if a sheet exists in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Values between Two Specified Values in a List
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet in Excel 2007
Delete Tip from MyTips Disregarding blank cells when performing calculations on a range.
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Grouping/ Ungrouping Sheets
Delete Tip from MyTips Adding a Reference to Header/Footer in excel 2007
Delete Tip from MyTips Automatically Updating a Range Name Reference
Delete Tip from MyTips Sorting Rules & List Structure
Delete Tip from MyTips Adjust row height of merged cells using VBA in Microsoft Excel
Delete Tip from MyTips Seperating Website Name or URL from Text
Delete Tip from MyTips Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
Delete Tip from MyTips Reversing Strings
Delete Tip from MyTips Calculate Average Speed in Microsoft Excel
Delete Tip from MyTips Copying a Cell Comment
Delete Tip from MyTips Replacing Substrings with Numbers from Adjacent Cells
Delete Tip from MyTips Coloring and/or Copying Subtotals from Consolidated Lists Containing Links in Excel 2007
Delete Tip from MyTips Preventing the Printing of Objects
Delete Tip from MyTips Change the state of a custom CommandBar button using VBA in Microsoft Excel
Delete Tip from MyTips Create eventmacros for the Application object using VBA in Microsoft Excel
Delete Tip from MyTips Return unique items using VBA in Microsoft Excel
Delete Tip from MyTips Return random numbers using VBA in Microsoft Excel
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting in Excel 2007
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
Delete Tip from MyTips Hiding the Display of Zero Values
Delete Tip from MyTips Create day sheets of a month without weekends and holidays using VBA
Delete Tip from MyTips Summing How Many Points Scored by a Specified Team in Specified Games
Delete Tip from MyTips Printing Non-Continuous Areas in Excel 2007
Delete Tip from MyTips Launch Word file from Excel VBA
Delete Tip from MyTips Forecasting Daily Budget
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Filtering a Range into a List of Unique Records
Delete Tip from MyTips Changing the Default Style in Excel 2007
Delete Tip from MyTips Creating Subtotals Summary in Excel 2007
Delete Tip from MyTips Open data in two dimensional array and save in sheet using VBA in Microsoft Excel
Delete Tip from MyTips Counting Rows that Match Specific Criteria for Each Column
Delete Tip from MyTips Avoiding Errors When Counting Date Values That Meet Specified Criteria
Delete Tip from MyTips Edit a Comment in Excel 2007
Delete Tip from MyTips Preventing Text from Extending Beyond the Range in Excel 2007
Delete Tip from MyTips Displaying Figures in Financial Reports Rounded to Thousands
Delete Tip from MyTips Add and Save new Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Adding Subtotals to a Date Field in Excel 2007
Delete Tip from MyTips Customizing Date Formatting
Delete Tip from MyTips Comparing Three or More Lists in Microsoft Excel
Delete Tip from MyTips Find if a character is in a cell in Microsoft Excel
Delete Tip from MyTips Copying Cell Content Across Sheets in Excel 2007
Delete Tip from MyTips Counting the Number of Cells Containing Text in a Range
Delete Tip from MyTips Converting Time Values from One Time Zone to Another
Delete Tip from MyTips Saving a Customized Workbook as a Template in Excel 2007
Delete Tip from MyTips Find the address of the max value in range in Microsoft Excel
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Add Group and Outline in Excel 2007
Delete Tip from MyTips Finding and Deleting Unwanted and Orphaned Links
Delete Tip from MyTips Count the number of cells in a range containing all types of Errors in Microsoft Excel
Delete Tip from MyTips Converting a Date into a String, Indicating the Quarter Number and Year
Delete Tip from MyTips Checking Whether Cells in a Range are Blank, and Counting the Blank Cells
Delete Tip from MyTips What's New in Excel 2002/2003: Menu, Cell Shortcut Menu and Keyboard Shortcuts
Delete Tip from MyTips Coloring Rows Based on Text Criteria
Delete Tip from MyTips Preventing Duplicates While Entering Data
Delete Tip from MyTips Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells
Delete Tip from MyTips Adding Subtotals to a Date Field
Delete Tip from MyTips Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
Delete Tip from MyTips What's New in Excel 2003
Delete Tip from MyTips Retrieving Matching Values From Not Adjacent List
Delete Tip from MyTips Creating a Summary Table of a Student Questionnaire
Delete Tip from MyTips Consolidating Lists
Delete Tip from MyTips Adding Additional Functions to Subtotals
Delete Tip from MyTips Add values from the previous or next worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Converting Uppercase Letters to Lowercase
Delete Tip from MyTips Retrieving the Most Frequent Occurrence for Each Category
Delete Tip from MyTips Basic file and folder examples using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips How to calculate VAT / Tax and net sale price in Microsoft Excel
Delete Tip from MyTips Display a record with a right mouse click using VBA in Microsoft Excel
Delete Tip from MyTips Count the number of cells containing data in a range in Microsoft Excel
Delete Tip from MyTips Calculating the Average for Numbers Meeting Specified Criteria
Delete Tip from MyTips Prevent a UserForm from closing when the user clicks the x-button using VBA in Microsoft Excel
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Validating text entries in Microsoft Excel
Delete Tip from MyTips Watch Calculation Results Immediately in Excel 2007
Delete Tip from MyTips Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters
Delete Tip from MyTips Function for returning the user name using VBA in Microsoft Excel
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates the Difference from the Previous Item
Delete Tip from MyTips Printing Cell Comments
Delete Tip from MyTips Use the built-in dialogs using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Finding the First Value in a Row and Retrieving the Header for That Column
Delete Tip from MyTips The Power Combination
Delete Tip from MyTips Display all installed fonts (Excel) using VBA in Microsoft Excel
Delete Tip from MyTips Finding Every Third Number and Returning the Largest of Them
Delete Tip from MyTips Restricting the Number of Characters Entered into a Cell
Delete Tip from MyTips Identifying the Case of Letters within Strings
Delete Tip from MyTips Displaying zero values in Microsoft Excel
Delete Tip from MyTips Combining Text and a Formatted Date into a Single Entity
Delete Tip from MyTips Parsing text to the right of a search criteria - delimiter in Microsoft Excel
Delete Tip from MyTips Sorting by Custom Lists
Delete Tip from MyTips List, change or delete external formula references (links) using VBA in Microsoft Excel
Delete Tip from MyTips Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
Delete Tip from MyTips Limiting the Movement in a Protected Sheet in Excel 2007
Delete Tip from MyTips Applying Colors to Subtotal Rows in Excel 2007
Delete Tip from MyTips Validating Number Entries
Delete Tip from MyTips Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007
Delete Tip from MyTips Summing Annual Expenses by Respective Quarters
Delete Tip from MyTips Consolidating Lists While Adding Links to the Source Data
Delete Tip from MyTips Quickly Removing Subtotals
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007
Delete Tip from MyTips Playing MIDI-files using VBA in Microsoft Excel
Delete Tip from MyTips Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Path Address to the Header/Footer
Delete Tip from MyTips Retrieving Values from another Sheet Using Date as Sheet Name Reference
Delete Tip from MyTips Converting Text to Its Proper Case
Delete Tip from MyTips Retrieving Values Using References Based on Row and Column Numbers
Delete Tip from MyTips Changing the Number Formatting in Excel 2007
Delete Tip from MyTips Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up
Delete Tip from MyTips List all fonts available in Excel using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Default Style
Delete Tip from MyTips Quickly Creating Links between Workbooks in Excel 2007
Delete Tip from MyTips Sort Ascending/Descending While Using AutoFilter
Delete Tip from MyTips PDF2XL and PDF2XL OCR
Delete Tip from MyTips How Excel Sorts Lists
Delete Tip from MyTips Printing a Custom View in Excel 2007
Delete Tip from MyTips Function for returning the computer name using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Inserting the path where the Workbook is saved to the title bar or the status bar using VBA in Microsoft Excel
Delete Tip from MyTips Conditonal Formatting using Microsoft Excel VBA
Delete Tip from MyTips Selecting/Formatting Cells Containing Errors
Delete Tip from MyTips Retrieving the Column Header of the Next Non-Blank Cell in a Row
Delete Tip from MyTips Changing the Name of the Cell Comment's Author
Delete Tip from MyTips Display all installed fonts (Word) using VBA in Microsoft Excel
Delete Tip from MyTips Copying a Formula from a Cell While Keeping the Absolute Reference or Relative Reference
Delete Tip from MyTips To Fill Values Right or Down in a List in Excel 2007
Delete Tip from MyTips Filtering a List into Unique Records Using the COUNTIF Formula
Delete Tip from MyTips Get the Row number of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Summing Sales Quantities and Amounts of Several Lists, or Presenting the Figures Side-by-Side in Excel 2007
Delete Tip from MyTips Allowing Multiple Users to Edit Ranges in Microsoft Excel
Delete Tip from MyTips Format table depending on number formats using VBA in Microsoft Excel
Delete Tip from MyTips Nesting Formulas
Delete Tip from MyTips Indicating Due Payments, Based on the Current Date
Delete Tip from MyTips Hiding Data Before Printing
Delete Tip from MyTips Index Formula vs. Vlookup Formula
Delete Tip from MyTips Combining Text and Numerically Calculated Results into One Output String
Delete Tip from MyTips Copying a series from one chart to another in Microsoft Excel
Delete Tip from MyTips Summing Values from a List Containing Numerical and Textual Substrings
Delete Tip from MyTips Summing the Number of Hours an Employee Worked During a Two Week Period
Delete Tip from MyTips Changing the Default Cell Comment Format
Delete Tip from MyTips Adding Additional Functions to Subtotals in Excel 2007
Delete Tip from MyTips Calculating the Average of Every Nth Value, Excluding Zeros
Delete Tip from MyTips Retrieve Value Using Case-Sensitive Lookups
Delete Tip from MyTips Select a Style in Excel 2007
Delete Tip from MyTips Summarize data according to criteria from the data table using Sumif formula, Offset formula and Combo Box in Microsoft Excel
Delete Tip from MyTips Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
Delete Tip from MyTips Removing All Page Breaks from the Sheet
Delete Tip from MyTips Adding the Page Setup Icon to the Excel Menu Bar
Delete Tip from MyTips Protecting the Sheet or the Cells in the Sheet
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Retrieving a value from a reference grid according to index values
Delete Tip from MyTips Worksheet events using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Value of the First Non-Blank Cell in a List
Delete Tip from MyTips Ranking Salespeople According to Sales Figure
Delete Tip from MyTips Turn off warning messages using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values In a Range Specified By Indirect Cell References
Delete Tip from MyTips Change the worksheet codemodule names using VBA in Microsoft Excel
Delete Tip from MyTips Retrieve the Distance between Any Two Cities from Distance Table
Delete Tip from MyTips Add page breaks to sorted data using VBA in Microsoft Excel
Delete Tip from MyTips Coloring Two Subtotal Levels in Different Colors
Delete Tip from MyTips Quickly Entering a Long Company or Person Name
Delete Tip from MyTips Display AutoFilter criteria after filtering using VBA in Microsoft Excel
Delete Tip from MyTips Counting values meeting multiple criteria in different columns.
Delete Tip from MyTips Private Profile Strings using the Registry using VBA in Microsoft Excel
Delete Tip from MyTips Determining Long Distance Phone Calls, Based on the Number Dialed
Delete Tip from MyTips Import data from a text file (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Updating a Range Name Reference in Excel 2007
Delete Tip from MyTips Import data from Access to Excel (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Finding and Deleting Unwanted and Orphan Links in Excel 2007
Delete Tip from MyTips Copying the Page Setup to Other Sheets in Excel 2007
Delete Tip from MyTips Applying Colors to Subtotal Rows
Delete Tip from MyTips Printing in Excel 2007
Delete Tip from MyTips Coloring Sheet Tabs
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Using Different Functions to Consolidate Lists
Delete Tip from MyTips Merging and Centering in Excel 2007
Delete Tip from MyTips Change the cursor appearance to hourglass using VBA in Microsoft Excel
Delete Tip from MyTips Applying Styles to Subtotal Rows in Excel 2007
Delete Tip from MyTips Sorting by Columns
Delete Tip from MyTips Changing a Numeric Heading to Text in Excel 2007
Delete Tip from MyTips Playing WAV-files using VBA in Microsoft Excel
Delete Tip from MyTips Calculating Canadian Mortgage Payments
Delete Tip from MyTips Pass arguments to macros from buttons and menus using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Source Link in Excel 2007
Delete Tip from MyTips Color Unique Record in a Range in Excel 2007
Delete Tip from MyTips Quickly Creating Links Between Ranges
Delete Tip from MyTips Retrieving File Name by Matching a Given Page Number in a Book
Delete Tip from MyTips Let Excel Read Text for You
Delete Tip from MyTips Allowing Multiple Users to Edit Specified Ranges in Excel 2007
Delete Tip from MyTips Retrieving Values from Different Sheets Using the Sheet Name as a Reference
Delete Tip from MyTips Count by color using VBA in Microsoft Excel
Delete Tip from MyTips Using Different Functions to Consolidate Lists
Delete Tip from MyTips Sharing and Allow Users to Edit Changes in Excel 2007
Delete Tip from MyTips Prevent that an automacro/eventmacro executes using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Each Second Number from Two Lists
Delete Tip from MyTips Set the Ruler Units in Excel 2007
Delete Tip from MyTips Adding special symbols to the number format in Microsoft Excel
Delete Tip from MyTips Copying Cell Content Across Sheets
Delete Tip from MyTips Protecting Cells Containing Formulas in an Unprotected Sheet in Excel 2007
Delete Tip from MyTips Preventing a Printed Area from Extending onto an Extra Page
Delete Tip from MyTips Copying/Moving a Cell(s) Between Sheets/Workbooks in Excel 2007
Delete Tip from MyTips Subtotal Ribbon in Excel 2007
Delete Tip from MyTips Finding Minimum / Maximum Values
Delete Tip from MyTips Performing a Quick Calculation in the Formula Bar
Delete Tip from MyTips Create worksheets from a list of names using VBA in Microsoft Excel
Delete Tip from MyTips Values Not Formatted as Numbers in Excel 2007
Delete Tip from MyTips Return error values from user defined functions using VBA in Microsoft Excel
Delete Tip from MyTips Return every n-th item using VBA in Microsoft Excel
Delete Tip from MyTips Combining Text and a Formatted Date
Delete Tip from MyTips Inserting Subtotals Quickly
Delete Tip from MyTips Retrieving the Player Who Scored the Highest Number of Points
Delete Tip from MyTips Find the minimum numerical value in a list based on a criteria in Microsoft Excel
Delete Tip from MyTips Comparing Lists Using the COUNTIF Formula
Delete Tip from MyTips Changing the Cell Formatting from Date to Number
Delete Tip from MyTips Adding Data, Charts, or Other Information to a Cell Comment
Delete Tip from MyTips Switching Between Open Workbooks in Excel 2007
Delete Tip from MyTips Count the number of cells in a range in Microsoft Excel
Delete Tip from MyTips Canceling the Update Links Message While Opening a Linked Workbook
Delete Tip from MyTips Change the availability for a menu item using VBA in Microsoft Excel
Delete Tip from MyTips Restricting Cell Entries to Text Only
Delete Tip from MyTips Encoding a Sequence of Letters
Delete Tip from MyTips Rounding numerical calculation results in Microsoft Excel
Delete Tip from MyTips Retrieving the Column Header that Corresponds with a Matched Value
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Days, Months, Quarters, and Years
Delete Tip from MyTips Printing Non-Continuous Areas
Delete Tip from MyTips Copying Formatting in Excel 2007
Delete Tip from MyTips Open and close the CD-ROM tray using VBA in Microsoft Excel
Delete Tip from MyTips Count the number of times dates in certain month appears in range in Microsoft Excel
Delete Tip from MyTips Generate a random value between two limits in Microsoft Excel
Delete Tip from MyTips Retrieving the Value of the First Nonblank Cell in a List
Delete Tip from MyTips Changing the font size of the Sheet name in Microsoft Excel
Delete Tip from MyTips Protecting Workbooks with a Digital Signature
Delete Tip from MyTips Compare two worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Private Profile Strings using Words System.PrivateProfileString using VBA in Microsoft Excel
Delete Tip from MyTips Hiding Errors in Cells Before Printing
Delete Tip from MyTips Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
Delete Tip from MyTips Applying Formatting to Cells Containing Text Only in Excel 2007
Delete Tip from MyTips Retrieving a Price Value By Looking at Two Difference Data Tables
Delete Tip from MyTips List all the workbook links in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Items Sold Every Half Hour
Delete Tip from MyTips Comparing Lists in Excel 2007
Delete Tip from MyTips Replacing Data Markers with Pictures in Microsoft Excel
Delete Tip from MyTips Summing Stock Lists in Excel 2007
Delete Tip from MyTips Removing Icons Performing Two Different Tasks
Delete Tip from MyTips Opening Workbooks from a List of Hyperlinks
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Validating Number Entries in Excel 2007
Delete Tip from MyTips Retrieving the Entire Row of a Matched Value
Delete Tip from MyTips Change the availability for the shortcut menus using VBA in Microsoft Excel
Delete Tip from MyTips Preventing Duplicates While Entering Data in Excel 2007
Delete Tip from MyTips Create a hyperlink from a string in Microsoft Excel
Delete Tip from MyTips Filling a Range with a Series of Dates in Excel 2007
Delete Tip from MyTips Retrieving Sale Price Based on Item and Color Criteria
Delete Tip from MyTips Avoiding Error Displays when Formulas Return Result Calculations
Delete Tip from MyTips Adding a Data Field That Calculates Percentages from One Item of the Row Field
Delete Tip from MyTips Icons Disappearing from the Toolbar
Delete Tip from MyTips Retrieving a Specific Cell from Multiple Sheets
Delete Tip from MyTips Find the last numeric value in a range in Microsoft Excel
Delete Tip from MyTips Hiding Gridlines on the Screen and When Printing
Delete Tip from MyTips Copying the Page Setup to Other Sheets
Delete Tip from MyTips Coloring Even Numbered Rows in a List
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Retrieving the Last Value in a Dynamic List
Delete Tip from MyTips Protecting Cells in the Sheet in Excel 2007
Delete Tip from MyTips Converting Text to Uppercase
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Change the value/content of several UserForm-controls using VBA in Microsoft Excel
Delete Tip from MyTips Show the full name ( path and workbook name ) in the menu bar in Microsoft Excel
Delete Tip from MyTips Changing an Absolute Reference to a Relative Reference or Vice Versa
Delete Tip from MyTips Copying or Applying Color to Groups and Outlines in Excel 2007
Delete Tip from MyTips Retrieving Smallest Nth Value Match Within a List
Delete Tip from MyTips Enter the holiday according to the Table in the holiday-list using VBA
Delete Tip from MyTips Rounding Numbers to Millions
Delete Tip from MyTips Inserting Special Symbols into Custom Formats
Delete Tip from MyTips Adding a Calculated Percentage Field
Delete Tip from MyTips Deleting All Cell Comments in a Sheet
Delete Tip from MyTips Deleting a Comment(s) in a Sheet in Excel 2007
Delete Tip from MyTips Consolidating Lists While Adding Links to the Source Data in excel 2007
Delete Tip from MyTips Circular References
Delete Tip from MyTips Inserting a Watermark Behind the Text
Delete Tip from MyTips Preventing the Printing of Objects in Excel 2007
Delete Tip from MyTips Using the Macro Recorder in Microsoft Excel
Delete Tip from MyTips Determine if an application is available using VBA in Microsoft Excel
Delete Tip from MyTips Sorting Rules in Excel 2007
Delete Tip from MyTips Retrieving the Most Recent Payment Made by Client
Delete Tip from MyTips Countdown in status bar using VBA in Microsoft Excel
Delete Tip from MyTips Copying Styles from One Workbook to Another
Delete Tip from MyTips Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel
Delete Tip from MyTips Workbook events using VBA in Microsoft Excel
Delete Tip from MyTips Creating Progressively Incremented Counting Criteria
Delete Tip from MyTips Removing Hidden Apostrophes from Imported Numbers
Delete Tip from MyTips Retrieving Every Nth Value in a Range
Delete Tip from MyTips Unintentionally Creating Links Between Workbooks
Delete Tip from MyTips Checking For Duplicate Values Within A Range
Delete Tip from MyTips List and add the days of months in a set period using VBA in Microsoft Excel
Delete Tip from MyTips Opening a saved Workbook in Microsoft Excel
Delete Tip from MyTips Retrieving the Column Header of the Largest Value in a Row
Delete Tip from MyTips Quickly Printing a Page from the Workbook Using a Custom View
  To delete a tip, simply click on the trash icon of the tip you wish to remove




  1. Retrieving an Item from a List that Meets Multiple Criteria
  2. Simplifying Formulas by Reducing the Complexity of IF Functions
  3. The Best Shortcut Keys in Microsoft Excel
  4. Create User Forms in Microsoft Excel
  5. Writing Your First VBA Function in Excel
  6. Copy Selection to a Database sheet using VBA in Microsoft Excel
  7. Replace text in a text file using VBA in Microsoft Excel
  8. Add Combo Box to a Sheet in Microsoft Excel
  9. Using Loops in VBA in Microsoft Excel
  10. Formulas to calculate Loan payments in Microsoft Excel
  11. Retrieving Values Using Range Names as References
  12. Summing Rounded Numbers
  13. Find duplicates items in combine columns in Microsoft Excel
  14. Adding the Page Setup Icon to the Excel Menu Bar
  15. Turn off warning messages using VBA in Microsoft Excel
  16. Working Out a Person's Age in Microsoft Excel
  17. Create an Amortization Schedule in Microsoft Excel
  18. PDF2XL Enterprise
  19. Converting Time to Decimal Values
  20. Summing Stock Lists

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation