|  

» 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 Create a Custom Function
Delete Tip from MyTips Quickly Typing Dates into Cells
Delete Tip from MyTips Quickly Selecting a Range in the Workbook
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 Copy a Range from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Removing Hidden Apostrophes from Imported Numbers
Delete Tip from MyTips Protecting Cells Containing Formulas in an Unprotected Sheet
Delete Tip from MyTips Combining Text and a Formatted Date
Delete Tip from MyTips Adding the Auto Outline, Clear Outline, and Show Outline Symbols Icons to the Toolbar
Delete Tip from MyTips Selecting the Current Region/List
Delete Tip from MyTips Change range with more then Area to values 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 Retrieving a value from a reference grid according to index values
Delete Tip from MyTips Fill a ListBox with unique values from a worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Picture to a Header/Footer
Delete Tip from MyTips Summing Values from a List Containing Numerical and Textual Substrings
Delete Tip from MyTips Setting the Number of Fields Displayed in the Page Layout
Delete Tip from MyTips Using multiple criteria in SUMIF Function
Delete Tip from MyTips Calculate a weeks start date using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Specified Number of Months to a Date
Delete Tip from MyTips Grouping/Ungrouping Sheets in Excel 2007
Delete Tip from MyTips Convert negative values treated as text using VBA in Microsoft Excel
Delete Tip from MyTips Converting Older Dates to the Current Year
Delete Tip from MyTips Adding a Running Balance Calculation Column
Delete Tip from MyTips Hiding or unhiding a column or columns in Microsoft Excel
Delete Tip from MyTips Copying & Pasting Cell Content to Thousands of Cells
Delete Tip from MyTips Automatically Wrapping Text in a Cell
Delete Tip from MyTips Getting Drill-Down Details
Delete Tip from MyTips Using Task Panes
Delete Tip from MyTips Summing data by selecting cells 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 Pasting Multiple Copied Ranges Using the Clipboard
Delete Tip from MyTips Restricting the Number of Characters Entered into a Cell
Delete Tip from MyTips Extracting Characters from Text Without Using Formulas
Delete Tip from MyTips Customizing an Icon
Delete Tip from MyTips Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
Delete Tip from MyTips Search value in external workbook and paste with format style using VBA in Microsoft Excel
Delete Tip from MyTips Control Excel from Word using VBA in Microsoft Excel
Delete Tip from MyTips Finding a substring within a string
Delete Tip from MyTips Basic information about OLE automation using VBA in Microsoft Excel
Delete Tip from MyTips Use messageboxes using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Values Using References Based on Row and Column Numbers
Delete Tip from MyTips Finding Minimum / Maximum Values
Delete Tip from MyTips How to change column number with letter in Microsoft Excel
Delete Tip from MyTips Selecting All Sheet Cells
Delete Tip from MyTips Counting Time Values in Terms of Hourly Increments
Delete Tip from MyTips Insert or delete a Row/Column in Microsoft Excel
Delete Tip from MyTips Summing Values Using Indirect Cell References
Delete Tip from MyTips Control Outlook from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Combined First and Last Names Matching Criteria in a Dynamic Range
Delete Tip from MyTips Using Loops in VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Average Value in Every Nth Column, Excluding Zeros
Delete Tip from MyTips Return unique items using VBA in Microsoft Excel
Delete Tip from MyTips Selecting a Set of Random Numbers, Avoiding Duplicates
Delete Tip from MyTips Find the minimum positive value in Microsoft Excel
Delete Tip from MyTips Calculating Average Annual Growth
Delete Tip from MyTips Copy worksheet information to Word using VBA in Microsoft Excel
Delete Tip from MyTips Change the default printer using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Combo Box
Delete Tip from MyTips Delete module content using VBA in Microsoft Excel
Delete Tip from MyTips Finding the Score that Was the Nth Highest for a Specified Team
Delete Tip from MyTips Adding Additional PivotTable Reports Using the Same Data Source
Delete Tip from MyTips Switching Between Open Workbooks in Excel 2007
Delete Tip from MyTips Performing calculations based on multiple criteria, using SUMPRODUCT function
Delete Tip from MyTips Adding a Custom Keyboard Shortcut
Delete Tip from MyTips Performing Numeric Operations on Substrings
Delete Tip from MyTips PDF2XL Enterprise
Delete Tip from MyTips Circular References
Delete Tip from MyTips Adding Groups and Outlines Manually
Delete Tip from MyTips Allowing Multiple Users to Edit Ranges in Microsoft Excel
Delete Tip from MyTips Displaying zero values in Microsoft Excel
Delete Tip from MyTips Los Iconos Desaparecen de la Barra de Herramientas
Delete Tip from MyTips Weeknumbers using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Wrapping Text in a Cell in Excel 2007
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips How to extract a file name from a path in Microsoft Excel
Delete Tip from MyTips Conditonal Formatting using Microsoft Excel VBA
Delete Tip from MyTips Parsing text to the right of a search criteria - delimiter in Microsoft Excel
Delete Tip from MyTips Printing Formula Syntax
Delete Tip from MyTips Counting the Number of Values Below or Above Average
Delete Tip from MyTips Creating and Saving Custom Styles
Delete Tip from MyTips Seeing Calculation Results Immediately
Delete Tip from MyTips Retrieving the Most Recent Payment Made by Client
Delete Tip from MyTips Entering Dates Quickly
Delete Tip from MyTips Array Formulas – the Technical Side
Delete Tip from MyTips Protecting Cells Containing Formulas in a Protected Sheet
Delete Tip from MyTips Mail sheet(s) to one or more people using VBA in Microsoft Excel
Delete Tip from MyTips Copy cells from the ActiveCell Row to a Database sheet 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 Search and copy date values using VBA
Delete Tip from MyTips Displaying the Serial Number Behind the Time
Delete Tip from MyTips Converting Text to Uppercase
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 Rounding Numbers to Millions
Delete Tip from MyTips Close a workbook 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 Retrieving Each Second Number from Two Lists
Delete Tip from MyTips Use the format painter to copy column widths and row heights in Microsoft Excel
Delete Tip from MyTips Adding the Properties Icon to the Standard Toolbar
Delete Tip from MyTips Use the continuous page numbers technique in Report Manager in Microsoft Excel.
Delete Tip from MyTips The PivotTable Tools Ribbon in Excel 2007
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips Removing Personal Information from a Workbook in Excel 2007
Delete Tip from MyTips Calculating Time Differences Between Regions of the World
Delete Tip from MyTips Using a Picture to Watch Cell Values in Other Sheets
Delete Tip from MyTips Saving Defined Page Setups for Future Printing
Delete Tip from MyTips Moviéndose Entre Libros de Trabajo Abiertos
Delete Tip from MyTips Set row height and column width in millimeters using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Subtotals Icon to the Menu Bar
Delete Tip from MyTips Ranking Salespeople According to Sales Figure
Delete Tip from MyTips Coloring Two Subtotal Levels in Different Colors
Delete Tip from MyTips Hiding the Display of Zero Values
Delete Tip from MyTips Preventing the Printing of Objects in Excel 2007
Delete Tip from MyTips Counting the Number of Unique Items Sold by Each Salesperson
Delete Tip from MyTips Retrieving the Minimal / Maximal Values from a Filtered List
Delete Tip from MyTips Extracting a substring
Delete Tip from MyTips Counting the Values that Match Criteria in a Filtered List
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Summing Positive and Negative Numbers Separately
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Creating, and using a Visual Basic Combo/ Edit box
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Summing Rounded Numbers
Delete Tip from MyTips Summing Expenses Accumulated to a Specified Month
Delete Tip from MyTips An Improved Custom Random Numbers Function
Delete Tip from MyTips Restore the VBE windows to their default positions using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Preventing charts from being printed in Microsoft Excel
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page
Delete Tip from MyTips Colorear las Filas Pares Numeradas en una Lista
Delete Tip from MyTips Access the Private module of a Worksheet Object while in Excel
Delete Tip from MyTips Changing the Indentation in a Cell(s) in Excel 2007
Delete Tip from MyTips Symbols Used to Create Custom Formatting
Delete Tip from MyTips Sum the largest two numbers in range in Microsoft Excel
Delete Tip from MyTips Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Changing the Font Size of the Sheet Name in Excel 2007
Delete Tip from MyTips Select folder names using VBA in Microsoft Excel
Delete Tip from MyTips Determine if a workbook is already open using VBA in Microsoft Excel
Delete Tip from MyTips Watch Cell Information at a Distance
Delete Tip from MyTips Adding Continuous Page Numbers While Printing
Delete Tip from MyTips Copying or Moving a Sheet
Delete Tip from MyTips Changing the Source Link in Excel 2007
Delete Tip from MyTips Quickly Entering a Long Company or Person Name
Delete Tip from MyTips Selecting a Sheet in the Workbook
Delete Tip from MyTips Sorting Options in Excel 2007
Delete Tip from MyTips Quickly Selecting a Range of Cells
Delete Tip from MyTips Using Financial Functions
Delete Tip from MyTips Change the cell formatted from date format to number format in Microsoft Excel
Delete Tip from MyTips Prevent Unauthorized Opening of Workbook
Delete Tip from MyTips Pasting Values
Delete Tip from MyTips Cambiar la Sangría en una Celda
Delete Tip from MyTips Hiding the Display of Zero Values in Excel 2007
Delete Tip from MyTips Reduciendo el Área Utilizada en una Hoja
Delete Tip from MyTips Converting Uppercase Letters to Lowercase
Delete Tip from MyTips Copying Formatting
Delete Tip from MyTips Insert/Delete a Row/a Column in Excel 2007
Delete Tip from MyTips Find duplicates items in combine columns 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 Printing a PivotTable Report in Excel 2007
Delete Tip from MyTips Displaying the Top/Bottom N Items in Excel 2007
Delete Tip from MyTips Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
Delete Tip from MyTips Coloring Even Numbered Rows in a List
Delete Tip from MyTips Calculating the Average of Every Nth Value, Excluding Zeros
Delete Tip from MyTips Quickly Removing Subtotals in Excel 2007
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007
Delete Tip from MyTips Separating Dates and Times
Delete Tip from MyTips Retrieving File Name by Matching a Given Page Number in a Book
Delete Tip from MyTips Determine if an application is available using VBA in Microsoft Excel
Delete Tip from MyTips Creating a PivotTable Report
Delete Tip from MyTips Counting Vacation or Sick Days within a Specified Time Period
Delete Tip from MyTips Hiding Items
Delete Tip from MyTips Consolidating Lists in Excel 2007
Delete Tip from MyTips Calculating the Percentage of Cells in a Range that Contain a Specified String
Delete Tip from MyTips Protecting a Workbook in Excel 2007
Delete Tip from MyTips Change the value/content of several UserForm-controls using VBA in Microsoft Excel
Delete Tip from MyTips Changing a Numeric Heading to Text in Excel 2007
Delete Tip from MyTips Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Validating Number Entries in Excel 2007
Delete Tip from MyTips Applying Formatting to Cells Containing Text Only in Excel 2007
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 Coloring Gridlines
Delete Tip from MyTips Copiando y Pegando el Contenido de Celdas Conservando el Formato
Delete Tip from MyTips Inserting/Editing Formulas
Delete Tip from MyTips Autoexpanding a Date Type Chart using Microsoft Excel
Delete Tip from MyTips Deleting Empty Rows
Delete Tip from MyTips Create styles directly from cells in Microsoft Excel
Delete Tip from MyTips Previniendo el Desborde de Texto
Delete Tip from MyTips Checking If Matching Numbers Exist in Different Ranges
Delete Tip from MyTips Add special symbols to the number format
Delete Tip from MyTips Add content to a module from a file using VBA in Microsoft Excel
Delete Tip from MyTips Creating a Dynamic Inventory List Based on Daily Sales
Delete Tip from MyTips Copying Styles from One Workbook to Another
Delete Tip from MyTips Retrieve the Distance between Any Two Cities from Distance Table
Delete Tip from MyTips Applying Colors to Top/Bottom Values in a List in Excel 2007
Delete Tip from MyTips Get the Row number of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Copy cells to all workbooks in a folder 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