|  

» 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 How to extract a file name from a path in Microsoft Excel
Delete Tip from MyTips Automating the Insertion of the Euro Symbol
Delete Tip from MyTips Filtering by More Than Two Criteria
Delete Tip from MyTips Quickly Creating Links Between Ranges
Delete Tip from MyTips Rounding Numbers to Millions with Thousands as a Decimal
Delete Tip from MyTips Determine if a cell is within a range using VBA in Microsoft Excel
Delete Tip from MyTips Negative times in Microsoft Excel
Delete Tip from MyTips Checking for the Presence of Specified Values Within a Range
Delete Tip from MyTips Printing page number in the opposite direction in landscape layout page in Microsoft Excel
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting
Delete Tip from MyTips Counting the Number of Items Sold Every Half Hour
Delete Tip from MyTips Summing Values from Cells in Different Sheets
Delete Tip from MyTips Calculating the Number of Hours Worked Based on a System of Letter Codes
Delete Tip from MyTips Determine which CommandBar button that started a macro using VBA in Microsoft Excel
Delete Tip from MyTips Summing Sales Amounts According to Product Category and Customer Name
Delete Tip from MyTips Pass arguments to macros from buttons and menus using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Numbers to Millions
Delete Tip from MyTips Pasting Values
Delete Tip from MyTips Extracting Characters from Text Without Using Formulas
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 Turn off warning messages using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Calculating the Number of Weekday Hours Between Two Dates
Delete Tip from MyTips Entering the Current Time into a Cell
Delete Tip from MyTips Insert headers and footers using VBA in Microsoft Excel
Delete Tip from MyTips Extracting the First N Number of Words from a String
Delete Tip from MyTips Performing calculations based on multiple criteria, using SUMPRODUCT function
Delete Tip from MyTips Opening/Closing a Workbook(s) in Excel 2007
Delete Tip from MyTips Add cells in a range from all worksheets in the workbook 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 Function for returning the user name using VBA in Microsoft Excel
Delete Tip from MyTips Copying/Moving a Sheet in Excel 2007
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 Extract the last word in a cell in Microsoft Excel
Delete Tip from MyTips PivotTable Report Terminology
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips Subtracting Times
Delete Tip from MyTips Control Word from Excel 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 Converting Text to Uppercase
Delete Tip from MyTips Forecasting Daily Budget
Delete Tip from MyTips Combining Text from Different Cells
Delete Tip from MyTips Search value in external workbook and paste with format style using VBA in Microsoft Excel
Delete Tip from MyTips Copy row heights and column widths using VBA in Microsoft Excel
Delete Tip from MyTips Using a Range Name in a Formula
Delete Tip from MyTips Create a Custom Function
Delete Tip from MyTips Counting the Number of Cells Containing Text in a Range
Delete Tip from MyTips Canceling the Update Links Message While Opening a Linked Workbook
Delete Tip from MyTips Chart object events using VBA in Microsoft Excel
Delete Tip from MyTips Delete a module using VBA in Microsoft Excel
Delete Tip from MyTips Return unique items using VBA in Microsoft Excel
Delete Tip from MyTips Import data from a closed workbook (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips An Improved Custom Random Numbers Function
Delete Tip from MyTips Weeknumbers using VBA in Microsoft Excel
Delete Tip from MyTips Delete rows and columns using VBA in Microsoft Excel
Delete Tip from MyTips Create User Forms in Microsoft Excel
Delete Tip from MyTips Unprinted blank pages in Microsoft Excel 2002
Delete Tip from MyTips Retrieving Smallest Nth Value Match Within a List
Delete Tip from MyTips Log files using VBA in Microsoft Excel
Delete Tip from MyTips Square root and cube root in Microsoft Excel
Delete Tip from MyTips Transposing Cells in Excel 2007
Delete Tip from MyTips How to Use Your Excel Add-In Functions in VBA
Delete Tip from MyTips Filtering is limited to 999 items in Microsoft Excel
Delete Tip from MyTips Separating Dates and Times
Delete Tip from MyTips Removing Icons Performing Two Different Tasks
Delete Tip from MyTips Selecting a sheet from shortcut menu in Microsoft Excel
Delete Tip from MyTips List all fonts available in Excel using VBA in Microsoft Excel
Delete Tip from MyTips Avoiding Problems when Numeric Values are used as Text
Delete Tip from MyTips Randomly Selecting a Value from a Range
Delete Tip from MyTips Quickly Entering Text into Cells from a List of Previous Entries or a Validation List in Excel 2007
Delete Tip from MyTips Coloring Sheet Tabs
Delete Tip from MyTips Deleting All Cell Comments in a Sheet
Delete Tip from MyTips File names and folder names using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Price for a Specified Item and a Specified Brand
Delete Tip from MyTips Using the Macro Recorder in Microsoft Excel
Delete Tip from MyTips Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
Delete Tip from MyTips Creating a Date and Time Matrix
Delete Tip from MyTips Set the Background Color according to the date using VBA in Microsoft Excel
Delete Tip from MyTips Counting how many times specific character appears in cell in Microsoft Excel
Delete Tip from MyTips Retrieving From List By Position
Delete Tip from MyTips Formatting a Negative Number with Parentheses
Delete Tip from MyTips Worksheet events using VBA in Microsoft Excel
Delete Tip from MyTips Manually Wrapping Text in a Cell
Delete Tip from MyTips Printing a Chart in Microsoft Excel
Delete Tip from MyTips Import data from Access to Excel (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Show/Hide Grand Totals in Excel 2007
Delete Tip from MyTips Calculate number of minutes between dates - time in Microsoft Excel
Delete Tip from MyTips Summing How Many Points Scored by a Specified Team in Specified Games
Delete Tip from MyTips Copy a range with more Areas to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Entering Dates Quickly
Delete Tip from MyTips Give a non-Excel look by Hiding the Active Menu And Using Full Screen using VBA in Microsoft Excel
Delete Tip from MyTips Preventing a Printed Area from Extending onto an Extra Page
Delete Tip from MyTips Converting Uppercase Letters to Lowercase
Delete Tip from MyTips Transponiendo Celdas
Delete Tip from MyTips Add a fancy line for Presentation
Delete Tip from MyTips Comparing Lists
Delete Tip from MyTips Changing the Default Number of Sheets in a New Workbook
Delete Tip from MyTips Retrieving Every nth Value In a Range
Delete Tip from MyTips Using Different Functions to Consolidate Lists in excel 2007
Delete Tip from MyTips Return random numbers using VBA in Microsoft Excel
Delete Tip from MyTips Read information from a closed workbook using VBA in Microsoft Excel
Delete Tip from MyTips Select folder names using VBA in Microsoft Excel
Delete Tip from MyTips Determine if a file is in use using VBA in Microsoft Excel
Delete Tip from MyTips Change text in header when printing using VBA in Microsoft Excel
Delete Tip from MyTips The SUMIF Formula – Using Comparison Operators ( ) as Criteria
Delete Tip from MyTips Add a cell, Row or a column 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 From Multiple Copied Ranges in Excel 2007
Delete Tip from MyTips Getting Drill-Down Details in Excel 2007
Delete Tip from MyTips Copy a row or rows from each workbook in a folder using VBA 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 Filtering a List into Unique Records Using the COUNTIF Formula
Delete Tip from MyTips Counting values meeting multiple criteria in different columns.
Delete Tip from MyTips Preventing Duplicates While Entering Data
Delete Tip from MyTips Count by color using VBA in Microsoft Excel
Delete Tip from MyTips Summing Expenses Accumulated to a Specified Month
Delete Tip from MyTips Counting Vacation or Sick Days within a Specified Time Period
Delete Tip from MyTips Enter the holiday according to the Table in the holiday-list using VBA
Delete Tip from MyTips Seperating Website Name or URL from Text
Delete Tip from MyTips Applying Colors to Subtotal Rows in Excel 2007
Delete Tip from MyTips Selecting Special Cells
Delete Tip from MyTips Adding the Path Address to the Header/Footer
Delete Tip from MyTips Removing the Smart Tag Indicator
Delete Tip from MyTips Change a Row or Rows to values to values using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Players According to Their Score in a Particular Quarter
Delete Tip from MyTips Counting Rows of Even Numbers in Two Parallel Ranges
Delete Tip from MyTips Get the value of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Creating a PivotTable Report
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 Problem: Values Not Formatting as Numbers
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Get the Row number of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References
Delete Tip from MyTips Converting Text to Its Proper Case
Delete Tip from MyTips Transfer data from a recordset to a worksheet (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Delete sheets without confirmation prompts using VBA in Microsoft Excel
Delete Tip from MyTips Using the Keyboard to Select Chart Items in Microsoft Excel
Delete Tip from MyTips Count the number of words in a cell in Microsoft Excel
Delete Tip from MyTips Converting Older Dates to the Current Year
Delete Tip from MyTips Find the value in the first non blank cell in range in Microsoft Excel
Delete Tip from MyTips Protecting a Workbook
Delete Tip from MyTips Copying Styles from One Workbook to Another
Delete Tip from MyTips Retrieving Unique Values From A List
Delete Tip from MyTips PDF2XL and PDF2XL OCR
Delete Tip from MyTips Changing the Number of Files Shown in the Recent Documents List in Excel 2007
Delete Tip from MyTips Create styles directly from cells in Microsoft Excel
Delete Tip from MyTips Rules for Organizing the Source Data in Excel Sheets
Delete Tip from MyTips Shortcuts for opening the Function Arguments window in Microsoft Excel
Delete Tip from MyTips Adding the Full Path of the Saved File to the Header/Footer
Delete Tip from MyTips Retrieving the Column Header of the Largest Value in a Row
Delete Tip from MyTips Create Calculated Column(s) in Excel 2007
Delete Tip from MyTips Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side
Delete Tip from MyTips Sorting Numbers in Ascending or Descending Order
Delete Tip from MyTips Funcionalidades Expandidas de Pegado de Íconos en Excel 2002 y Excel 2003
Delete Tip from MyTips Creating and Saving Custom Formatting Styles in Excel 2007
Delete Tip from MyTips Sort Ascending/Descending While Using AutoFilter
Delete Tip from MyTips Changing the Cell Formatting from Date to Number
Delete Tip from MyTips Deleting Empty Rows
Delete Tip from MyTips Change only the CurrentRegion of the ActiveCell to values using VBA in Microsoft Excel
Delete Tip from MyTips What is an addin? in Microsoft Excel
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Redondeando Números a Millones con Miles como Decimal
Delete Tip from MyTips Retrieving a Price Value By Looking at Two Difference Data Tables
Delete Tip from MyTips Seleccionando celdas especiales
Delete Tip from MyTips Set row height and column width in millimeters using VBA in Microsoft Excel
Delete Tip from MyTips Changing a Numeric Heading to Text
Delete Tip from MyTips Vlookup Formula – Organizing the Data Table
Delete Tip from MyTips Allowing Multiple Users to Edit Ranges in Microsoft Excel
Delete Tip from MyTips Working Out a Person's Age in Microsoft Excel
Delete Tip from MyTips Copy worksheet information to Word using VBA 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 Restore the VBE windows to their default positions using VBA in Microsoft Excel
Delete Tip from MyTips Reversing the Word Order within a String
Delete Tip from MyTips Rounding Time Intervals to the Nearest Specified Time Increment
Delete Tip from MyTips Rounding numerical calculation results in Microsoft Excel
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Seleccionando la Lista/Región Actual
Delete Tip from MyTips Retrieving Values from a List that are Greater than a Specified Number
Delete Tip from MyTips Log files using VBA in Microsoft Excel
Delete Tip from MyTips Avoiding False Results when Counting Dates Matching Specified Criteria
Delete Tip from MyTips Coloring Gridlines in Excel 2007
  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. Create User Forms in Microsoft Excel
  6. Copy Selection to a Database sheet using VBA 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