|  

» 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 Log files using VBA in Microsoft Excel
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates the Difference from the Previous Item
Delete Tip from MyTips Display a message on the statusbar using VBA in Microsoft Excel
Delete Tip from MyTips Add page breaks to sorted data using VBA in Microsoft Excel
Delete Tip from MyTips Saving Filtering Criteria
Delete Tip from MyTips Sort the worksheets in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Determine the screen size using VBA in Microsoft Excel
Delete Tip from MyTips Extending the Range of the SUM Formula
Delete Tip from MyTips Preventing Movement in Protected Areas in Microsoft Excel
Delete Tip from MyTips Modifying a SUMPRODUCT function to Return a Sum Rather than a Count
Delete Tip from MyTips Calculating Number of Days, Weeks, Months and Years between Dates
Delete Tip from MyTips Chart object events using VBA in Microsoft Excel
Delete Tip from MyTips Determine if an application is available using VBA in Microsoft Excel
Delete Tip from MyTips Playing sound notes using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Values that Match Criteria in a Filtered List
Delete Tip from MyTips Calculating a Building's Occupancy Rate at Specified Times
Delete Tip from MyTips Combining Text and a Formatted Date
Delete Tip from MyTips Change only the CurrentRegion of the ActiveCell to values using VBA in Microsoft Excel
Delete Tip from MyTips Create Conditional Formula
Delete Tip from MyTips Correcting Formatting Errors
Delete Tip from MyTips Deleting a Range Name
Delete Tip from MyTips Adding special symbols to the number format in Microsoft Excel
Delete Tip from MyTips Converting a Number to a Time Value
Delete Tip from MyTips Iteration
Delete Tip from MyTips Merge cells without loosing values using VBA in Microsoft Excel
Delete Tip from MyTips Finding the First Value in a Row and Retrieving the Header for That Column
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
Delete Tip from MyTips Calculate number of minutes between dates - time in Microsoft Excel
Delete Tip from MyTips Applying Colors to Subtotal Rows in Excel 2007
Delete Tip from MyTips Retrieving the Minimal / Maximal Values from a Filtered List
Delete Tip from MyTips Dividing an Amount into Equal Payments While Avoiding Division / Rounding Errors
Delete Tip from MyTips Formatting a Negative Number with Parentheses
Delete Tip from MyTips Calculating Commissions Based on Sales Rank
Delete Tip from MyTips Using VLOOKUP and ISNA functions to find matching values in different sheets
Delete Tip from MyTips Using Loops in VBA in Microsoft Excel
Delete Tip from MyTips Coloring and Filtering Lists According to Criteria
Delete Tip from MyTips Counting Values that Appear Only Once in
Delete Tip from MyTips Setting the Number of Fields Displayed in the Page Layout
Delete Tip from MyTips Add space between characters and numbers in Microsoft Excel
Delete Tip from MyTips Cell Function Returns Sheet Name, Workbook Name and Path
Delete Tip from MyTips Print all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Adding Subtotals to a Date Field
Delete Tip from MyTips Sum the digits numbers in a cell using custom VBA function in Microsoft Excel
Delete Tip from MyTips Saving Defined Page Setups for Future Printing
Delete Tip from MyTips Calculating a Date Based on Year, Week Number and Day of the Week
Delete Tip from MyTips Calculating Total Annual Payment Based on Cumulative Monthly Payments
Delete Tip from MyTips Array variables using VBA in Microsoft Excel
Delete Tip from MyTips Prevent entry of invalid values using VBA in Microsoft Excel
Delete Tip from MyTips Delete all cells with today's date using VBA
Delete Tip from MyTips Userdefined functions from other workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Creating a Dynamic Inventory List Based on Daily Sales
Delete Tip from MyTips Rearranging a String in Alphabetic Order
Delete Tip from MyTips Set the Background Color according to the date using VBA in Microsoft Excel
Delete Tip from MyTips Preventing Duplicates While Entering Data
Delete Tip from MyTips Seleccionando la Lista/Región Actual
Delete Tip from MyTips Changing the Cell Comment Shape
Delete Tip from MyTips Protecting the Sheet or the Cells in the Sheet
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Create a Custom Function
Delete Tip from MyTips Saving a Frequently Used Formula/Numeric Value in the Define Name Dialog Box
Delete Tip from MyTips Displaying the Top/Bottom Number of Items
Delete Tip from MyTips Eliminate screen flashing while running a macro using VBA in in Microsoft Excel
Delete Tip from MyTips Reemplazando Ceros con signos “-“ en el Formato Numérico
Delete Tip from MyTips Import data from Access to Excel (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Subtotals Icon to the Menu Bar
Delete Tip from MyTips How to change column number with letter in Microsoft Excel
Delete Tip from MyTips Create a hyperlink from a string in Microsoft Excel
Delete Tip from MyTips Calculating the Date of the Nth Specific Day of the Month
Delete Tip from MyTips Hiding Gridlines on the Screen and When Printing
Delete Tip from MyTips Delete sheets without confirmation prompts using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Absolute Difference between Each List Value and the Minimum Value in the List
Delete Tip from MyTips Copy a range on the place of the Activecell to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Hiding Items
Delete Tip from MyTips Calculating Monthly and Accumulated Income, Based on Specified Month
Delete Tip from MyTips Create User Forms in Microsoft Excel
Delete Tip from MyTips Cell protection only for formulas using VBA in Microsoft Excel
Delete Tip from MyTips Unintentionally Creating Links Between Workbooks
Delete Tip from MyTips Use VLOOKUP Function as an alternative to a number of nested IF functions.
Delete Tip from MyTips Printing a PivotTable Report
Delete Tip from MyTips Totaling Two Ranges Using the SUMIF Formula
Delete Tip from MyTips Determine if a workbook is already open using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values In a Range Specified By Indirect Cell References
Delete Tip from MyTips Summing Sales Amounts According to Product Category and Customer Name
Delete Tip from MyTips Converting Text Representing Minutes and Seconds into Numerical Values
Delete Tip from MyTips Problem: The Minus Sign Appears to the Right of the Number
Delete Tip from MyTips Combine the VLookup and Match formulas in Microsoft Excel
Delete Tip from MyTips Delete rows and columns using VBA in Microsoft Excel
Delete Tip from MyTips Control Excel from Word using VBA in Microsoft Excel
Delete Tip from MyTips How to Use Your Excel Add-In Functions in VBA
Delete Tip from MyTips Finding the Relative Position of Numbers within a String
Delete Tip from MyTips Changing the Indentation in a Cell
Delete Tip from MyTips Selecting a Range of Non-Adjacent Cells
Delete Tip from MyTips Multiplying a Range by -1 in One Operation
Delete Tip from MyTips Validating Number Entries in Excel 2007
Delete Tip from MyTips Drawing Lines Between Sorted Groups
Delete Tip from MyTips Entering Times Quickly
Delete Tip from MyTips PDF2XL Enterprise
Delete Tip from MyTips Creating New IP Addresses
Delete Tip from MyTips Add a New Comment in Excel 2007
Delete Tip from MyTips Printing in Excel 2007
Delete Tip from MyTips Dividing a First Left Heading Title
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips List of File Formats that are Supported in Excel 2007
Delete Tip from MyTips Counting Rows that Match Specific Criteria for Each Column
Delete Tip from MyTips Filtering by Data Type in Excel 2007
Delete Tip from MyTips Finding the Maximal / Minimal String, Based on Alphabetic Order
Delete Tip from MyTips Converting Units
Delete Tip from MyTips Using a Picture to Watch Cell Values in Other Sheets
Delete Tip from MyTips Simplifying complicated multiplication calculations using the SUMPRODUCT function
Delete Tip from MyTips Combining Text from Different Cells
Delete Tip from MyTips Changing a Numeric Heading to Text in Excel 2007
Delete Tip from MyTips Return the cell reference as text in Microsoft Excel
Delete Tip from MyTips Copying, Cutting and Pasting (Moving)
Delete Tip from MyTips Filling a Range with a Series of Dates
Delete Tip from MyTips Protecting a Workbook in Excel 2007
Delete Tip from MyTips The SUMIF Formula – Using Comparison Operators ( ) as Criteria
Delete Tip from MyTips Converting Uppercase Letters to Lowercase
Delete Tip from MyTips Sorting Options in Excel 2007
Delete Tip from MyTips Identifying and selecting the print area in a sheet in Microsoft Excel
Delete Tip from MyTips Defer an Automatically Update of PivotTable Layout Report in Excel 2007
Delete Tip from MyTips Range Name Syntax in Excel 2007
Delete Tip from MyTips Fast Copying & Pasting Right or Down in a List
Delete Tip from MyTips List files in a folder with Microsoft Scripting Runtime using VBA in Microsoft Excel
Delete Tip from MyTips Use listboxes with multiple choices using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Times a Specified Substring Appears within a Range of Strings
Delete Tip from MyTips Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips Adding Euro format to the number format in Microsoft Excel
Delete Tip from MyTips Allowing Multiple Users to Edit Specified Ranges in Excel 2007
Delete Tip from MyTips Selecting Special Cells in Excel 2007
Delete Tip from MyTips Inserting Special Symbols into Custom Formats
Delete Tip from MyTips Create eventmacros for the Application object using VBA in Microsoft Excel
Delete Tip from MyTips Avoiding Negative Values when Calculating the Number of Days between Two Dates
Delete Tip from MyTips Build an Excel Add-In in Microsoft Excel
Delete Tip from MyTips List all the workbook links in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Values from another Sheet Using Date as Sheet Name Reference
Delete Tip from MyTips Extract all the words except the first in Microsoft Excel
Delete Tip from MyTips Applying Formatting Only to Cells Containing Text
Delete Tip from MyTips Counting values meeting multiple criteria in different columns.
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates Percentage Difference from the Previous Item
Delete Tip from MyTips Rounding Prices to the Nearest Nickel, Dime, Quarter and Dollar
Delete Tip from MyTips Search, enter, and delete values using VBA in Microsoft Excel
Delete Tip from MyTips Hiding Errors in Cells Before Printing
Delete Tip from MyTips Altering results returned in case of an error.
Delete Tip from MyTips Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found
Delete Tip from MyTips Retrieving A Value From A Reference Grid, Using Indexes Listed In Another Range
Delete Tip from MyTips Rounding Times Down to a Specified Time Increment
Delete Tip from MyTips Drawing Lines between Sorted Groups in Excel 2007
Delete Tip from MyTips Displaying Formulas and Values of the Same Cells
Delete Tip from MyTips Validating Text Entries
Delete Tip from MyTips Using the Keyboard to Select Chart Items in Microsoft Excel
Delete Tip from MyTips Retrieving a Price Value By Looking at Two Difference Data Tables
Delete Tip from MyTips Use Smart Tag to fill series of dates in Microsoft Excel
Delete Tip from MyTips Access the Private module of a Worksheet Object while in Excel
Delete Tip from MyTips Icons Disappearing from the Toolbar
Delete Tip from MyTips Return a userdefined cell reference from a dialog using VBA in Microsoft Excel
Delete Tip from MyTips Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
Delete Tip from MyTips Creating, and using a Visual Basic Combo/ Edit box
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 ”Desprender” Paletas desde la Barra de Herramientas
Delete Tip from MyTips Rounding Up / Down to the Nearest Multiple of a Specific Number
Delete Tip from MyTips Automatically Wrapping Text in a Cell
Delete Tip from MyTips Display AutoFilter criteria after filtering using VBA in Microsoft Excel
Delete Tip from MyTips Copying a Formula from a Cell While Keeping the Reference in Excel 2007
Delete Tip from MyTips Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells
Delete Tip from MyTips Counting the Number of Unique Items Sold by Each Salesperson
Delete Tip from MyTips Quickly Entering a Long Company or Person Name
Delete Tip from MyTips Copying & Pasting Cell Content to Thousands of Cells in Excel 2007
Delete Tip from MyTips Summing Values from a List Containing Numerical and Textual Substrings
Delete Tip from MyTips Reversing the Word Order within a String
Delete Tip from MyTips Creating a Counting Grid
Delete Tip from MyTips Colorear las Filas Pares Numeradas en una Lista
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened
Delete Tip from MyTips Combining Numbers that Have Leading Zeros
Delete Tip from MyTips Counting the Number of Times a Substring Appears Within a String
Delete Tip from MyTips Preventing Duplicates When Entering Data
Delete Tip from MyTips Copying the Subtotals Summary in Excel 2007
Delete Tip from MyTips Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Search and copy date values using VBA
Delete Tip from MyTips Delete rows with blank cells in a certain column using VBA in Microsoft Excel
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Quarters in a Fiscal Reporting Year
Delete Tip from MyTips Class modules using VBA in Microsoft Excel
Delete Tip from MyTips Printing Formula Syntax in Excel 2007
Delete Tip from MyTips Checking If Matching Numbers Exist in Different Ranges
Delete Tip from MyTips Coloring Gridlines in Excel 2007
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Summing from Closed Workbooks
Delete Tip from MyTips Using the COUNT Functions
Delete Tip from MyTips Hiding the Display of Zero Values in Excel 2007
Delete Tip from MyTips Finding Specified Items in a List and Averaging their Associated Values
Delete Tip from MyTips Counting the Number of Values Between Upper and Lower Limits
Delete Tip from MyTips Calculating Total Income Tax
Delete Tip from MyTips Adding a Data Field That Calculates Percentages from One Item of the Row Field
Delete Tip from MyTips Reduciendo el Área Utilizada en una Hoja
Delete Tip from MyTips Usando una Imagen para Ver Valores de Celda en Otras Hojas
Delete Tip from MyTips Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas
Delete Tip from MyTips Avoiding Errors When Counting Date Values That Meet Specified Criteria
Delete Tip from MyTips Changing the Standard Font 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 Printing Non-Continuous Areas in Excel 2007
Delete Tip from MyTips Format table depending on number formats using VBA in Microsoft Excel
Delete Tip from MyTips Restricting Cell Entries to Text Only
Delete Tip from MyTips Show the time in the Format hh:mm:000 using VBA
Delete Tip from MyTips Displaying the Format Cells Dialog Box in Excel 2007
Delete Tip from MyTips Return error values from user defined functions using VBA in Microsoft Excel
Delete Tip from MyTips Change text in header when printing using VBA in Microsoft Excel
Delete Tip from MyTips Adding Time Values
  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. Retrieving Values Using Range Names as References
  5. Create User Forms in Microsoft Excel
  6. Copy Selection to a Database sheet using VBA in Microsoft Excel
  7. Writing Your First VBA Function in Excel
  8. Replace text in a text file using VBA in Microsoft Excel
  9. Using Loops in VBA in Microsoft Excel
  10. Add Combo Box to a Sheet in Microsoft Excel
  11. Formulas to calculate Loan payments in Microsoft Excel
  12. Turn off warning messages using VBA in Microsoft Excel
  13. Summing Rounded Numbers
  14. Adding the Page Setup Icon to the Excel Menu Bar
  15. Calculating the Number of Business Days in a Specified Period
  16. Rounding Hours Up
  17. Find duplicates items in combine columns in Microsoft Excel
  18. Create an Amortization Schedule in Microsoft Excel
  19. Summing Stock Lists
  20. Working Out a Person's Age in Microsoft Excel



Excel 2007 Tutorials

SEO

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