|  

» 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 Count the number of cells in a range containing all types of Errors in Microsoft Excel
Delete Tip from MyTips Converting Uppercase Letters to Lowercase
Delete Tip from MyTips Create User Forms in Microsoft Excel
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
Delete Tip from MyTips Summing Stock Lists
Delete Tip from MyTips Retrieving Sale Price Based On Item And Color Criteria
Delete Tip from MyTips Delete sheets without confirmation prompts using VBA in Microsoft Excel
Delete Tip from MyTips Calculating a Required Date According to Two Criteria
Delete Tip from MyTips Retrieving From List By Position
Delete Tip from MyTips Moving Between Precedent and Dependent Cells
Delete Tip from MyTips Summing Annual Expenses by Respective Quarters
Delete Tip from MyTips Create styles directly from cells in Microsoft Excel
Delete Tip from MyTips Determine the type of operating system using VBA in Microsoft Excel
Delete Tip from MyTips Grouping the Date Field by Number of Days
Delete Tip from MyTips Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts
Delete Tip from MyTips Calculating the Average of Every Nth Value
Delete Tip from MyTips Removing Redundant Characters from a Range of Cells and Resetting the Format
Delete Tip from MyTips Change the state of a custom CommandBar button using VBA in Microsoft Excel
Delete Tip from MyTips Problem: Date Formatting Cannot Be Changed in Excel 2007
Delete Tip from MyTips Hiding Gridlines on the Screen and When Printing
Delete Tip from MyTips Changing the Default Auto-Save File Location in Excel 2007
Delete Tip from MyTips Copy cells from the ActiveCell Row to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Adding non-contiguous ranges to a single contiguous range for printing in Microsoft Excel
Delete Tip from MyTips Delete rows and columns using VBA in Microsoft Excel
Delete Tip from MyTips Find Active Workbooks Path in Excel 2007
Delete Tip from MyTips Cambiando un Encabezado Numérico a Texto
Delete Tip from MyTips Setting the Number of Fields Displayed in Excel 2007
Delete Tip from MyTips Hiding the Display of Zero Values in Excel 2007
Delete Tip from MyTips Export data from Excel to Access (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Nth Value in a Row / Column
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Quarters in a Fiscal Reporting Year
Delete Tip from MyTips Summing the Absolute Values of All Numbers in a Range
Delete Tip from MyTips Filtering a Range into a List of Unique Records
Delete Tip from MyTips Protecting a Workbook in Excel 2007
Delete Tip from MyTips Change a Row or Rows to values to values using VBA in Microsoft Excel
Delete Tip from MyTips Export data from Excel to Access (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel
Delete Tip from MyTips Escribiendo Rápido un Nombre Largo de Empresa o Persona
Delete Tip from MyTips Selecting a Set of Random Numbers, Avoiding Duplicates
Delete Tip from MyTips Creating a Custom Report Manager
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Check if a VBProject is protected using VBA in Microsoft Excel
Delete Tip from MyTips List all fonts available in Excel using VBA in Microsoft Excel
Delete Tip from MyTips Combining Text from Different Cells
Delete Tip from MyTips Display Direction in Excel 2007
Delete Tip from MyTips Adding Groups and Outlines Manually
Delete Tip from MyTips Adding a Number to a Formatted Time Value
Delete Tip from MyTips Calculating an Average, Only Including Prices on Which There Was no Discount
Delete Tip from MyTips Use the continuous page numbers technique in Report Manager in Microsoft Excel.
Delete Tip from MyTips Creating Charts with F11 in Microsoft Excel
Delete Tip from MyTips Autoexpanding a Date Type Chart using Microsoft Excel
Delete Tip from MyTips Fast Copying & Pasting Right or Down in a List
Delete Tip from MyTips Coloring Numbers Based on Specific 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 Adding a Calculated Percentage Field
Delete Tip from MyTips Counting how many times specific character appears in cell in Microsoft Excel
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Creating a Timesheet
Delete Tip from MyTips Summing data by selecting cells in Microsoft Excel
Delete Tip from MyTips Use Smart Tag to fill series of dates in Microsoft Excel
Delete Tip from MyTips Extracting Characters from Text Using Text Formulas
Delete Tip from MyTips Create a Custom Function
Delete Tip from MyTips Formatting a PivotTable Report
Delete Tip from MyTips Seperating Website Name or URL from Text
Delete Tip from MyTips Entering Formulas More Quickly by Shortening Sheet Names
Delete Tip from MyTips Retrieving the Column Header of the Next Non-Blank Cell in a Row
Delete Tip from MyTips Enter the holiday according to the Table in the holiday-list using VBA
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria Using Conditional Formatting
Delete Tip from MyTips Inserting/Editing Formulas
Delete Tip from MyTips Drawing Lines Between Sorted Groups
Delete Tip from MyTips How to find the minimum value in range while ignoring 0 value in Microsoft Excel
Delete Tip from MyTips Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References
Delete Tip from MyTips Hiding or unhiding a column or columns in Microsoft Excel
Delete Tip from MyTips Worksheet events using VBA in Microsoft Excel
Delete Tip from MyTips Modifying a SUMPRODUCT function to Return a Sum Rather than a Count
Delete Tip from MyTips Changing the Indentation in a Cell
Delete Tip from MyTips Retrieving the Player Who Scored the Highest Number of Points
Delete Tip from MyTips Close a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Insert New Sheet in Excel 2007
Delete Tip from MyTips Import data from a text file (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Calculating Total Income Tax
Delete Tip from MyTips Vlookup Formula – Eliminating Errors
Delete Tip from MyTips Inserting Special Symbols into Custom Formats
Delete Tip from MyTips Adjust row height of merged cells using VBA in Microsoft Excel
Delete Tip from MyTips Problem: Date Formatting Cannot Be Changed
Delete Tip from MyTips Adding the Subtotals Icon to the Menu Bar
Delete Tip from MyTips Seleccionando la Lista/Región Actual
Delete Tip from MyTips Applying Formatting Only to Cells Containing Text
Delete Tip from MyTips Highlight a selected range with a MsgBox using VBA in Microsoft Excel
Delete Tip from MyTips Import data from Access to Excel (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Custom View in Excel 2007
Delete Tip from MyTips Summing the Visible Filtered List Values in Excel 2007
Delete Tip from MyTips Using Task Panes
Delete Tip from MyTips Playing sound notes using VBA in Microsoft Excel
Delete Tip from MyTips Show/Hide Expand Items Buttons in Excel 2007
Delete Tip from MyTips Printing page number in the opposite direction in landscape layout page in Microsoft Excel
Delete Tip from MyTips Changing the Standard Font
Delete Tip from MyTips Altering results returned in case of an error.
Delete Tip from MyTips Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula.
Delete Tip from MyTips Change only the CurrentRegion of the ActiveCell to values using VBA in Microsoft Excel
Delete Tip from MyTips Copying Cell Content Across Sheets
Delete Tip from MyTips Combine column text and replace using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values Based on Text Criteria
Delete Tip from MyTips Counting the number of cells containing a substring
Delete Tip from MyTips Transposing Cells
Delete Tip from MyTips Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
Delete Tip from MyTips Adding Continuous Page Numbers While Printing
Delete Tip from MyTips Finding the maximum value of all those meeting a certain criteria.
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Displaying Formulas and Values of the Same Cells
Delete Tip from MyTips Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Summing the N Largest Values in a Range
Delete Tip from MyTips Display a message on the statusbar using VBA in Microsoft Excel
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
Delete Tip from MyTips Add Group and Outline in Excel 2007
Delete Tip from MyTips Counting Rows that Match Specific Criteria for Each Column
Delete Tip from MyTips Simplifying complicated multiplication calculations using the SUMPRODUCT function
Delete Tip from MyTips Tracing Errors in Formula Results
Delete Tip from MyTips Add page breaks to sorted data using VBA in Microsoft Excel
Delete Tip from MyTips Count by color using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Numbers to Thousands with Hundreds as a Decimal
Delete Tip from MyTips Count the number of cells containing data in a range in Microsoft Excel
Delete Tip from MyTips Calculating Military Time Intervals
Delete Tip from MyTips Expand/Collapse Entire Items in a Field in Excel 2007
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 Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Deleting a Name when the Reference containing an Error or an Orphan Name in Excel 2007
Delete Tip from MyTips Protecting Cells in the Sheet in Excel 2007
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Saving Defined Page Setups for Future Printing in Excel 2007
Delete Tip from MyTips Show/Hide Field Header in Excel 2007
Delete Tip from MyTips Values Not Formatted as Numbers in Excel 2007
Delete Tip from MyTips Quickly Printing a Page from the Workbook Using a Custom View
Delete Tip from MyTips Calculate a weeks start date using VBA in Microsoft Excel
Delete Tip from MyTips Sum Total Sales Except for One Specified Item
Delete Tip from MyTips Saving a Frequently Used Formula/Numeric Value in the Define Name Dialog Box
Delete Tip from MyTips Find the last numeric value in a range in Microsoft Excel
Delete Tip from MyTips Copying, Cutting and Pasting (Moving)
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips Create Conditional Formula
Delete Tip from MyTips Encoding a Sequence of Letters
Delete Tip from MyTips Display all installed fonts (Word) 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 Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
Delete Tip from MyTips Retrieving the Price for a Specified Item and a Specified Brand
Delete Tip from MyTips Retrieving the Most Frequent Occurrence for Each Category
Delete Tip from MyTips Inserting a Copied Cell(s) Without Overwriting Existing Data
Delete Tip from MyTips Applying Styles to Subtotal Rows
Delete Tip from MyTips PivotTable Field List Dialog Box in Excel 2007
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Control Excel from Word using VBA in Microsoft Excel
Delete Tip from MyTips Preventing Movement in Protected Areas in Microsoft Excel
Delete Tip from MyTips Calculating the Quarter Number
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 97
Delete Tip from MyTips Identifying Duplicate Rows within a Range
Delete Tip from MyTips Selecting a Column(s) or Row(s) Using Keyboard Shortcuts
Delete Tip from MyTips Transposing a Range in Ascending Order
Delete Tip from MyTips Selecting/Formatting Cells Containing Errors
Delete Tip from MyTips How Excel Sorts Lists
Delete Tip from MyTips Conditional formatting depending on a cell comment using VBA in Microsoft Excel
Delete Tip from MyTips Replacing Substrings with Numbers from Adjacent Cells
Delete Tip from MyTips Avoiding the #VALUE! Error When Adding Cells That May Contain Blanks
Delete Tip from MyTips Selecting Cells That Contain Formulas
Delete Tip from MyTips Make LEFT Function recognize a number
Delete Tip from MyTips Auto-Recovering/ Auto-Saving a Workbook
Delete Tip from MyTips List of File Formats that are Supported in Excel 2007
Delete Tip from MyTips An Improved Custom Random Numbers Function
Delete Tip from MyTips Ranking a List of Numbers
Delete Tip from MyTips Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
Delete Tip from MyTips Determining Whether a Worked Shift Was Morning, Afternoon or Night
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
Delete Tip from MyTips Funcionalidades Expandidas de Pegado de Íconos en Excel 2002 y Excel 2003
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet in Excel 2007
Delete Tip from MyTips Distribute Data from a List of the day to day sheets using VBA
Delete Tip from MyTips Add unique values using VBA in Microsoft Excel
Delete Tip from MyTips Identifying the Case of Letters within Strings
Delete Tip from MyTips Printing a Chart in Microsoft Excel
Delete Tip from MyTips Summing the Visible Filtered List
Delete Tip from MyTips Changing the Default Style
Delete Tip from MyTips Copying or Moving a Sheet
Delete Tip from MyTips Adding a Custom Keyboard Shortcut
Delete Tip from MyTips Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Delete Tip from MyTips Converting Time to Decimal Values
Delete Tip from MyTips Use AutoCorrect to enter special symbols in Microsoft Excel
Delete Tip from MyTips Moving the Chart to a Different Place in the Sheet in Microsoft Excel
Delete Tip from MyTips Setting the Default Chart Type in Microsoft Excel
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting
Delete Tip from MyTips Reversing the Word Order within a String
Delete Tip from MyTips Dividing a First Left Heading Title
  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. Working Out a Person's Age in Microsoft Excel
  16. Turn off warning messages using VBA 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