|  

» 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 Retrieving Data from a PivotTable Report
Delete Tip from MyTips How to change column number with letter in Microsoft Excel
Delete Tip from MyTips Add a cell, Row or a column in Microsoft Excel
Delete Tip from MyTips Selecting Cells from Any Cell to the Last Cell in the Sheet's Used Range
Delete Tip from MyTips Combining Text and a Formatted Date
Delete Tip from MyTips Changing the Default Auto-Save File Location in Excel 2007
Delete Tip from MyTips Calculating Monthly and Accumulated Income, Based on Specified Month
Delete Tip from MyTips Checking for the Presence of Specified Values Within a Range
Delete Tip from MyTips Rules for Organizing the Source Data in Excel Sheets
Delete Tip from MyTips Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Number of Weekday Hours between Two Dates
Delete Tip from MyTips Counting the Number of Cells Containing Text
Delete Tip from MyTips Insert headers and footers using VBA in Microsoft Excel
Delete Tip from MyTips Converting Time Values from One Time Zone to Another
Delete Tip from MyTips Protecting Cells Containing Formulas in an Unprotected Sheet
Delete Tip from MyTips Count the number of cells containing data in a range in Microsoft Excel
Delete Tip from MyTips Calculating the Week Number Corresponding with a Specific Date
Delete Tip from MyTips Creating a Custom Report Manager
Delete Tip from MyTips Conditonal Formatting using Microsoft Excel VBA
Delete Tip from MyTips Printing page number in the opposite direction in landscape layout page in Microsoft Excel
Delete Tip from MyTips Quickly Entering Text into Cells from a List of Previous Entries or a Validation List
Delete Tip from MyTips Deje que Excel lea el texto por usted
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Copy worksheet information to Word using VBA in Microsoft Excel
Delete Tip from MyTips Counting Rows of Even Numbers in Two Parallel Ranges
Delete Tip from MyTips Separating Dates and Times
Delete Tip from MyTips Summing Values in a Range Containing Redundant Spaces
Delete Tip from MyTips Calculating the Absolute Difference between Each List Value and the Minimum Value in the List
Delete Tip from MyTips Copiando el Contenido de Celdas a través de Hojas
Delete Tip from MyTips Combining Numbers that Have Leading Zeros
Delete Tip from MyTips Counting the Number of Items Sold Every Half Hour
Delete Tip from MyTips Subtotal Ribbon in Excel 2007
Delete Tip from MyTips Inserting a picture (company logo) in the header in Microsoft Excel 2002 xp
Delete Tip from MyTips Using the Macro Recorder in Microsoft Excel
Delete Tip from MyTips Change the value/content of several UserForm-controls using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Value of the First Nonblank Cell in a List
Delete Tip from MyTips Filtering by More Than Two Criteria
Delete Tip from MyTips Display AutoFilter criteria after filtering using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values at the Intersection of Two or more Ranges
Delete Tip from MyTips Transposing a Column into Successive Rows of a Specified Length
Delete Tip from MyTips Reduciendo el Área Utilizada en una Hoja
Delete Tip from MyTips Excel 2003 Resources on the Web
Delete Tip from MyTips Transposing an Entire Range of Data into a Single Column
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Altering the results returned by VLOOKUP.
Delete Tip from MyTips Creating a Table in Excel 2007
Delete Tip from MyTips Vlookup Formula – Eliminating Errors
Delete Tip from MyTips Sorting by Columns
Delete Tip from MyTips Backing Up Customized Changes to Toolbars and Menus
Delete Tip from MyTips Retrieving Unique Values From A List
Delete Tip from MyTips Sorting Options in Excel 2007
Delete Tip from MyTips Adjusting Values Returned by the RAND Function
Delete Tip from MyTips Create a Custom Function
Delete Tip from MyTips Adding the Full Path of the Saved File to the Header/Footer
Delete Tip from MyTips Selecting/Formatting Cells Containing Errors
Delete Tip from MyTips Nesting Formulas
Delete Tip from MyTips Create User Forms in Microsoft Excel
Delete Tip from MyTips Excluding Exceptional Values when Calculating an Average
Delete Tip from MyTips Quickly Creating Links Between Ranges
Delete Tip from MyTips Stepping into a Formula
Delete Tip from MyTips Adding and Saving a New Customized Toolbar
Delete Tip from MyTips Copying a Formula from a Cell While Keeping the Absolute Reference or Relative Reference
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout in Excel 2007
Delete Tip from MyTips Rounding Times Down to a Specified Time Increment
Delete Tip from MyTips Retrieving the Price for a Specified Item and a Specified Brand
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Rounding Numbers to Thousands with Hundreds as a Decimal
Delete Tip from MyTips Converting Text Representing Minutes and Seconds into Numerical Values
Delete Tip from MyTips Protecting and Unprotecting Workbooks in Microsoft Excel
Delete Tip from MyTips Changing the Cell Formatting from Date to Number
Delete Tip from MyTips Adding the Subtotals Icon to the Menu Bar
Delete Tip from MyTips Basic information about OLE automation using VBA in Microsoft Excel
Delete Tip from MyTips Selecting All Sheet Cells
Delete Tip from MyTips Shortcuts to see the Help for the Syntax Function in Microsoft Excel
Delete Tip from MyTips Adding a Custom Keyboard Shortcut
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips An Improved Custom Random Numbers Function
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page
Delete Tip from MyTips Adding a Reference to Header/Footer in excel 2007
Delete Tip from MyTips Return text up to the second space in Microsoft Excel
Delete Tip from MyTips Reversing the Word Order within a String
Delete Tip from MyTips Applying Formatting Only to Cells Containing Text
Delete Tip from MyTips Entering Dates Quickly
Delete Tip from MyTips Avoiding Errors When Counting Date Values That Meet Specified Criteria
Delete Tip from MyTips Combining Text and Formatted Values
Delete Tip from MyTips Converting Older Dates to the Current Year
Delete Tip from MyTips Determining Whether a Person Worked a Full or Partial Shift
Delete Tip from MyTips Breaking Links Between Workbooks
Delete Tip from MyTips Change all cells in a range to values using VBA in Microsoft Excel
Delete Tip from MyTips How to calculate VAT / Tax and net sale price in Microsoft Excel
Delete Tip from MyTips Use the format painter to copy column widths and row heights in Microsoft Excel
Delete Tip from MyTips Vlookup Formula – Organizing the Data Table
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Retrieving the Value of the First Non-Blank Cell in a List
Delete Tip from MyTips Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Using Loops in VBA in Microsoft Excel
Delete Tip from MyTips Summing How Many Points Scored by a Specified Team in Specified Games
Delete Tip from MyTips Simplifying Formulas by Defining Names for Often-Repeated Parts
Delete Tip from MyTips Replace value from validation list with a number using VBA in Microsoft Excel
Delete Tip from MyTips Preventing Hidden Sheets from Appearing
Delete Tip from MyTips List all the workbook links in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Allowing Multiple Users to Edit Ranges in Microsoft Excel
Delete Tip from MyTips Open data in two dimensional array and save in sheet using VBA in Microsoft Excel
Delete Tip from MyTips Playing WAV-files using VBA in Microsoft Excel
Delete Tip from MyTips Inserting Subtotals Quickly
Delete Tip from MyTips Add page breaks to sorted data using VBA in Microsoft Excel
Delete Tip from MyTips Generate total for dynamic area using VBA in Microsoft Excel
Delete Tip from MyTips Give a non-Excel look by Hiding the Active Menu And Using Full Screen using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Defining Names for Ranges in a List in Excel 2007
Delete Tip from MyTips Saving a Frequently Used Formula/Numeric Value in the Define Name Dialog Box
Delete Tip from MyTips Adding Data, Charts, or Other Information to a Cell Comment
Delete Tip from MyTips Expanded Paste Icon Features in Excel 2002 & Excel 2003
Delete Tip from MyTips Insert pictures using VBA in Microsoft Excel
Delete Tip from MyTips Use messageboxes using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Custom Views Icon to the Excel Menu Bar
Delete Tip from MyTips Summing the Visible Filtered List Values in Excel 2007
Delete Tip from MyTips Find Active Workbooks Path in Excel 2007
Delete Tip from MyTips Select a printer tray before printing using VBA in Microsoft Excel
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Extracting a substring
Delete Tip from MyTips Reducing the Workbook Size for Quick Sending via E Mail
Delete Tip from MyTips Retrieving the Closest Larger / Closest Smaller Values from a List when there is No Exact Match
Delete Tip from MyTips Creating Progressively Incremented Counting Criteria
Delete Tip from MyTips Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side
Delete Tip from MyTips Summing Subtotals Only from Range
Delete Tip from MyTips Working Out a Person's Age in Microsoft Excel
Delete Tip from MyTips Weeknumbers using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Closest Larger and Closest Smaller Values from a List When There Is No Exact Match
Delete Tip from MyTips Quickly Removing Subtotals
Delete Tip from MyTips Creating and Saving Custom Formatting Styles in Excel 2007
Delete Tip from MyTips List, change or delete external formula references (links) using VBA in Microsoft Excel
Delete Tip from MyTips Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Last Value in a Dynamic List
Delete Tip from MyTips Quickly Selecting a Range of Cells
Delete Tip from MyTips Create a hyperlink from a string in Microsoft Excel
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007
Delete Tip from MyTips Deleting All Cell Comments in a Sheet
Delete Tip from MyTips Hiding Gridlines on the Screen and When Printing
Delete Tip from MyTips Summing values in vertical and horizontal ranges 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 Reversing Strings
Delete Tip from MyTips Using VLOOKUP and ISNA functions to find matching values in different sheets
Delete Tip from MyTips Dando Formato a un Número Negativo con Paréntesis
Delete Tip from MyTips Changing the font size of the Sheet name in Microsoft Excel
Delete Tip from MyTips Calculating Hours Worked
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Using multiple criteria in SUMIF Function
Delete Tip from MyTips Entering the Current Time into a Cell
Delete Tip from MyTips Calculating the Number of Weekday Hours Between Two Dates
Delete Tip from MyTips Summing Values from Two Ranges, Based on Two Criteria
  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. Summing Stock Lists
  20. Converting Time to Decimal Values

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