|  

» 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 Copying Styles from One Workbook to Another
Delete Tip from MyTips Printing Formula Syntax
Delete Tip from MyTips Changing the Default Cell Comment Format
Delete Tip from MyTips Add and Save new Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Import data from Access to Excel (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Selecting a Sheet from a Sorted Sheets List
Delete Tip from MyTips Change the selection with one or more areas to Values using VBA in Microsoft Excel
Delete Tip from MyTips Pass arguments to macros from buttons and menus using VBA in Microsoft Excel
Delete Tip from MyTips Summing Annual Expenses by Respective Quarters
Delete Tip from MyTips Separating Dates and Times
Delete Tip from MyTips Replacing Data Markers with Pictures in Microsoft Excel
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips Hiding Data Before Printing
Delete Tip from MyTips Add unique values using VBA in Microsoft Excel
Delete Tip from MyTips Counting Time Values in Terms of Hourly Increments
Delete Tip from MyTips Using a VLOOKUP Formula to Check If a Value Exists
Delete Tip from MyTips Change range with more then Area to values using VBA in Microsoft Excel
Delete Tip from MyTips Calculating Hourly Productivity
Delete Tip from MyTips Problem: The Minus Sign Appears to the Right of the Number
Delete Tip from MyTips Filtering by More Than Two Criteria
Delete Tip from MyTips Retrieving the Value of the First Nonblank Cell in a List
Delete Tip from MyTips Retrieving Matching Values From Not Adjacent List
Delete Tip from MyTips Counting Unique Numeric Values or Unique Data in a List
Delete Tip from MyTips Combining Text and a Formatted Date into a Single Entity
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Quarters in a Fiscal Reporting Year
Delete Tip from MyTips Retrieving a Price from a List that Matches both Category and Item Criteria
Delete Tip from MyTips Displaying the Serial Number Behind the Date
Delete Tip from MyTips Sorting Numbers in Ascending or Descending Order
Delete Tip from MyTips Finding and Deleting Unwanted and Orphan Links in Excel 2007
Delete Tip from MyTips Select filenames using VBA in Microsoft Excel
Delete Tip from MyTips Redondeando Números a Miles con Centésimas como Decimales
Delete Tip from MyTips Calculate number of minutes between dates - time in Microsoft Excel
Delete Tip from MyTips E-mailing an Excel Workbook, Sheet, Data or Chart
Delete Tip from MyTips Calculating the Number of Hours Worked Based on a System of Letter Codes
Delete Tip from MyTips Automatically Refreshing a PivotTable Report
Delete Tip from MyTips Using Financial Functions
Delete Tip from MyTips Edit the tooltip for toolbarbuttons using VBA in Microsoft Excel
Delete Tip from MyTips Formulas Erroneously Appearing as Text
Delete Tip from MyTips Unprinted blank pages in Microsoft Excel 2002
Delete Tip from MyTips Sizing Charts with the Window in Microsoft Excel.
Delete Tip from MyTips Set up yellow background color for header in an AutoFilter table using VBA in Microsoft Excel
Delete Tip from MyTips Selecting Cells That Contain Formulas
Delete Tip from MyTips Adding the Camera icon to the toolbar in Microsoft Excel
Delete Tip from MyTips Prevent Unauthorized Opening of Workbook
Delete Tip from MyTips Control Outlook from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Weeknumbers using VBA in Microsoft Excel
Delete Tip from MyTips Convert negative values treated as text using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Entering the Current Date into a Cell
Delete Tip from MyTips Using the COUNT Functions
Delete Tip from MyTips Count the number of values between a lower and upper limit in Microsoft Excel
Delete Tip from MyTips Open and close the CD-ROM tray using VBA in Microsoft Excel
Delete Tip from MyTips Protecting a Workbook
Delete Tip from MyTips Opening a Copy of an Existing Workbook
Delete Tip from MyTips Multiplying time values and numbers.
Delete Tip from MyTips Eliminating Errors Resulting from If Functions with Multiple Conditions
Delete Tip from MyTips To Fill Values Right or Down in a List in Excel 2007
Delete Tip from MyTips Calculating the Average Growth of a Child
Delete Tip from MyTips Hiding or unhiding a column or columns 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 Fast Summation
Delete Tip from MyTips Displaying the Serial Number Behind the Time
Delete Tip from MyTips Color numbers based on the value result in Microsoft Excel
Delete Tip from MyTips Saving a Customized Workbook as a Template
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 a Running Balance Calculation Column
Delete Tip from MyTips Calculating Average Annual Growth
Delete Tip from MyTips Removing icons from toolbars 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 Retrieve Value Using Case-Sensitive Lookups
Delete Tip from MyTips Replace value from validation list with a number using VBA in Microsoft Excel
Delete Tip from MyTips Using Different Functions to Consolidate Lists
Delete Tip from MyTips Counting the Number of Times a Specified Substring Appears within a Range of Strings
Delete Tip from MyTips Count cells in a range from all worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Fast Copying & Pasting in Adjacent Cells
Delete Tip from MyTips Change slash separator in date with period in Microsoft Excel
Delete Tip from MyTips Retrieving List Values that Do Not Appear in a Second List
Delete Tip from MyTips Count the number of blank cells in a range in Microsoft Excel
Delete Tip from MyTips Combining Text and Formatted Values
Delete Tip from MyTips Identifying Numeric Values within a Range Formatted as Text
Delete Tip from MyTips Deleting a Comment(s) in a Sheet in Excel 2007
Delete Tip from MyTips Using the Validation Input Message as a Cell Comment
Delete Tip from MyTips Rounding Numbers to Thousands
Delete Tip from MyTips Applying Colors to Subtotal Rows in Excel 2007
Delete Tip from MyTips Reduciendo el Área Utilizada en una Hoja
Delete Tip from MyTips Seleccionando una Columna(s) o Fila(s) Utilizando Métodos Abreviados
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Removing Redundant Characters from a Range of Cells and Resetting the Format
Delete Tip from MyTips Counting the Number of YES Responses in a Student Questionnaire
Delete Tip from MyTips Totaling Two Ranges Using the SUMIF Formula
Delete Tip from MyTips Create a Custom Function
Delete Tip from MyTips Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
Delete Tip from MyTips Summing Monthly Trial Balance Figures
Delete Tip from MyTips Add a cell, Row or a column in Microsoft Excel
Delete Tip from MyTips Retrieving Values from Different Sheets Using the Sheet Name as a Reference
Delete Tip from MyTips Format table depending on number formats using VBA in Microsoft Excel
Delete Tip from MyTips Performing Numeric Operations on Substrings
Delete Tip from MyTips Extract all the words except the first in Microsoft Excel
Delete Tip from MyTips Validating Text Entries in Excel 2007
Delete Tip from MyTips Applying Styles to Subtotal Rows
Delete Tip from MyTips Displaying Formula Syntax
Delete Tip from MyTips Count the number of cells in a range in Microsoft Excel
Delete Tip from MyTips Usando una Imagen para Ver Valores de Celda en Otras Hojas
Delete Tip from MyTips Disregarding blank cells when performing calculations on a range.
Delete Tip from MyTips Adding/Deleting Subtotals
Delete Tip from MyTips Changing the Default Number of Sheets in a New Workbook in Excel 2007
Delete Tip from MyTips Filtering by Data Type in Excel 2007
Delete Tip from MyTips Return text up to the second space in Microsoft Excel
Delete Tip from MyTips Problem: Values Not Formatting as Numbers
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Copying Formatting
Delete Tip from MyTips Compare two worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Use AutoCorrect to enter special symbols in Microsoft Excel
Delete Tip from MyTips Deleting Empty Rows
Delete Tip from MyTips Delete module content using VBA in Microsoft Excel
Delete Tip from MyTips Copy cells to all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Determining Whether a Worked Shift Was Morning, Afternoon or Night
Delete Tip from MyTips Range Name Syntax
Delete Tip from MyTips Displaying zero values in Microsoft Excel
Delete Tip from MyTips Automatically Defining Names for Ranges in Lists
Delete Tip from MyTips Seeing Calculation Results Immediately
Delete Tip from MyTips Combining Text from Different Cells
Delete Tip from MyTips Show the full name ( path and workbook name ) in the menu bar in Microsoft Excel
Delete Tip from MyTips Changing a Numeric Heading to Text
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Add page breaks to sorted data 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 Problem: Date Formatting Cannot Be Changed in Excel 2007
Delete Tip from MyTips Dividing an Amount into Equal Payments While Avoiding Division / Rounding Errors
Delete Tip from MyTips Conditonal Formatting using Microsoft Excel VBA
Delete Tip from MyTips The PivotTable Tools Ribbon in Excel 2007
Delete Tip from MyTips Calculating Absolute Difference between Two Time Values
Delete Tip from MyTips Comparing Lists
Delete Tip from MyTips Creating Progressively Incremented Counting Criteria
Delete Tip from MyTips Converting a Month's Serial Number into Its Corresponding Name
Delete Tip from MyTips Hiding Gridlines on the Screen and When Printing
Delete Tip from MyTips Conditional formatting depending on a cell comment using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
Delete Tip from MyTips Creating and Saving Custom Formatting Styles in Excel 2007
Delete Tip from MyTips Copy row heights and column widths using VBA in Microsoft Excel
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Use the format painter to copy column widths and row heights in Microsoft Excel
Delete Tip from MyTips Show/Hide Subtotals in Excel 2007
Delete Tip from MyTips Displaying the Workbook's Path in the Address Box
Delete Tip from MyTips Extract the first word in a cell in Microsoft Excel
Delete Tip from MyTips Array Formulas – the Technical Side
Delete Tip from MyTips Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates
Delete Tip from MyTips Summing Stock Lists
Delete Tip from MyTips Extending the Range of the SUM Formula
Delete Tip from MyTips Counting the Number of Combined First and Last Names Matching Criteria in a Dynamic Range
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Days, Months, Quarters, and Years
Delete Tip from MyTips Rounding Times Down to a Specified Time Increment
Delete Tip from MyTips Entering Times Quickly
Delete Tip from MyTips Adding Text Values Representing Time
Delete Tip from MyTips Finding the maximum value of all those meeting a certain criteria.
Delete Tip from MyTips Create a hyperlink from a string in Microsoft Excel
Delete Tip from MyTips Automatic Report formatting using option buttons
Delete Tip from MyTips Opening/Closing a Workbook(s) in Excel 2007
Delete Tip from MyTips Grouping the Date Field by Number of Days
Delete Tip from MyTips Averaging Sales Totals by Day of the Week
Delete Tip from MyTips Encoding a Sequence of Letters
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Calculating Total Time Worked on a
Delete Tip from MyTips Creating Date and Time Stamp
Delete Tip from MyTips Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
Delete Tip from MyTips Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
Delete Tip from MyTips Transposing Cells
Delete Tip from MyTips Creating PivotTable in Excel 2007
Delete Tip from MyTips Rounding Numerical Substrings
Delete Tip from MyTips Change the cursor appearance to hourglass using VBA in Microsoft Excel
Delete Tip from MyTips Removing Personal Information from a Workbook in Excel 2007
Delete Tip from MyTips Coloring Sheet Tabs
Delete Tip from MyTips Array Formulas in Excel 2007
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
Delete Tip from MyTips Grouping a Date Field by a Week Number in Excel 2007
Delete Tip from MyTips Grouping the Date Field by Number of Days in Excel 2007
Delete Tip from MyTips Quickly Selecting a Range in the Workbook
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips Creating a Timesheet
Delete Tip from MyTips Summing Values In a Range Specified By Indirect Cell References
Delete Tip from MyTips Find the minimum positive value in Microsoft Excel
Delete Tip from MyTips Calculating Canadian Mortgage Payments
Delete Tip from MyTips Summing the Visible Filtered List
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 Coloring Rows Based on Text Criteria
Delete Tip from MyTips Print the pages in reverse order using VBA in Microsoft Excel
Delete Tip from MyTips Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
Delete Tip from MyTips Copying/Moving a Sheet in Excel 2007
Delete Tip from MyTips Converting a Date into a String, Indicating the Quarter Number and Year
Delete Tip from MyTips Separating First and Last Names Without Using Formulas
Delete Tip from MyTips Show/Hide Grand Totals in Excel 2007
Delete Tip from MyTips Splitting a Full Address into Three Separate Cells
Delete Tip from MyTips Calculating Military Time Intervals
Delete Tip from MyTips Calculating the Average Difference between List Price and Sale Price
Delete Tip from MyTips Adding a Number to a Formatted Time Value
Delete Tip from MyTips Create an Amortization Schedule in Microsoft Excel
Delete Tip from MyTips Add content to a module from a file using VBA in Microsoft Excel
Delete Tip from MyTips Using a Workspace to Open a Number of Workbooks at Once
Delete Tip from MyTips Build an Excel Add-In in Microsoft Excel
Delete Tip from MyTips Auto-Recovering/ Auto-Saving a Workbook
Delete Tip from MyTips Additional Functions in AutoSum
Delete Tip from MyTips Copy a range of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Ignoring Blank Cells when Performing Calculations
Delete Tip from MyTips Formatting Cells Containing Formulas
Delete Tip from MyTips Calculating the Average of Every Nth Value
Delete Tip from MyTips Combining Text and a Formatted Date
Delete Tip from MyTips Making a Cell the First Cell in the Active Window
Delete Tip from MyTips Opening Workbooks from a List of Hyperlinks in Excel 2007
Delete Tip from MyTips PivotTable Report Terminology
Delete Tip from MyTips Print all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Inserting a picture (company logo) in the header in Microsoft Excel 2002 xp
Delete Tip from MyTips Displaying the Top/Bottom Number of Items
Delete Tip from MyTips Coloring Visible Rows in Filtered List in Excel 2007
Delete Tip from MyTips Viewing Selecting Data in a Sheet
Delete Tip from MyTips Automatically Refreshing a PivotTable Report in Excel 2007
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Indicating Due Payments, Based on the Current Date
Delete Tip from MyTips Moving Between Unprotected Cells in a Protected Sheet
Delete Tip from MyTips Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
Delete Tip from MyTips Changing the Standard Font
Delete Tip from MyTips Changing the Default Date Separator from a Slash to a Dot When Entering a Date into a Cell
Delete Tip from MyTips Displaying the Top/Bottom N Items in Excel 2007
Delete Tip from MyTips Filtering a List into Unique Records Using the COUNTIF Formula
Delete Tip from MyTips Count by color using VBA in Microsoft Excel
Delete Tip from MyTips Pivot Table - Grouping dates by weeks in Microsoft Excel
Delete Tip from MyTips Counting the Number of Players According to Their Score in a Particular Quarter
Delete Tip from MyTips Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
Delete Tip from MyTips Limiting the Movement in a Protected Sheet
Delete Tip from MyTips Copying Cell Content Across Sheets
Delete Tip from MyTips Retrieving File Name by Matching a Given Page Number in a Book
Delete Tip from MyTips Copy Selection to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Summing the Number of Hours an Employee Worked During a Two Week Period
Delete Tip from MyTips Adding Time Values
Delete Tip from MyTips Grouping the Date Field by Days, Months, Quarters, and Years in Excel 2007
Delete Tip from MyTips Altering the results returned by VLOOKUP.
Delete Tip from MyTips Changing the Font Size of the Sheet Name in Excel 2007
Delete Tip from MyTips Protecting Sheets / Cells in Microsoft Excel
Delete Tip from MyTips Counting how many times specific character appears in cell in Microsoft Excel
Delete Tip from MyTips Determining Whether a Person Worked a Full or Partial Shift
Delete Tip from MyTips Delete all macros in a workbook/document using VBA in Microsoft Excel
Delete Tip from MyTips Allowing Multiple Users to Edit Ranges in Microsoft Excel
Delete Tip from MyTips Copy a column or columns from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Copy a row or rows of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Handling Errors in Values & Empty cells in Excel 2007
Delete Tip from MyTips Sum the largest two numbers in range in Microsoft Excel
Delete Tip from MyTips Adding a Data Field That Calculates Percentages from One Item of the Row Field
Delete Tip from MyTips Copy the CurrentRegion of a cell of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Use Keyboard Shortcut to Open a Filter dropdown list in Excel 2007
Delete Tip from MyTips Changing the Default Number of Sheets in a New Workbook
Delete Tip from MyTips Printing a PivotTable Report in Excel 2007
Delete Tip from MyTips Vlookup Formula – Eliminating Errors
Delete Tip from MyTips Converting Older Dates to the Current Year
Delete Tip from MyTips Counting number of unique entries in a specified range.
Delete Tip from MyTips Delete a procedure from a module using VBA in Microsoft Excel
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Week Number
Delete Tip from MyTips Determining whether Two Given Dates Occur within the Same Week
Delete Tip from MyTips Copy from row till the last row with data into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Ranking Salespeople According To Sales Figure
Delete Tip from MyTips Set row height and column width in millimeters using VBA in Microsoft Excel
Delete Tip from MyTips Summing Using Text Characters as Criteria
Delete Tip from MyTips Summing data by selecting cells in Microsoft Excel
Delete Tip from MyTips Avoiding Errors when Using the And Function to Combine Multiple Conditions in Array Formulas
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003
Delete Tip from MyTips Merging and Centering with a Toggle Button in Excel 2002 and Excel 2003
Delete Tip from MyTips PivotTable report - Grouping Text Fields
Delete Tip from MyTips Summing Values from a List Containing Numerical and Textual Substrings
Delete Tip from MyTips Determining Which Quarter a Specified Date Corresponds With
Delete Tip from MyTips Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
Delete Tip from MyTips Protecting and Unprotecting Workbooks 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 Summing A Dynamic Range of Numbers According To Criteria
Delete Tip from MyTips Changing the Default Auto-Save File Location
Delete Tip from MyTips Convert time to a serial value in Microsoft Excel
Delete Tip from MyTips Adding Sub-Details to an Item
Delete Tip from MyTips Compare two worksheet ranges using VBA in Microsoft Excel
Delete Tip from MyTips Avoiding False Results when Counting Dates Matching Specified Criteria
Delete Tip from MyTips PDF2XL Enterprise
Delete Tip from MyTips Adding a Specified Number of Months to a Date
Delete Tip from MyTips Filtering by More Than Two Criteria in Excel 2007
Delete Tip from MyTips Show/Hide Expand Items Buttons in Excel 2007
Delete Tip from MyTips Increasing/Decreasing the Screen Magnification Percentage
Delete Tip from MyTips Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
Delete Tip from MyTips Copy a Range from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Inserting a Calculated Field in Excel 2007
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2000
Delete Tip from MyTips Calculating the Date of the Nth Specific Day of the Month
Delete Tip from MyTips Checking For Duplicate Values Within A Range
Delete Tip from MyTips Displaying Formulas and Values of the Same Cells
Delete Tip from MyTips Subtracting Times
Delete Tip from MyTips Adding a Calculated Percentage Field
Delete Tip from MyTips Hiding Outline Symbols
Delete Tip from MyTips PivotTable Styles in Excel 2007
Delete Tip from MyTips Eliminate screen flashing while running a macro using VBA in in Microsoft Excel
Delete Tip from MyTips Summing values in vertical and horizontal ranges in Microsoft Excel
Delete Tip from MyTips Filling a Range with a Series of Dates
Delete Tip from MyTips Formatting a Value Field in Excel 2007
Delete Tip from MyTips Find the maximum numerical value in a list based on a criteria in Microsoft Excel
Delete Tip from MyTips Create and Insert Additional PivotTable Reports Using the Same Data Source in Excel 2007
Delete Tip from MyTips Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
Delete Tip from MyTips Mail every Worksheet with address in cell A1 using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Full Path of the Saved File to the Header/Footer
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates the Difference Between Two Data Fields
Delete Tip from MyTips Calculating a Required Date According to Two Criteria
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 97
Delete Tip from MyTips Index Formula vs. Vlookup Formula
Delete Tip from MyTips Sort Ascending/Descending While Using Filter in Excel 2007
Delete Tip from MyTips Change text in header when printing using VBA in Microsoft Excel
Delete Tip from MyTips Copying or Moving a Sheet
Delete Tip from MyTips Summing data from a cell in a number of sheets in Microsoft Excel
Delete Tip from MyTips Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
Delete Tip from MyTips Find duplicates items in combine columns in Microsoft Excel
Delete Tip from MyTips Grouping Text Fields in Excel 2007
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel 2007
Delete Tip from MyTips Rounding Time Intervals to the Nearest Specified Time Increment
Delete Tip from MyTips Finding the Last Day of a Given Month
Delete Tip from MyTips Converting Times to Decimal Values
Delete Tip from MyTips Adding Additional Functions to Subtotals
Delete Tip from MyTips Calculating the Quarter Number for Calendar and Fiscal Year
Delete Tip from MyTips Coloring Gridlines
Delete Tip from MyTips Select bottom right end corner of the used area Microsoft Excel
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet
Delete Tip from MyTips Saving Filtering Criteria
Delete Tip from MyTips Checking for the Presence of Specified Values Within a Range
Delete Tip from MyTips Calculating Number of Days, Weeks, Months and Years between Dates
Delete Tip from MyTips Fast Typing in Selected Area
Delete Tip from MyTips Reversing The Order Of Values In A List
Delete Tip from MyTips Sorting by Columns
Delete Tip from MyTips Converting a Decimal Value to a Time Value
Delete Tip from MyTips Change a Column or Columns to values using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
Delete Tip from MyTips Mail one Sheet using VBA in Microsoft Excel
Delete Tip from MyTips Filtering a Range into a List of Unique Records
Delete Tip from MyTips Extract the first, middle and last name in Microsoft Excel
Delete Tip from MyTips Extract the last word in a cell in Microsoft Excel
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
  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