|  

» 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 Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side
Delete Tip from MyTips Create new workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Add content to a module from a file using VBA in Microsoft Excel
Delete Tip from MyTips Copying a Cell Comment
Delete Tip from MyTips Calculating the Average of a Range of Numbers, Excluding the Minimal Value
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout
Delete Tip from MyTips The SUMIF Formula – Using Comparison Operators ( ) as Criteria
Delete Tip from MyTips Comparing Three or More Lists in Microsoft Excel
Delete Tip from MyTips Access ThisWorkbook module directly from Excel
Delete Tip from MyTips Selecting cells that only contain Text in Microsoft Excel
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Coloring Rows Based on Text Criteria
Delete Tip from MyTips Private Profile Strings using the Registry using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Custom Keyboard Shortcut
Delete Tip from MyTips Entering Times Quickly
Delete Tip from MyTips Compare two worksheet ranges using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
Delete Tip from MyTips Calculating Differences Between Dates
Delete Tip from MyTips Copy a range with more Areas to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Pasting Values in Excel 2007
Delete Tip from MyTips Creating a PivotTable Report
Delete Tip from MyTips Use the continuous page numbers technique in Report Manager in Microsoft Excel.
Delete Tip from MyTips Printing an Already Saved Report Using Report Manager
Delete Tip from MyTips Entering the Current Time into a Cell
Delete Tip from MyTips Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Delete Tip from MyTips Find if a character is in a cell in Microsoft Excel
Delete Tip from MyTips Adding Euro format to the number format in Microsoft Excel
Delete Tip from MyTips Sorting Numbers in Ascending or Descending Order
Delete Tip from MyTips Access the Private module of a Worksheet Object while in Excel
Delete Tip from MyTips Reversing Strings
Delete Tip from MyTips Retrieving the Entire Row of a Matched Value
Delete Tip from MyTips Mail Sheet Array using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Unique Items Sold by Each Salesperson
Delete Tip from MyTips Select filenames using VBA in Microsoft Excel
Delete Tip from MyTips Creating Date and Time Stamp
Delete Tip from MyTips Coloring Sheet Tabs
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates the Difference from the Previous Item
Delete Tip from MyTips Insert or delete a Row/Column in Microsoft Excel
Delete Tip from MyTips Printing a PivotTable Report
Delete Tip from MyTips Inserting a Watermark Behind the Text
Delete Tip from MyTips Adding a Picture to a Header/Footer in Excel 2007
Delete Tip from MyTips Summing Rounded Numbers
Delete Tip from MyTips Determine the screen size using VBA in Microsoft Excel
Delete Tip from MyTips Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007
Delete Tip from MyTips PDF2XL and PDF2XL OCR
Delete Tip from MyTips Preventing Moving to the Next Cell After Typing
Delete Tip from MyTips Use listboxes with multiple choices using VBA in Microsoft Excel
Delete Tip from MyTips Insert a new module from a file using VBA in Microsoft Excel
Delete Tip from MyTips Delete all macros in a workbook/document using VBA in Microsoft Excel
Delete Tip from MyTips Dividing a First Left Heading Title
Delete Tip from MyTips Summing Stock Lists in Excel 2007
Delete Tip from MyTips Restricting the Number of Characters Entered into a Cell
Delete Tip from MyTips Copying a Formula from a Cell While Keeping the Absolute Reference or Relative Reference
Delete Tip from MyTips Changing an Absolute Reference to a Relative Reference or Vice Versa
Delete Tip from MyTips Summing Across Multiple Sheets
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria Using Conditional Formatting
Delete Tip from MyTips Deleting the Word "Total" from the subtotal List
Delete Tip from MyTips Retrieving the Column Header that Corresponds with a Matched Value
Delete Tip from MyTips Entering Dates Quickly
Delete Tip from MyTips Dividing an Amount into Equal Payments While Avoiding Division / Rounding Errors
Delete Tip from MyTips Extract the first, middle and last name in Microsoft Excel
Delete Tip from MyTips Inserting Special Symbols into Custom Formats
Delete Tip from MyTips Changing the Default Auto-Save File Location
Delete Tip from MyTips Counting values meeting multiple criteria in different columns.
Delete Tip from MyTips Retrieving the Value of the First Nonblank Cell in a List
Delete Tip from MyTips Class modules using VBA in Microsoft Excel
Delete Tip from MyTips Parsing text to the right of a search criteria - delimiter in Microsoft Excel
Delete Tip from MyTips Change the default printer using VBA in Microsoft Excel
Delete Tip from MyTips Adding Additional Functions to Subtotals
Delete Tip from MyTips Calculating the Date at the End of a Month
Delete Tip from MyTips Counting the Number of Times a Specified Substring Appears within a Range of Strings
Delete Tip from MyTips Replace text in a text file using VBA in Microsoft Excel
Delete Tip from MyTips Iteration
Delete Tip from MyTips Summing Monthly Trial Balance Figures
Delete Tip from MyTips Add and Save new Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Protecting and Unprotecting Workbooks in Microsoft Excel
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Defining Names for Ranges in Lists
Delete Tip from MyTips Copying, Cutting and Pasting (Moving)
Delete Tip from MyTips Copy a range of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips The Power Combination
Delete Tip from MyTips Rearranging a String in Alphabetic Order
Delete Tip from MyTips Calculating a Building's Occupancy Rate at Specified Times
Delete Tip from MyTips Transposing Cells in Excel 2007
Delete Tip from MyTips How to extract a file name from a path in Microsoft Excel
Delete Tip from MyTips Opening a saved Workbook in Microsoft Excel
Delete Tip from MyTips Determining Whether a Worked Shift Was Morning, Afternoon or Night
Delete Tip from MyTips Identifying the Case of Letters within Strings
Delete Tip from MyTips Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
Delete Tip from MyTips Restricting the Automatic Recalculation of Volatile Functions
Delete Tip from MyTips Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
Delete Tip from MyTips List files in a folder with Office 97 or later using VBA in Microsoft Excel
Delete Tip from MyTips Expanded Paste Icon Features in Excel 2002 & Excel 2003
Delete Tip from MyTips Reset filter before saving a worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Preventing Duplicates While Entering Data in Excel 2007
Delete Tip from MyTips Formulas Erroneously Appearing as Text
Delete Tip from MyTips Copying/Moving a Cell(s) Between Sheets/Workbooks
Delete Tip from MyTips Summing Values from Different Sheets for the Same Cell Address
Delete Tip from MyTips Formatting a PivotTable Report
Delete Tip from MyTips Changing the Source Link
Delete Tip from MyTips Deleting a Range Name in Excel 2007
Delete Tip from MyTips Converting a Julian Date to a Calendar Date
Delete Tip from MyTips Finding the First Login and Last Logout Times of Employees
Delete Tip from MyTips Creating a World Time Converter
Delete Tip from MyTips Performing calculations based on multiple criteria, using SUMPRODUCT function
Delete Tip from MyTips Insert New Sheet in Excel 2007
Delete Tip from MyTips Using the Validation Input Message as a Cell Comment in Excel 2007
Delete Tip from MyTips Change font color based on Date 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 Put a line at Foot of print page
Delete Tip from MyTips Seeing Calculation Results Immediately
Delete Tip from MyTips Autoexpanding a Date Type Chart using Microsoft Excel
Delete Tip from MyTips Change the state of a custom CommandBar button using VBA in Microsoft Excel
Delete Tip from MyTips New AVERAGE Functions in Excel 2007
Delete Tip from MyTips Prevent a UserForm from closing when the user clicks the x-button using VBA in Microsoft Excel
Delete Tip from MyTips Using Financial Functions
Delete Tip from MyTips Problem: The Characters Are in Reverse Order
Delete Tip from MyTips Sorting Numbers Based on Their Frequency within a List
Delete Tip from MyTips Adding a Linked Picture to a Chart in Microsoft Excel
Delete Tip from MyTips Close a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Use messageboxes using VBA in Microsoft Excel
Delete Tip from MyTips Using Date & Time Criteria to Count Entries in a Combined Date & Time List
Delete Tip from MyTips Applying Colors to Subtotal Rows in Excel 2007
Delete Tip from MyTips Filtering a Range into a List of Unique Records
Delete Tip from MyTips Changing the Source Link in Excel 2007
Delete Tip from MyTips Removing Personal Information from a Workbook in Excel 2007
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Consolidating Lists While Adding Links to the Source Data
Delete Tip from MyTips Averaging Sales Totals by Day of the Week
Delete Tip from MyTips Hiding Gridlines on the Screen and When Printing in Excel 2007
Delete Tip from MyTips Combining Text and Numerically Calculated Results into One Output String
Delete Tip from MyTips Adding icons (boxes) to the menu bar in Microsoft Excel
Delete Tip from MyTips Drawing Lines between Sorted Groups in Excel 2007
Delete Tip from MyTips Summing Sales Amounts According to Product Category and Customer Name
Delete Tip from MyTips Deleting a Comment(s) in a Sheet in Excel 2007
Delete Tip from MyTips Quickly Removing Subtotals in Excel 2007
Delete Tip from MyTips Copying and Pasting Validation list only in Microsoft Excel
Delete Tip from MyTips Viendo Datos Seleccionados en una Hoja
Delete Tip from MyTips Calculating Total Time Worked on a Specific Day
Delete Tip from MyTips Quickly Removing Subtotals
Delete Tip from MyTips Opening a template file automatically upon starting Microsoft Excel
Delete Tip from MyTips Add unique values using VBA in Microsoft Excel
Delete Tip from MyTips Reversing The Order Of Values In A List
Delete Tip from MyTips Showing/Hiding Only Selected Items in Excel 2007
Delete Tip from MyTips Prevent entry of invalid values using VBA in Microsoft Excel
Delete Tip from MyTips Filtering by More Than Two Criteria in Excel 2007
Delete Tip from MyTips Determining Which Quarter a Specified Date Corresponds With
Delete Tip from MyTips Displaying the Format Cells Dialog Box in Excel 2007
Delete Tip from MyTips Calculating the Average for Numbers Meeting Specified Criteria
Delete Tip from MyTips Updating Charts by Dragging and Dropping in Microsoft Excel
Delete Tip from MyTips Counting the Number of Values from Multiple Worksheets that Match Criteria
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Automating the Insertion of the Euro Symbol
Delete Tip from MyTips Adding the full path of the saved file to headers and footers in Microsoft Excel 2002 xp
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Protecting Workbooks with a Digital Signature in Excel 2007
Delete Tip from MyTips Change the cell formatted from date format to number format in Microsoft Excel
Delete Tip from MyTips Create and Add a Function for Reversed Text Characters in Microsoft Excel
Delete Tip from MyTips Vlookup Formula – Organizing the Data Table
Delete Tip from MyTips Applying Colors to Maximum/Minimum Values in a List
Delete Tip from MyTips Saving Filtering Criteria
Delete Tip from MyTips Opening a Linked Workbook in Microsoft Excel
Delete Tip from MyTips Change slash separator in date with period in Microsoft Excel
Delete Tip from MyTips Extract all the words except the first in Microsoft Excel
Delete Tip from MyTips Convert text to lower case in Microsoft Excel
Delete Tip from MyTips Printing a Chart in Microsoft Excel
Delete Tip from MyTips Calculate number of minutes between dates - time in Microsoft Excel
Delete Tip from MyTips Shortcuts to see the Help for the Syntax Function in Microsoft Excel
Delete Tip from MyTips Counting how many times specific character appears in cell in Microsoft Excel
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Summing Values in a Range Containing Redundant Spaces
Delete Tip from MyTips Count the number of words in a cell in Microsoft Excel
Delete Tip from MyTips Preventing charts from being printed in Microsoft Excel
Delete Tip from MyTips Extract the first word in a cell in Microsoft Excel
Delete Tip from MyTips Displaying the Serial Number Behind the Time
Delete Tip from MyTips Shortcuts for opening the Function Arguments window in Microsoft Excel
Delete Tip from MyTips Combine the VLookup and Match formulas in Microsoft Excel
Delete Tip from MyTips Creating Charts with F11 in Microsoft Excel
Delete Tip from MyTips Extract the last word in a cell in Microsoft Excel
Delete Tip from MyTips Use Smart Tag to fill series of dates in Microsoft Excel
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
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 Selecting a Range of Non-Adjacent Cells
Delete Tip from MyTips Selecting a row or rows in Microsoft Excel
Delete Tip from MyTips Combining the Contents of Every N Number of Cells into One Value
Delete Tip from MyTips Using Loops in VBA 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 Using the Keyboard to Select Chart Items in Microsoft Excel
Delete Tip from MyTips Insert pictures using VBA in Microsoft Excel
Delete Tip from MyTips Sum the digits numbers in a cell using custom VBA function in Microsoft Excel
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in All Sheets
Delete Tip from MyTips Log files using VBA in Microsoft Excel
Delete Tip from MyTips Excel 2003 Resources on the Web
Delete Tip from MyTips Adding the Camera icon to the toolbar in Microsoft Excel
Delete Tip from MyTips Selecting All Sheet Cells
Delete Tip from MyTips Altering results returned in case of an error.
Delete Tip from MyTips Printing page number in the opposite direction in landscape layout page in Microsoft Excel
Delete Tip from MyTips Unprinted blank pages in Microsoft Excel 2002
Delete Tip from MyTips Problem: The Minus Sign Appears to the Right of the Number
Delete Tip from MyTips Worksheet functions in VBA macros using VBA in Microsoft Excel
Delete Tip from MyTips Pasting Multiple Copied Ranges Using the Clipboard
Delete Tip from MyTips Moving Between Precedent and Dependent Cells
Delete Tip from MyTips Splitting a Full Address into Three Separate Cells
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 97
Delete Tip from MyTips Copy worksheet information to Word 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 Find duplicates items in combine columns in Microsoft Excel
Delete Tip from MyTips Moving to the Last (or First) Cell in a Range
Delete Tip from MyTips Adding a Combo Box
Delete Tip from MyTips Avoiding Problems when Numeric Values are used as Text
Delete Tip from MyTips Displaying the Serial Number Behind the Date
Delete Tip from MyTips Moving Between Open Workbooks
Delete Tip from MyTips Calculating the Week Number
Delete Tip from MyTips Selecting Special Cells
Delete Tip from MyTips Linking a Cell to a Text Box
Delete Tip from MyTips Quickly Typing Dates into Cells
Delete Tip from MyTips Removing the Smart Tag Indicator
Delete Tip from MyTips Adding non-contiguous ranges to a single contiguous range for printing in Microsoft Excel
Delete Tip from MyTips Combine the Index and Match formulas 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 Select bottom right end corner of the used area Microsoft Excel
Delete Tip from MyTips Set the Background Color according to the date using VBA in Microsoft Excel
Delete Tip from MyTips Combining Numbers that Have Leading Zeros
Delete Tip from MyTips Manually Wrapping Text in a Cell
Delete Tip from MyTips Using VLOOKUP and ISNA functions to find matching values in different sheets
  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