|  

» 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 Creating a Timesheet
Delete Tip from MyTips Sorting by Columns
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates Percentage Difference from the Previous Item
Delete Tip from MyTips Inserting a picture (company logo) in Microsoft Excel 97 and 2000
Delete Tip from MyTips Calculating the Average of Every Nth Value, Excluding Zeros
Delete Tip from MyTips Creating List Objects
Delete Tip from MyTips Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
Delete Tip from MyTips Find if a character is in a range in Microsoft Excel
Delete Tip from MyTips Returning the Entire Contents of the Row Containing the Highest Math Grade
Delete Tip from MyTips Worksheet functions in VBA macros using VBA in Microsoft Excel
Delete Tip from MyTips Changing a Numeric Heading to Text
Delete Tip from MyTips Adding a Calculated Percentage Field
Delete Tip from MyTips Pasting Values
Delete Tip from MyTips Changing the Source Link
Delete Tip from MyTips Protecting Data by Hiding a Row(s) and Column(s)
Delete Tip from MyTips Calculating the Week Number Corresponding with a Specific Date
Delete Tip from MyTips Preventing Hidden Sheets from Appearing
Delete Tip from MyTips Inserting Subtotals Quickly
Delete Tip from MyTips PivotTable Report Terminology
Delete Tip from MyTips Make LEFT Function recognize a number
Delete Tip from MyTips Calculating Monthly and Accumulated Income, Based on Specified Month
Delete Tip from MyTips Determine if a sheet exists in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Comparing Three or More Lists in Microsoft Excel
Delete Tip from MyTips Use Smart Tag to fill series of dates in Microsoft Excel
Delete Tip from MyTips Using a Range Name in a Formula
Delete Tip from MyTips Los Iconos Desaparecen de la Barra de Herramientas
Delete Tip from MyTips Cambiar la Sangría en una Celda
Delete Tip from MyTips Compare two worksheets using VBA in Microsoft Excel
Delete Tip from MyTips How to Use Your Excel Add-In Functions in VBA
Delete Tip from MyTips Return text up to the second space in Microsoft Excel
Delete Tip from MyTips Counting the Number of Values Below or Above Average
Delete Tip from MyTips Sum the digits numbers in a cell using custom VBA function in Microsoft Excel
Delete Tip from MyTips Summing Positive and Negative Numbers Separately
Delete Tip from MyTips Breaking Links Between Workbooks
Delete Tip from MyTips Calculating Time Differences Between Regions of the World
Delete Tip from MyTips Save a workbook backup using VBA in Microsoft Excel
Delete Tip from MyTips Mostrando Cifras Redondeadas a Miles en un Reporte Financiero
Delete Tip from MyTips Copying the Subtotals Summary in Excel 2007
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Summing data by selecting cells in Microsoft Excel
Delete Tip from MyTips Add a cell, Row or a column in Microsoft Excel
Delete Tip from MyTips Expanded Paste Icon Features in Excel 2002 & Excel 2003
Delete Tip from MyTips Calculating a Project's End Date
Delete Tip from MyTips Add special symbols to the number format
Delete Tip from MyTips Function for returning the computer name using VBA in Microsoft Excel
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Pass arguments to macros from buttons and menus using VBA in Microsoft Excel
Delete Tip from MyTips Creating email address
Delete Tip from MyTips Retrieving the Value of the First Non-Blank Cell in a List
Delete Tip from MyTips Moving the Chart to a Different Place in the Sheet in Microsoft Excel
Delete Tip from MyTips Summing the Absolute Values of All Numbers in a Range
Delete Tip from MyTips Change the worksheet codemodule names using VBA in Microsoft Excel
Delete Tip from MyTips Getting Drill-Down Details
Delete Tip from MyTips Change slash separator in date with period in Microsoft Excel
Delete Tip from MyTips Finding Minimum / Maximum Values
Delete Tip from MyTips Filling a Range with a Series of Dates
Delete Tip from MyTips Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Determine if a workbook is already open using VBA in Microsoft Excel
Delete Tip from MyTips Converting a Month's Serial Number into Its Corresponding Name
Delete Tip from MyTips Copying a series from one chart to another in Microsoft Excel
Delete Tip from MyTips Utilizando Paneles de Tareas
Delete Tip from MyTips E-mailing an Excel Workbook, Sheet, Data or Chart
Delete Tip from MyTips Counting the Number of Strings which Contain Numbers Meeting Criteria
Delete Tip from MyTips Import data from a text file (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Report Using Report Manager Add-In in Excel 2007
Delete Tip from MyTips Copiando y Pegando Rápido a la Derecha o Debajo en una Lista
Delete Tip from MyTips Getting Values From A Closed Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Index Formula vs. Vlookup Formula
Delete Tip from MyTips Return random numbers using VBA in Microsoft Excel
Delete Tip from MyTips Use Sorting to Delete Blank Rows in Excel 2007
Delete Tip from MyTips Basic information about OLE automation using VBA in Microsoft Excel
Delete Tip from MyTips Hiding Data Before Printing
Delete Tip from MyTips Printing page number in the opposite direction in landscape layout page in Microsoft Excel
Delete Tip from MyTips Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel
Delete Tip from MyTips Validating text entries in Microsoft Excel
Delete Tip from MyTips Retrieving Sale Price Based On Item And Color Criteria
Delete Tip from MyTips Insert a new module from a file using VBA in Microsoft Excel
Delete Tip from MyTips Problem: Date Formatting Cannot Be Changed
Delete Tip from MyTips Control Outlook from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Consolidating Lists While Adding Links to the Source Data
Delete Tip from MyTips Removing the Smart Tag Indicator
Delete Tip from MyTips Hide/Unhide a Sheet in Excel 2007
Delete Tip from MyTips Find the address of the max value in range in Microsoft Excel
Delete Tip from MyTips Reversing The Order Of Values In A List
Delete Tip from MyTips Hiding Errors in Cells Before Printing
Delete Tip from MyTips Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas
Delete Tip from MyTips Displaying Formula Syntax in Excel 2007
Delete Tip from MyTips Changing the Default Style
Delete Tip from MyTips Import data from Access to Excel (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips Multiplying a Range by -1 in One Operation
Delete Tip from MyTips Defer an Automatically Update of PivotTable Layout Report in Excel 2007
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Calculating Total Time Worked on a Specific Day
Delete Tip from MyTips Printing a PivotTable Report 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 Count the number of times dates in certain month appears in range in Microsoft Excel
Delete Tip from MyTips Determine if an application is available using VBA in Microsoft Excel
Delete Tip from MyTips Add page breaks to sorted data using VBA in Microsoft Excel
Delete Tip from MyTips Creating a Table in Excel 2007
Delete Tip from MyTips Return a userdefined cell reference from a dialog using VBA in Microsoft Excel
Delete Tip from MyTips Copy a row or rows from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Comparing Lists in Excel 2007
Delete Tip from MyTips Validating Text Entries
Delete Tip from MyTips Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Creating Progressively Incremented Counting Criteria
Delete Tip from MyTips Finding and Deleting Unwanted and Orphan Links in Excel 2007
Delete Tip from MyTips Replace text in a text file using VBA in Microsoft Excel
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet in Excel 2007
Delete Tip from MyTips Adding a Data Field That Calculates Percentages from One Item of the Row Field
Delete Tip from MyTips Calculating Daily Pay, Incorporating Variable Hourly Rates
Delete Tip from MyTips Using the Macro Recorder in Microsoft Excel
Delete Tip from MyTips Restore the position in the window using VBA in Microsoft Excel
Delete Tip from MyTips Summing the Visible Filtered List
Delete Tip from MyTips Avoiding Errors When Counting Date Values That Meet Specified Criteria
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Combinar y Centrar con un Botón de Cambio en Excel 2002 y Excel 2003
Delete Tip from MyTips Calculating the Difference Between Hours
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Days, Months, Quarters, and Years
Delete Tip from MyTips Control Word from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Change a Column or Columns to values using VBA in Microsoft Excel
Delete Tip from MyTips Delete all cells with today's date using VBA
Delete Tip from MyTips Preventing a Printed Area from Extending onto an Extra Page in Excel 2007
Delete Tip from MyTips Printing Non-Continuous Areas
Delete Tip from MyTips Qué hay de Nuevo en Excel 2002/2003: Menú, menú contextual de celdas y nuevos métodos abreviados
Delete Tip from MyTips Display all installed fonts (Excel) using VBA in Microsoft Excel
Delete Tip from MyTips Summing Sales Amounts According to Product Category and Customer Name
Delete Tip from MyTips Ranking Salespeople According To Sales Figure
Delete Tip from MyTips Restricting the Number of Characters Entered into a Cell
Delete Tip from MyTips Hiding Outline Symbols
Delete Tip from MyTips Validating Date Entries in Excel 2007
Delete Tip from MyTips Calculating Total Annual Payment Based on Cumulative Monthly Payments
Delete Tip from MyTips Summing Values at the Intersection of Two or more Ranges
Delete Tip from MyTips Array variables using VBA in Microsoft Excel
Delete Tip from MyTips Preventing charts from being printed in Microsoft Excel
Delete Tip from MyTips Searching a String for a Specific Substring
Delete Tip from MyTips Rounding Numbers that Meet Specified Criteria
Delete Tip from MyTips Row and column background color using VBA in Microsoft Excel
Delete Tip from MyTips Creating a PivotTable Report in Excel 2007
Delete Tip from MyTips The SUMIF Formula – Using Comparison Operators ( ) as Criteria
Delete Tip from MyTips Filtering by Data Type in Excel 2007
Delete Tip from MyTips Selecting a Sheet in the Workbook
Delete Tip from MyTips Calculating the Average Value in Every Nth Column, Excluding Zeros
Delete Tip from MyTips Sort Ascending/Descending While Using AutoFilter
Delete Tip from MyTips Displaying the Format Cells Dialog Box
Delete Tip from MyTips Change the default printer using VBA in Microsoft Excel
Delete Tip from MyTips Setting the Number of Fields Displayed in the Page Layout
Delete Tip from MyTips Linking a Cell to a Text Box
Delete Tip from MyTips Mail sheet(s) to one or more people using VBA in Microsoft Excel
Delete Tip from MyTips The Filter Ribbon in excel 2007
Delete Tip from MyTips Preventing Movement in Protected Areas in Microsoft Excel
Delete Tip from MyTips Rounding Numbers to Thousands
Delete Tip from MyTips Grouping a Date Field by Quarters in a Fiscal Reporting Year in Excel 2007
Delete Tip from MyTips To highlight Header Rows/Columns or Banded Rows/Columns in Excel 2007
Delete Tip from MyTips The PivotTable Tools Ribbon in Excel 2007
Delete Tip from MyTips Counting the Number of Items Sold Every Half Hour
Delete Tip from MyTips Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
Delete Tip from MyTips Entering the Current Date into a Cell
Delete Tip from MyTips Delete rows with blank cells in a certain column using VBA in Microsoft Excel
Delete Tip from MyTips Adding Passwords to Prevent Unauthorized Opening of a Workbook in Excel 2007
Delete Tip from MyTips Adding the Subtotals Icon to the Menu Bar
Delete Tip from MyTips PivotTable report - Adding a Calculated Field
Delete Tip from MyTips Sum by color using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Numbers to Millions with Thousands as a Decimal
Delete Tip from MyTips Count the number of cells in a range containing all types of Errors in Microsoft Excel
Delete Tip from MyTips Protecting the Sheet or the Cells in the Sheet
Delete Tip from MyTips Convert text to lower case in Microsoft Excel
Delete Tip from MyTips Copy a column or columns from each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Summing matching values in multiple rows
Delete Tip from MyTips Reversing Strings
Delete Tip from MyTips Adding Groups and Outlines Manually
Delete Tip from MyTips Converting a Julian Date to a Calendar Date
Delete Tip from MyTips Totaling Two Ranges Using the SUMIF Formula
Delete Tip from MyTips Summing the Visible Filtered List Values in Excel 2007
Delete Tip from MyTips Avoiding Errors When Subtracting Times
Delete Tip from MyTips Protecting Workbooks with a Digital Signature in Excel 2007
Delete Tip from MyTips Change cells in the Activecell rowrange to values using VBA in Microsoft Excel
Delete Tip from MyTips Summing using multiple criteria in Microsoft Excel
Delete Tip from MyTips Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up
Delete Tip from MyTips Entering Dates Quickly
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Converting Text Representing Minutes and Seconds into Numerical Values
Delete Tip from MyTips Finding the Score that Was the Nth Highest for a Specified Team
Delete Tip from MyTips Adding a Shortcut for Wrapping Text
Delete Tip from MyTips Return error values from user defined functions using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Refreshing a PivotTable Report
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened
Delete Tip from MyTips Rounding Times Down to the Nearest 30 Seconds
Delete Tip from MyTips Show/Hide Field Header in Excel 2007
Delete Tip from MyTips Finding the First Login and Last Logout Times of Employees
Delete Tip from MyTips Counting the Number of Excel Files in a List According to File Type and Date Criteria
Delete Tip from MyTips Print multiple selections on one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Find the minimum numerical value in a list based on a criteria 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 Formatting a PivotTable Report
Delete Tip from MyTips Copy a range with one Area to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Filtered List in Excel 2007
Delete Tip from MyTips Getting Drill-Down Details in Excel 2007
Delete Tip from MyTips Formatting a Negative Number with Parentheses
Delete Tip from MyTips Add values from the previous or next worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Eliminating Negative Values from Date Subtractions
Delete Tip from MyTips Copying & Pasting Cell Content to Thousands of Cells
Delete Tip from MyTips Validating Date Entries
Delete Tip from MyTips Adding Additional PivotTable Reports Using the Same Data Source
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates the Difference from the Previous Item
Delete Tip from MyTips Summing a range containing errors and values in Microsoft Excel
Delete Tip from MyTips Counting Vacation or Sick Days within a Specified Time Period
Delete Tip from MyTips Pasting Multiple Copied Ranges Using the Clipboard
Delete Tip from MyTips Summing Values from Cells in Different Sheets
Delete Tip from MyTips Selecting Cells in Horizontal or Vertical Ranges
Delete Tip from MyTips Converting Time Values from One Time Zone to Another
Delete Tip from MyTips Calculating a Date Based on Year, Week Number and Day of the Week
Delete Tip from MyTips Finding the Number of Days in a Given Month
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips Create styles directly from cells in Microsoft Excel
Delete Tip from MyTips Count cells in a range from all worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Look up unique values using VBA in Microsoft Excel
Delete Tip from MyTips Change all the cells in the ActiveSheet to values using VBA in Microsoft Excel
Delete Tip from MyTips Calculating Absolute Difference between Two Time Values
Delete Tip from MyTips Simplifying complicated multiplication calculations using the SUMPRODUCT function
Delete Tip from MyTips Inserting a Field that Calculates the Difference between Two Fields in Excel 2007
Delete Tip from MyTips Calculate a weeks start date using VBA in Microsoft Excel
Delete Tip from MyTips Password to prevent opening a workbook in Microsoft Excel
Delete Tip from MyTips Summing Annual Expenses by Respective Quarters
Delete Tip from MyTips Coloring Two Subtotal Levels in Different Colors
Delete Tip from MyTips Refreshing the Data in PivotTable Report while Opening a Workbook in Excel 2007
Delete Tip from MyTips Quick Filtering Using the AutoFilter Icon
Delete Tip from MyTips Validating Number Entries
Delete Tip from MyTips List of File Formats that are Supported in Excel 2007
Delete Tip from MyTips Change all cells in a range to values using VBA in Microsoft Excel
Delete Tip from MyTips Sorting Sheets in Ascending Order
Delete Tip from MyTips Summing Values in a Range Containing Redundant Spaces
Delete Tip from MyTips Setting the Default Chart Type in Microsoft Excel
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Problem: Unnecessary Empty Characters in Cells
Delete Tip from MyTips Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
Delete Tip from MyTips Selecting a row or rows in Microsoft Excel
Delete Tip from MyTips Change a Row or Rows to values to values using VBA in Microsoft Excel
Delete Tip from MyTips Inserting a New Sheet from a Template Sheet
Delete Tip from MyTips Changing the Default Auto-Save File Location in Excel 2007
Delete Tip from MyTips Inserting a Chart in Excel 2007
Delete Tip from MyTips Calculating a Building's Occupancy Rate at Specified Times
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 Find Active Workbooks Path in Excel 2007
Delete Tip from MyTips Separating a Number Into Digits
Delete Tip from MyTips Protecting Workbooks with a Digital Signature
Delete Tip from MyTips Determine if a cell is within a range using VBA in Microsoft Excel
Delete Tip from MyTips Combining Data from Separate Columns into a Single Date and Time Value
Delete Tip from MyTips Calculate holidays 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 Creating a Date and Time Matrix
Delete Tip from MyTips Display Direction in Excel 2007
Delete Tip from MyTips Copy a Row or Rows to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Hiding Items
Delete Tip from MyTips Adding the Path Address to the Header/Footer
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 Quickly Typing Dates into Cells
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting
Delete Tip from MyTips Setting the Number of Fields Displayed in Excel 2007
Delete Tip from MyTips Insert headers and footers using VBA in Microsoft Excel
Delete Tip from MyTips Copy Selection to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Adding/Deleting Subtotals
Delete Tip from MyTips PivotTable report - Inserting a Chart
Delete Tip from MyTips Return unique items using VBA in Microsoft Excel
Delete Tip from MyTips Drag Fields into PivotTable Report in Excel 2007
Delete Tip from MyTips Creating a World Time Converter
Delete Tip from MyTips Copy all rows of a column without a value using VBA in Microsoft Excel
Delete Tip from MyTips Automating the Insertion of the Euro Symbol
Delete Tip from MyTips Cell Function Returns Sheet Name, Workbook Name and Path
Delete Tip from MyTips Copy a Column or Columns to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving a Value from a PivotTable Report in Excel 2007
Delete Tip from MyTips Inserting a Copied Cell(s) Without Overwriting Existing Data
Delete Tip from MyTips Calculating the Week Number Corresponding with a Specific Date
Delete Tip from MyTips Expand/Collapse Entire Items in a Field in Excel 2007
Delete Tip from MyTips Saving Filtering Criteria in Excel 2007
Delete Tip from MyTips Mail Sheet Array using VBA in Microsoft Excel
Delete Tip from MyTips Change the selection with one or more areas to Values using VBA in Microsoft Excel
Delete Tip from MyTips Protecting a Workbook in Excel 2007
Delete Tip from MyTips Calculating the Number of Weekday Hours between Two Dates
Delete Tip from MyTips Identifying the Case of Letters within Strings
Delete Tip from MyTips Saving a Customized Workbook as a Template
Delete Tip from MyTips Counting the Number of Values Between Upper and Lower Limits
Delete Tip from MyTips Unprinted blank pages in Microsoft Excel 2002
Delete Tip from MyTips Extracting Characters from Text Using Text Formulas
Delete Tip from MyTips Creating and Saving Custom Styles
  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. 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