|  

» 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 Combine the VLookup and Match formulas in Microsoft Excel
Delete Tip from MyTips Add a fancy line for Presentation
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Quarters in a Fiscal Reporting Year
Delete Tip from MyTips Preventing charts from being printed 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 Replacing Data Markers with Pictures in Microsoft Excel
Delete Tip from MyTips Preventing Duplicates While Entering Data
Delete Tip from MyTips Row and column background color using VBA in Microsoft Excel
Delete Tip from MyTips An Improved Custom Random Numbers Function
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Use AutoCorrect to enter special symbols in Microsoft Excel
Delete Tip from MyTips Changing an Absolute Reference to a Relative Reference or Vice Versa
Delete Tip from MyTips Making a Cell the First Cell in the Active Window
Delete Tip from MyTips Sizing Charts with the Window in Microsoft Excel.
Delete Tip from MyTips Consolidating Lists in Excel 2007
Delete Tip from MyTips Insert or delete a Row/Column 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 Retrieving Values Using References Based on Row and Column Numbers
Delete Tip from MyTips Creating a Counting Grid
Delete Tip from MyTips Add space between characters and numbers in Microsoft Excel
Delete Tip from MyTips Hiding Data Before Printing
Delete Tip from MyTips Compare two worksheet ranges using VBA in Microsoft Excel
Delete Tip from MyTips Selecting Cells That Contain Errors in Formulas in Excel 2007
Delete Tip from MyTips Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
Delete Tip from MyTips Consolidating Lists
Delete Tip from MyTips Counting Based on Multiple Criteria
Delete Tip from MyTips Determine the type of operating system using VBA in Microsoft Excel
Delete Tip from MyTips Saving Defined Page Setups for Future Printing
Delete Tip from MyTips Quickly Printing a Page from the Workbook Using a Custom View
Delete Tip from MyTips Quickly Selecting a Range in the Workbook
Delete Tip from MyTips Preventing the Printing of Objects
Delete Tip from MyTips Convert text to lower case in Microsoft Excel
Delete Tip from MyTips Changing the Cell Formatting from Date to Number
Delete Tip from MyTips Copy row heights and column widths using VBA in Microsoft Excel
Delete Tip from MyTips Hiding Subtotal Level Buttons
Delete Tip from MyTips Find duplicates items in combine columns in Microsoft Excel
Delete Tip from MyTips Add values from the previous or next worksheet using VBA in Microsoft Excel
Delete Tip from MyTips How to find the minimum value in range while ignoring 0 value in Microsoft Excel
Delete Tip from MyTips Grouping/ Ungrouping Sheets
Delete Tip from MyTips Finding the Number of Days in a Given Month
Delete Tip from MyTips Counting Unique Numeric Values or Unique Data in a List
Delete Tip from MyTips Print all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Creating a PivotTable Report
Delete Tip from MyTips Access ThisWorkbook module directly from Excel
Delete Tip from MyTips Reducing the Used Area in a Sheet
Delete Tip from MyTips Calculating Total Income Tax
Delete Tip from MyTips Applying Styles to Subtotal Rows
Delete Tip from MyTips Extract the first word in a cell in Microsoft Excel
Delete Tip from MyTips Entering the Current Time into a Cell
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in All Sheets
Delete Tip from MyTips Use Name in a Formula in Excel 2007
Delete Tip from MyTips Copiando, Cortando y Pegando (Mover)
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips Avoiding Errors when Counting Date Values that Meet Specified Criteria
Delete Tip from MyTips Coloring Two Subtotal Levels in Different Colors
Delete Tip from MyTips Control Outlook from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Merge cells without loosing values using VBA in Microsoft Excel
Delete Tip from MyTips Find the value in the first non blank cell in range in Microsoft Excel
Delete Tip from MyTips Searching for text in Microsoft Excel
Delete Tip from MyTips Using the Validation Input Message as a Cell Comment
Delete Tip from MyTips Summing data by selecting cells in Microsoft Excel
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page
Delete Tip from MyTips Adding the Page Setup Icon to the Excel Menu Bar
Delete Tip from MyTips Expanded Paste Icon Features in Excel 2002 & Excel 2003
Delete Tip from MyTips Ajustando Manualmente el Texto en una Celda
Delete Tip from MyTips Selecting All Sheet Cells
Delete Tip from MyTips Coloring and Filtering Lists According to Criteria
Delete Tip from MyTips Automatically Wrapping Text in a Cell in Excel 2007
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Count the number of cells in a range containing all types of Errors in Microsoft Excel
Delete Tip from MyTips Private Profile Strings using the Registry using VBA in Microsoft Excel
Delete Tip from MyTips Combine column text and replace using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Values from another Excel Workbook Using Text References
Delete Tip from MyTips Printing in Excel 2007
Delete Tip from MyTips Copy worksheet information to Word using VBA in Microsoft Excel
Delete Tip from MyTips Quick Filtering Using the AutoFilter Icon
Delete Tip from MyTips Validation list without empty cells using VBA in Microsoft Excel
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 How Excel Sorts Lists
Delete Tip from MyTips Return every n-th item using VBA in Microsoft Excel
Delete Tip from MyTips Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
Delete Tip from MyTips Summing A Dynamic Range of Numbers According To Criteria
Delete Tip from MyTips Problem: The Minus Sign Appears to the Right of the Number
Delete Tip from MyTips Turn off warning messages using VBA in Microsoft Excel
Delete Tip from MyTips Extract the first, middle and last name in Microsoft Excel
Delete Tip from MyTips Adding the Custom Views Icon to the Excel Menu Bar
Delete Tip from MyTips Edit the tooltip for toolbarbuttons using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Difference Between Hours
Delete Tip from MyTips To Fill Values Right or Down in a List in Excel 2007
Delete Tip from MyTips Copying or Applying Color to Groups and Outlines in Excel 2007
Delete Tip from MyTips Counting the Number of Values between Two Specified Values in a List
Delete Tip from MyTips Using Task Panes
Delete Tip from MyTips Calculating the Absolute Difference between Each List Value and the Minimum Value in the List
Delete Tip from MyTips Increasing/Decreasing the Screen Magnification Percentage
Delete Tip from MyTips Copy a Range from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Hiding Cells before Printing in Excel 2007
Delete Tip from MyTips Delete all macros in a workbook/document using VBA in Microsoft Excel
Delete Tip from MyTips Random Selection from a List
Delete Tip from MyTips Calculating the Average of Every Nth Value, Excluding Zeros
Delete Tip from MyTips Determine if a cell is within a range using VBA in Microsoft Excel
Delete Tip from MyTips Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters
Delete Tip from MyTips Weeknumbers using VBA in Microsoft Excel
Delete Tip from MyTips Change font color based on Date using VBA in Microsoft Excel
Delete Tip from MyTips Viewing Selecting Data in a Sheet
Delete Tip from MyTips Retrieving the Minimal / Maximal Values from a Filtered List
Delete Tip from MyTips Find the minimum numerical value in a list based on a criteria in Microsoft Excel
Delete Tip from MyTips Ranking Salespeople According To Sales Figure
Delete Tip from MyTips Checking for Duplicate Values within a Range
Delete Tip from MyTips Change range with more then Area to values using VBA in Microsoft Excel
Delete Tip from MyTips Quickly Creating Links between Workbooks in Excel 2007
Delete Tip from MyTips Converting Time to Decimal Values
Delete Tip from MyTips Show the time in the Format hh:mm:000 using VBA
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria Using Conditional Formatting
Delete Tip from MyTips Coloring Even Numbered Rows in a List
Delete Tip from MyTips Retrieving the Player Who Scored the Highest Number of Points
Delete Tip from MyTips Generate total for dynamic area using VBA in Microsoft Excel
Delete Tip from MyTips Compare two worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the Format Cells Dialog Box
Delete Tip from MyTips Protecting and Unprotecting Workbooks in Microsoft Excel
Delete Tip from MyTips Counting how many times specific character appears in cell in Microsoft Excel
Delete Tip from MyTips Using Loops in VBA in Microsoft Excel
Delete Tip from MyTips Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
Delete Tip from MyTips Retrieving Grade Value for Corresponding Mark
Delete Tip from MyTips Add page breaks to sorted data using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Column Header that Corresponds with a Matched Value
Delete Tip from MyTips Unintentionally Creating Links Between Workbooks
Delete Tip from MyTips Calculating a Required Date According to Two Criteria
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Combining Text and Numerically Calculated Results into One Output String
Delete Tip from MyTips Filtering a Range into a List of Unique Records
Delete Tip from MyTips Coloring Based on Text Criteria in Excel 2007
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Using a Workspace to Open a Number of Workbooks at Once in Excel 2007
Delete Tip from MyTips Displaying the Serial Number Behind the Date
Delete Tip from MyTips Retrieving Values that are Common to Two Lists
Delete Tip from MyTips Changing the Name of the Cell Comment's Author
Delete Tip from MyTips Enter the holiday according to the Table in the holiday-list using VBA
Delete Tip from MyTips Averaging Sales Totals by Day of the Week
Delete Tip from MyTips Using the Keyboard to Select Chart Items in Microsoft Excel
Delete Tip from MyTips Quickly Removing Subtotals
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Turn off warning messages using VBA in Microsoft Excel
Delete Tip from MyTips Dando Formato a un Número Negativo con Paréntesis
Delete Tip from MyTips Dividing a First Left Heading Title
Delete Tip from MyTips Adding a Running Balance Calculation Column
Delete Tip from MyTips Use Sorting to Delete Blank Rows in Excel 2007
Delete Tip from MyTips Create a hyperlink from a string in Microsoft Excel
Delete Tip from MyTips Protecting Sheets / Cells in Microsoft Excel
Delete Tip from MyTips Cell Function Returns Sheet Name, Workbook Name and Path
Delete Tip from MyTips Coloring One Record in Each Group in a Range
Delete Tip from MyTips Problem: Date Formatting Cannot Be Changed
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
Delete Tip from MyTips Protecting Workbooks with a Digital Signature in Excel 2007
Delete Tip from MyTips Combining Text from Different Cells
Delete Tip from MyTips Formatting a PivotTable Report
Delete Tip from MyTips Cambiando un Encabezado Numérico a Texto
Delete Tip from MyTips Switching Between Open Workbooks in Excel 2007
Delete Tip from MyTips Adding the Auto Outline, Clear Outline, and Show Outline Symbols Icons to the Toolbar
Delete Tip from MyTips Grouping a Date Field by Quarters in a Fiscal Reporting Year in Excel 2007
Delete Tip from MyTips Checking for Sequences within a Sorted List
Delete Tip from MyTips Cambiando el Nombre del Autor del Comentario de Celda
Delete Tip from MyTips Retrieving Data from a PivotTable Report
Delete Tip from MyTips PivotTable report - Inserting a Chart
Delete Tip from MyTips Calculating an Average, Only Including Prices on Which There Was no Discount
Delete Tip from MyTips Converting a Number to a Time Value
Delete Tip from MyTips Create User Forms in Microsoft Excel
Delete Tip from MyTips Count the number of values between a lower and upper limit in Microsoft Excel
Delete Tip from MyTips Copying Cell Content Across Sheets
Delete Tip from MyTips Reversing Strings
Delete Tip from MyTips Protecting Workbooks with a Digital Signature
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting in Excel 2007
Delete Tip from MyTips Creating a Table in Excel 2007
Delete Tip from MyTips Show/Hide Grand Totals in Excel 2007
Delete Tip from MyTips Sorting by Cell Color, Font Color or Cell Icon in Excel 2007
Delete Tip from MyTips Hiding Subtotal Level Buttons in Excel 2007
Delete Tip from MyTips Change text in header when printing using VBA in Microsoft Excel
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel 2007
Delete Tip from MyTips Merging and Centering in Excel 2007
Delete Tip from MyTips Validating Text Entries
Delete Tip from MyTips Summing Annual Expenses by Respective Quarters
Delete Tip from MyTips Password to prevent opening a workbook in Microsoft Excel
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Selecting/Formatting Cells Containing Errors
Delete Tip from MyTips Unprinted blank pages in Microsoft Excel 2002
Delete Tip from MyTips Identifying and selecting the print area in a sheet in Microsoft Excel
Delete Tip from MyTips Preventing Text from Spilling Over
Delete Tip from MyTips Los Iconos Desaparecen de la Barra de Herramientas
Delete Tip from MyTips Delete module content using VBA in Microsoft Excel
Delete Tip from MyTips Hiding the Display of Zero Values in Excel 2007
Delete Tip from MyTips Copy a column or columns from each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips PivotTable report - Adding a Calculated Field
Delete Tip from MyTips Backing Up Customized Changes to Toolbars and Menus
Delete Tip from MyTips Converting Time Values from One Time Zone to Another
Delete Tip from MyTips Summing Values Using Indirect Cell References
Delete Tip from MyTips Converting Time Values from One Time Zone to Another
Delete Tip from MyTips Counting Date Values by Specified Date Criteria
Delete Tip from MyTips Drawing Lines between Sorted Groups in Excel 2007
Delete Tip from MyTips Totaling Time Values
Delete Tip from MyTips Rounding Numbers to Millions
Delete Tip from MyTips Changing the Layout of the Chart from Rows to Columns and Vice Versa 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 Retrieving the First Value in a List that is Greater / Smaller than a Specified Number
Delete Tip from MyTips Copying Cell Content Across Sheets in Excel 2007
Delete Tip from MyTips Array Formulas – the Technical Side
Delete Tip from MyTips ”Desprender” Paletas desde la Barra de Herramientas
Delete Tip from MyTips Display message if column total is exceeded using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Conditional Formatting in Excel 2007
Delete Tip from MyTips Execute Command/Sub-Procedure Using Timer in VBA
Delete Tip from MyTips Calculating the Week Number
Delete Tip from MyTips Summing Sales Quantities and Amounts of Several Lists, or Presenting the Figures Side-by-Side in Excel 2007
Delete Tip from MyTips Highlight a selected range with a MsgBox 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. 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