|  

» 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 List files in a folder with Office 97 or later using VBA in Microsoft Excel
Delete Tip from MyTips Mail one Sheet using VBA in Microsoft Excel
Delete Tip from MyTips Finding Minimum / Maximum Values
Delete Tip from MyTips Customizing an Icon
Delete Tip from MyTips How Excel Sorts Lists
Delete Tip from MyTips Combining Text and a Formatted Date
Delete Tip from MyTips Count how many numbers are in series of numbers when a certain criteria is set in Microsoft Excel
Delete Tip from MyTips Removing Icons Performing Two Different Tasks
Delete Tip from MyTips Create new workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Calculate number of minutes between dates - time in Microsoft Excel
Delete Tip from MyTips How to change column number with letter in Microsoft Excel
Delete Tip from MyTips Using multiple criteria in SUMIF Function
Delete Tip from MyTips Summing Using Text Characters as Criteria
Delete Tip from MyTips List all fonts available in Excel using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Values from another Excel Workbook Using Text References
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips Summing from Closed Workbooks
Delete Tip from MyTips Get the Row number of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Removing Redundant Characters from a Range of Cells and Resetting the Format
Delete Tip from MyTips Formulas to calculate Loan payments in Microsoft Excel
Delete Tip from MyTips Sum total stock value for any part in Microsoft Excel
Delete Tip from MyTips Use Name in a Formula in Excel 2007
Delete Tip from MyTips Prevent entry of invalid values 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 Customizing Date Formatting in Excel 2007
Delete Tip from MyTips Determining Which Quarter a Specified Date Corresponds With
Delete Tip from MyTips Add a fancy line for Presentation
Delete Tip from MyTips Change the value/content of several UserForm-controls using VBA in Microsoft Excel
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Convert time to a serial value in Microsoft Excel
Delete Tip from MyTips Consolidating Lists
Delete Tip from MyTips Using a Workspace to Open a Number of Workbooks at Once in Excel 2007
Delete Tip from MyTips Defining a Range Name in Excel 2007
Delete Tip from MyTips Converting Times to Decimal Values
Delete Tip from MyTips Retrieving List Values that Do Not Appear in a Second List
Delete Tip from MyTips Shuffling a List of Values
Delete Tip from MyTips Reducing the Workbook Size for Quick Sending via E Mail
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout
Delete Tip from MyTips Calculating the Quarter Number for Calendar and Fiscal Year
Delete Tip from MyTips Preventing Duplicates While Entering Data
Delete Tip from MyTips Protecting Sheets / Cells in Microsoft Excel
Delete Tip from MyTips Summing Across Multiple Sheets
Delete Tip from MyTips Adding the Path Address to the Header/Footer
Delete Tip from MyTips Creating Date and Time Stamp
Delete Tip from MyTips Quickly Selecting a Range of Cells
Delete Tip from MyTips Fast Copying & Pasting in Adjacent Cells
Delete Tip from MyTips Index Formula vs. Vlookup Formula
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria
Delete Tip from MyTips Count the number of cells in a range containing all types of Errors in Microsoft Excel
Delete Tip from MyTips Adding Groups and Outlines Manually
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
Delete Tip from MyTips Grouping the Date Field by Number of Days in Excel 2007
Delete Tip from MyTips Simplifying Formulas by Defining Names for Often-Repeated Parts
Delete Tip from MyTips Adding, Subtracting, Multiplying and Dividing Without Using Formulas
Delete Tip from MyTips Display all installed fonts (Excel) using VBA in Microsoft Excel
Delete Tip from MyTips Add special symbols to the number format
Delete Tip from MyTips Count the number of times dates in certain month appears in range in Microsoft Excel
Delete Tip from MyTips Use a closed workbook as a database (ADO) 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 Opening a Copy of an Existing Workbook
Delete Tip from MyTips Calculating Differences Between Dates
Delete Tip from MyTips Saving a Frequently Used Formula/Numeric Value in the Define Name Dialog Box
Delete Tip from MyTips Adding Euro format to the number format in Microsoft Excel
Delete Tip from MyTips Summing Values Based on Text Criteria
Delete Tip from MyTips Calculating the Number of Weekday Hours Between Two Dates
Delete Tip from MyTips Copying or Applying Color to Groups and Outlines
Delete Tip from MyTips Displaying Formulas and Values of the Same Cells in Excel 2007
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Creating a Timesheet
Delete Tip from MyTips Counting the Number of Excel Files in a List According to File Type and Date Criteria
Delete Tip from MyTips Selecting Cells from Any Cell to the Last Cell in the Sheet's Used Range
Delete Tip from MyTips Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel
Delete Tip from MyTips What's New in Excel 2002/2003: Menu, Cell Shortcut Menu and Keyboard Shortcuts
Delete Tip from MyTips Expanded Paste Icon Features in Excel 2002 & Excel 2003
Delete Tip from MyTips Summing values in vertical and horizontal ranges in Microsoft Excel
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Extracting Characters from Text Using Text Formulas
Delete Tip from MyTips Delete a procedure from a module 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 Using the Round Function to Round Numbers to Thousands
Delete Tip from MyTips Changing the Default Number of Sheets in a New Workbook in Excel 2007
Delete Tip from MyTips Rounding Numbers that Meet Specified Criteria
Delete Tip from MyTips Previniendo el Desborde de Texto
Delete Tip from MyTips Ranking a List of Numbers
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Rounding Prices to the Nearest Nickel, Dime, Quarter and Dollar
Delete Tip from MyTips Hiding Gridlines on the Screen and When Printing in Excel 2007
Delete Tip from MyTips Retrieving Values from Different Sheets Using the Sheet Name as a Reference
Delete Tip from MyTips Protecting and Unprotecting Workbooks in Microsoft Excel
Delete Tip from MyTips Saving a Customized Workbook as a Template
Delete Tip from MyTips Change the availability for the shortcut menus using VBA in Microsoft Excel
Delete Tip from MyTips Linking a Cell to a Text Box
Delete Tip from MyTips Finding the maximum value of all those meeting a certain criteria.
Delete Tip from MyTips Print all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Average for Numbers Meeting Specified Criteria
Delete Tip from MyTips Launch Word file from Excel VBA
Delete Tip from MyTips Viewing Selecting Data in a Sheet
Delete Tip from MyTips Fast Copying & Pasting Right or Down in a List
Delete Tip from MyTips Find the maximum numerical value in a list based on a criteria in Microsoft Excel
Delete Tip from MyTips Format even numbers
Delete Tip from MyTips Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Sum by color using VBA in Microsoft Excel
Delete Tip from MyTips Printing page number in the opposite direction in landscape layout page in Microsoft Excel
Delete Tip from MyTips Creating and Saving Custom Formatting Styles in Excel 2007
Delete Tip from MyTips Copying Cell Content Across Sheets
Delete Tip from MyTips Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Log files using VBA in Microsoft Excel
Delete Tip from MyTips Conditional formatting depending on a cell comment using VBA in Microsoft Excel
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 Getting Drill-Down Details in Excel 2007
Delete Tip from MyTips Adding the Subtotals Icon to the Menu Bar
Delete Tip from MyTips Retrieving Values that are Common to Two Lists
Delete Tip from MyTips Returning the Entire Contents of the Row Containing the Highest Math Grade
Delete Tip from MyTips Retrieve the Distance between Any Two Cities from Distance Table
Delete Tip from MyTips Validating Text Entries
Delete Tip from MyTips Grouping the Date Field by Days, Months, Quarters, and Years in Excel 2007
Delete Tip from MyTips Formatting a Value Field in Excel 2007
Delete Tip from MyTips Change the state of a custom CommandBar button using VBA in Microsoft Excel
Delete Tip from MyTips Shortcuts to see the Help for the Syntax Function in Microsoft Excel
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Copy a range with more Areas to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the Serial Number Behind the Date
Delete Tip from MyTips Dividing a First Left Heading Title
Delete Tip from MyTips Tracing Errors in Formula Results
Delete Tip from MyTips Create and Add a Function for Reversed Text Characters in Microsoft Excel
Delete Tip from MyTips Pass arguments to macros from buttons and menus using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Source Link
Delete Tip from MyTips Copy row heights and column widths using VBA in Microsoft Excel
Delete Tip from MyTips Copy the UsedRange of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Preventing Text from Spilling Over
Delete Tip from MyTips Automatically Defining Names for Ranges in Lists
Delete Tip from MyTips Access ThisWorkbook module directly from Excel
Delete Tip from MyTips Shortcuts for opening the Function Arguments window in Microsoft Excel
Delete Tip from MyTips Copy a Row or Rows to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Counting Unique Numeric Values or Unique Data in a List
Delete Tip from MyTips Coloreando un Registro en Cada Grupo en un Rango
Delete Tip from MyTips Selecting Cells That Contain Errors in Formulas in Excel 2007
Delete Tip from MyTips Coloring Rows Based on Text Criteria
Delete Tip from MyTips Transposing Cells
Delete Tip from MyTips Converting Units
Delete Tip from MyTips Combining Text from Different Cells
Delete Tip from MyTips Using the Validation Input Message as a Cell Comment
Delete Tip from MyTips Restricting Cell Entries to Text Only
Delete Tip from MyTips Copy cells from the ActiveCell Row to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Redondeando Números a Millones con Miles como Decimal
Delete Tip from MyTips Create User Forms in Microsoft Excel
Delete Tip from MyTips Displaying the Serial Number Behind the Time
Delete Tip from MyTips Import data from Access to Excel (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Replacing Substrings with Numbers from Adjacent Cells
Delete Tip from MyTips Joining text using formula in Microsoft Excel
Delete Tip from MyTips Changing the Default Number of Sheets in a New Workbook
Delete Tip from MyTips Calculating the Average Value in Every Nth Column, Excluding Zeros
Delete Tip from MyTips Using Different Functions to Consolidate Lists
Delete Tip from MyTips Compare two worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Rounding the Calculation of Retail Price and Sales Tax
Delete Tip from MyTips Counting the Number of Dates with Matching Month Criteria
Delete Tip from MyTips Sum the largest two numbers in range in Microsoft Excel
Delete Tip from MyTips Entering Formulas More Quickly by Shortening Sheet Names
Delete Tip from MyTips Inserting Subtotals Quickly
Delete Tip from MyTips Add unique values using VBA 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 Summing Numerical Substrings
Delete Tip from MyTips Insert a new module from a file using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Values from Multiple Worksheets that Match Criteria
Delete Tip from MyTips Convert negative values treated as text using VBA in Microsoft Excel
Delete Tip from MyTips Determining Whether a Person Worked a Full or Partial Shift
Delete Tip from MyTips Quick Move to end of range of cells in Microsoft Excel
Delete Tip from MyTips Extending the Range of the SUM Formula
Delete Tip from MyTips Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel
Delete Tip from MyTips Hide/Unhide a Sheet in Excel 2007
Delete Tip from MyTips Searching for text in Microsoft Excel
Delete Tip from MyTips Converting Uppercase Letters to Lowercase
Delete Tip from MyTips Deje que Excel lea el texto por usted
Delete Tip from MyTips The PivotTable Tools Ribbon in Excel 2007
Delete Tip from MyTips Summing Values in a Range Containing Redundant Spaces
Delete Tip from MyTips Hiding/Unhiding a Row(s) or Column(s)
  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. Retrieving Values Using Range Names as References
  5. Copy Selection to a Database sheet using VBA in Microsoft Excel
  6. Create User Forms in Microsoft Excel
  7. Writing Your First VBA Function in Excel
  8. Replace text in a text file using VBA in Microsoft Excel
  9. Using Loops in VBA in Microsoft Excel
  10. Add Combo Box to a Sheet in Microsoft Excel
  11. Formulas to calculate Loan payments in Microsoft Excel
  12. Turn off warning messages using VBA in Microsoft Excel
  13. Summing Rounded Numbers
  14. Adding the Page Setup Icon to the Excel Menu Bar
  15. Calculating the Number of Business Days in a Specified Period
  16. Rounding Hours Up
  17. Find duplicates items in combine columns in Microsoft Excel
  18. Create an Amortization Schedule in Microsoft Excel
  19. Summing Stock Lists
  20. Working Out a Person's Age in Microsoft Excel



Excel 2007 Tutorials

SEO

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