Search Results for "merge cells"
427 results were found in the following tip categories:
Excel Keyboard Shortcuts
- The Best Shortcut Keys in Microsoft Excel
- Selecting Cells in Horizontal or Vertical Ranges
- Selecting a Range of Non-Adjacent Cells
- Selecting the Current Region/List
- Fast Typing in Selected Area
- Selecting Cells from Any Cell to the Last Cell in the Sheet's Used Range
- Selecting a Column(s) or Row(s) Using Keyboard Shortcuts
- Selecting a row or rows in Microsoft Excel
- Hiding/Unhiding a Row(s) or Column(s)
- Hiding or unhiding a column or columns in Microsoft Excel
- Fast Copying & Pasting in Adjacent Cells
- Copying & Pasting Cell Content to Thousands of Cells
- Quickly Entering Text into Cells from a List of Previous Entries or a Validation List
- Combining Text from Different Cells
- Displaying the Format Cells Dialog Box
- Adding a Linked Picture to a Chart in Microsoft Excel
- Updating Charts by Dragging and Dropping in Microsoft Excel
- Displaying Numbers in Thousands in a Chart in Microsoft Excel
- Copying/Moving a Cell(s) Between Sheets/Workbooks
- Adding Groups and Outlines Manually
- Insert or delete a Row/Column in Microsoft Excel
- Quick Move to end of range of cells in Microsoft Excel
- Quickly Selecting a Range of Cells
- Selecting Special Cells
- Selecting All Sheet Cells
- Fast Copying & Pasting Right or Down in a List
Keyboard Formula Shortcuts
Excel Text
- Selecting cells that only contain Text in Microsoft Excel
- Applying Formatting Only to Cells Containing Text
- Use Smart Tag to fill series of dates in Microsoft Excel
- Working Out a Person's Age in Microsoft Excel
- Let Excel Read Text for You
- What's New in Excel 2003
- Selecting Special Cells in Excel 2007
- Select and Show large Area in the Screen in Excel 2007
- Copying & Pasting Cell Content to Thousands of Cells in Excel 2007
- Copying Cell Content Across Sheets in Excel 2007
- Copying/Moving a Cell(s) Between Sheets/Workbooks in Excel 2007
- Whats New in Excel 2007
- Quickly Creating Links between Workbooks in Excel 2007
- Unintentionally Creating Links between Workbooks in Excel 2007
- Finding and Deleting Unwanted and Orphan Links in Excel 2007
Excel Time
Excel Importing Text Files
General Topics in VBA
- Set the Background Color according to the date using VBA in Microsoft Excel
- Change font color based on Date using VBA in Microsoft Excel
- Set background color depending on value verification using VBA in Microsoft Excel
- Set up yellow background color for header in an AutoFilter table using VBA in Microsoft Excel
- Display message if column total is exceeded using VBA in Microsoft Excel
- Display a record with a right mouse click using VBA in Microsoft Excel
- Merge cells without loosing values using VBA in Microsoft Excel
- Validation list without empty cells using VBA in Microsoft Excel
- Create worksheets from a list of names using VBA in Microsoft Excel
- Generate total for dynamic area using VBA in Microsoft Excel
- Search, enter, and delete values using VBA in Microsoft Excel
- Display AutoFilter criteria after filtering using VBA in Microsoft Excel
- Convert negative values treated as text using VBA in Microsoft Excel
- Display all installed fonts (Excel) using VBA in Microsoft Excel
- Using the Macro Recorder in Microsoft Excel
- Add a cell, Row or a column in Microsoft Excel
- Copying or Moving a Sheet
- The Euro Currency Tools Add-In
- Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
- Moving Between Precedent and Dependent Cells
- Selecting/Formatting Cells Containing Errors
- Pasting Values
- Selecting Cells That Contain Formulas
- Formatting Cells Containing Formulas
- Protecting Cells Containing Formulas in a Protected Sheet
- Printing Formula Syntax
- Coloring One Record in Each Group in a Range
- Sum total stock value for any part in Microsoft Excel
- Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References
- The Power Combination
- Validating Text Entries
- Preventing Duplicates While Entering Data
- Preventing Text from Spilling Over
- Changing the Indentation in a Cell
- Dividing a First Left Heading Title
- Transposing Cells
- Separating First and Last Names Without Using Formulas
- Quickly Typing Dates into Cells
- Filling a Range with a Series of Dates
- Use Smart Tag to fill series of dates in Microsoft Excel
- Using a Picture to Watch Cell Values in Other Sheets
- Deleting All Cell Comments in a Sheet
- Inserting a Copied Cell(s) Without Overwriting Existing Data
- Copying Cell Content Across Sheets
- Validating Number Entries
- Merging and Centering with a Toggle Button in Excel 2002 and Excel 2003
- Validating Date Entries
- Validating Number Entries in Excel 2007
- Validating Text Entries in Excel 2007
- Validating Date Entries in Excel 2007
- Filling a Range with a Series of Dates in Excel 2007
- To Fill Values Right or Down in a List in Excel 2007
- Quickly Entering Text into Cells from a List of Previous Entries or a Validation List in Excel 2007
- Preventing Duplicates While Entering Data in Excel 2007
- Transposing Cells in Excel 2007
- Protecting Data by Hiding a Row(s) and a Column(s) in Excel 2007
- Protecting Cells in the Sheet in Excel 2007
- Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007
- Protecting Cells Containing Formulas in an Unprotected Sheet in Excel 2007
- Limiting the Movement in a Protected Sheet in Excel 2007
- Hide/Unhide a Sheet in Excel 2007
- Deleting a Comment(s) in a Sheet in Excel 2007
Files, Workbook, and Worksheets in VBA
- Search value in external workbook and paste with format style using VBA in Microsoft Excel
- List files in a folder with Microsoft Scripting Runtime using VBA in Microsoft Excel
- List files in a folder with Office 97 or later using VBA in Microsoft Excel
- Read information from a closed workbook using VBA in Microsoft Excel
- Rounding Numbers to Thousands
- Rounding Numbers to Millions
- Rounding Numbers to Thousands with Hundreds as a Decimal
- Rounding Numbers to Millions with Thousands as a Decimal
- Formatting a Negative Number with Parentheses
- Replacing Zeros with Dashes in Number Formatting
- Hiding the Display of Zero Values
- Creating and Saving Custom Styles
- Copying Styles from One Workbook to Another
- Create styles directly from cells in Microsoft Excel
- Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
- Inserting Special Symbols into Custom Formats
- Displaying the Format Cells Dialog Box in Excel 2007
- Correct a ##### Error in Excel 2007
- Hiding the Display of Zero Values in Excel 2007
- Merging and Centering in Excel 2007
- Changing the Indentation in a Cell(s) in Excel 2007
- Automatically Wrapping Text in a Cell in Excel 2007
- Preventing Text from Extending Beyond the Range in Excel 2007
- Applying Formatting to Cells Containing Text Only in Excel 2007
- Conditional Formatting in Excel 2007
- Color Unique Record in a Range in Excel 2007
Excel Sorting
- Sorting Rules & List Structure
- How Excel Sorts Lists
- Sorting by Custom Lists
- Sorting Rules in Excel 2007
- Sorting by Custom Lists in Excel 2007
- Summing Rounded Numbers
- Fast Summation
- Summing data by selecting cells in Microsoft Excel
- Inserting Subtotals Quickly
- The SUMIF Formula – Using Comparison Operators ( ) as Criteria
- Summarize data according to criteria from the data table using Sumif formula, Offset formula and Combo Box in Microsoft Excel
- Summing a range containing errors and values in Microsoft Excel
- Summing using multiple criteria in Microsoft Excel
- Sum the largest two numbers in range in Microsoft Excel
- Summing Values from Cells in Different Sheets
- Using multiple criteria in SUMIF Function
- Avoiding the #VALUE! Error When Adding Cells That May Contain Blanks
- Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
- Separating Positive and Negative numbers and add Running Balance column
- Counting the number of cells containing a substring
- Counting Rows that Match Specific Criteria for Each Column
- Creating Formulas that Only Return Results from Non-Blank Cells
- Checking For Duplicate Values Within A Range
- Disregarding blank cells when performing calculations on a range.
- Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas
- Ignoring #DIV/0! Errors when Performing Calculations
- Avoiding Errors when Subtracting Times
- Shuffling a List of Values
- Creating a List of All Non-Blank Cells in a Column
- Checking for Duplicate Values within a Range
- Transposing an Entire Range of Data into a Single Column
- Transposing a Column into Successive Rows of a Specified Length
- Transposing a Range in Ascending Order
- Transposing Values from Columns into Rows, and Vice Versa
- Calculating the Percentage of Cells in a Range that Contain a Specified String
- Multiplying Values from Two Matrixes that Occupy Corresponding Addresses
- Entering Formulas in a Quicker Way by Shortening Sheet Names in Excel 2007
- Copying Formulas from a Range of Cells without Changing the Absolute or Relative References in Excel 2007
- Copying Formulas and Pasting Them in a Transposed Direction without Changing the Relative References in Excel 2007
- Pasting Values in Excel 2007
- Printing Formula Syntax in Excel 2007
- Displaying Formulas and Values of the Same Cells in Excel 2007
- Selecting Cells That Contain Formulas in Excel 2007
- Moving Between Precedent and Dependent Cells in Excel 2007
- Selecting Cells That Contain Errors in Formulas in Excel 2007
- Defining a Range Name in Excel 2007
- Deleting a Name when the Reference containing an Error or an Orphan Name in Excel 2007
- Automatically Defining Names for Ranges in a List in Excel 2007
- Use Name in a Formula in Excel 2007
- Automatically Updating a Range Name Reference in Excel 2007
- New AVERAGE Functions in Excel 2007
- AVERAGEIFS, SUMIFS and COUNTIFS Functions New functions in Excel 2007
Excel Tools
Cells, Ranges, Rows, and Columns in VBA
- Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
- Combine column text and replace using VBA in Microsoft Excel
- Copy all rows of a column without a value using VBA in Microsoft Excel
- Compare two worksheet ranges using VBA in Microsoft Excel
- Compare two worksheets using VBA in Microsoft Excel
- Convert between column numbers and column references using VBA in Microsoft Excel
- Delete rows with blank cells in a certain column using VBA in Microsoft Excel
- Copy a range with one Area to a Database sheet using VBA in Microsoft Excel
- Copy a range with more Areas to a Database sheet using VBA in Microsoft Excel
- Copy a Row or Rows to a Database sheet using VBA in Microsoft Excel
- Copy a Column or Columns to a Database sheet using VBA in Microsoft Excel
- Copy cells from the ActiveCell Row to a Database sheet using VBA in Microsoft Excel
- Copy Selection to a Database sheet using VBA in Microsoft Excel
- Copy Selection to a Database sheet using VBA in Microsoft Excel
- Copy a range on the place of the Activecell to a Database sheet using VBA in Microsoft Excel
- Copy a range of each sheet into one sheet using VBA in Microsoft Excel
- Copy the CurrentRegion of a cell of each sheet into one sheet using VBA in Microsoft Excel
- Copy the UsedRange of each sheet into one sheet using VBA in Microsoft Excel
- Copy a row or rows of each sheet into one sheet using VBA in Microsoft Excel
- Copy from row till the last row with data into one sheet using VBA in Microsoft Excel
- Copy a column or columns from each sheet into one sheet using VBA in Microsoft Excel
- Copy a Range from each workbook in a folder using VBA in Microsoft Excel
- Copy a row or rows from each workbook in a folder using VBA in Microsoft Excel
- Copy a column or columns from each workbook in a folder using VBA in Microsoft Excel
- Copy a range from each workbook with a file name starting with ? in a folder using VBA in Microsoft Excel
- Copy cells to all workbooks in a folder using VBA in Microsoft Excel
- Change all the cells in the ActiveSheet to values using VBA in Microsoft Excel
- Change all cells in a range to values using VBA in Microsoft Excel
- Change cells in the Activecell rowrange to values using VBA in Microsoft Excel
Counting
- Counting the Number of Cells Containing Text in a Range
- Comparing Lists Using the COUNTIF Formula
- COUNT Formulas
- Count the number of cells in a range in Microsoft Excel
- Count the number of blank cells in a range in Microsoft Excel
- Count the number of cells containing data in a range in Microsoft Excel
- Count the number of cells with numeric data in a range in Microsoft Excel
- Count the number of cells in a range containing all types of Errors in Microsoft Excel
- Count how many numbers are in series of numbers when a certain criteria is set in Microsoft Excel
- Count the number of values between a lower and upper limit in Microsoft Excel
- Count the number of times dates in certain month appears in range in Microsoft Excel
- Counting Unique Numeric Values or Unique Data in a List
- Counting the Values that Match Criteria in a Filtered List
- Creating a Summary Table of a Student Questionnaire
- Creating a Counting Grid
- Copying the Subtotals Summary
- Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
- Applying Colors to Subtotal Rows
- Coloring Two Subtotal Levels in Different Colors
- Copying the Subtotals Summary in Excel 2007
- Applying Colors to Subtotal Rows in Excel 2007
- Coloring Subtotal Levels in Different Colors in Excel 2007
Excel Array Formulas
- Array Formulas – the Technical Side
- Counting Based on Multiple Criteria
- Count the number of cells in a range containing all types of Errors in Microsoft Excel
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum positive value in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- Count the number of times dates in certain month appears in range in Microsoft Excel
- Ignoring Blank Cells when Performing Calculations
- Array Formulas in Excel 2007
Excel Grouping and Outlining
- Copying or Applying Color to Groups and Outlines
- Add Group and Outline in Excel 2007
- Copying or Applying Color to Groups and Outlines in Excel 2007
- Quickly Selecting a Range in the Workbook
- Recovering Data from a Corrupted Workbook That Cannot Be Opened
- Displaying Formulas and Values of the Same Cells
- Reducing the Workbook Size for Quick Sending via E Mail
- Coloring Sheet Tabs in Excel 2007
- Copying/Moving a Sheet in Excel 2007
- Grouping/Ungrouping Sheets in Excel 2007
- Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
Excel Formula
- Ignoring Blank Cells when Performing Calculations
- Avoiding the #VALUE! Error when Adding Cells that May Contain Blanks
- Watch Calculation Results Immediately in Excel 2007
- Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel
- Consolidating Lists
- Comparing Lists
- Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
- Summing Stock Lists
- Consolidating Lists in Excel 2007
- Coloring and/or Copying Subtotals from Consolidated Lists Containing Links in Excel 2007
- Summing Stock Lists in Excel 2007
- Comparing Lists in Excel 2007
- Summing the Values of Cells Occurring at the Intersection of Ranges
- Summing Subtotals Only from Range
- Modifying a SUMPRODUCT function to Return a Sum Rather than a Count
- Summing Rounded Numbers
- Summing Corresponding Values in Multiple Columns
- Calculating Monthly and Accumulated Income, Based on Specified Month
- Summing Groups of Every N Values in a Row
- Fast Summation in Excel 2007
- Removing Icons Performing Two Different Tasks
- Coloring Numbers Based on Specific Criteria Using Conditional Formatting
- Using the COUNT Functions
- Counting the Number of Cells Containing Text
- Counting the Number of Cells Containing Text
Excel Custom Functions using VBA
Custom Functions
- Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
- Sum by color using VBA in Microsoft Excel
- Count by color using VBA in Microsoft Excel
- Count cells in a range from all worksheets using VBA in Microsoft Excel
- Return every n-th item using VBA in Microsoft Excel
- Return random numbers using VBA in Microsoft Excel
- Writing Your First VBA Function in Excel
- Format table depending on number formats using VBA in Microsoft Excel
- Set up conditional formatting for an area with VBA in Microsoft Excel
- Adjust row height of merged cells using VBA in Microsoft Excel
- List all fonts available in Excel using VBA in Microsoft Excel
- Conditonal Formatting using Microsoft Excel VBA
Excel Pivot Tables
- Grouping the Date Field by Number of Days
- Pivot Table - Grouping dates by weeks in Microsoft Excel
- Rules for Organizing the Source Data in Excel Sheets
- PivotTable report - Grouping the Date Field by Days, Months, Quarters, and Years
- Automatic Report formatting using option buttons
- Creating PivotTable in Excel 2007
- Creating a PivotTable Report in Excel 2007
- Handling Errors in Values & Empty cells in Excel 2007
- Grouping the Date Field by Number of Days in Excel 2007
- Grouping the Date Field by Days, Months, Quarters, and Years in Excel 2007
- Retrieving a Value from a PivotTable Report in Excel 2007
- Delete all cells with today's date using VBA
- Search and copy date values using VBA
- Enter the holiday according to the Table in the holiday-list using VBA
- List and add the days of months in a set period using VBA in Microsoft Excel
- Enter the Weekdays Mon - Fri in a Worksheet using VBA in Microsoft Excel
- Replace all "u" with "U" up to today's date using VBA in Microsoft Excel
- Sort by birthday using VBA in Microsoft Excel
- Protecting the Sheet or the Cells in the Sheet
- Protecting Sheets / Cells in Microsoft Excel
- Moving Between Unprotected Cells in a Protected Sheet
- Protecting Data by Hiding a Row(s) and Column(s)
- Preventing Movement in Protected Areas in Microsoft Excel
- Limiting the Movement in a Protected Sheet
- Protecting Cells Containing Formulas in an Unprotected Sheet
- Formulas to calculate Loan payments in Microsoft Excel
- Create an Amortization Schedule in Microsoft Excel
- Print multiple selections on one sheet using VBA in Microsoft Excel
- Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
- Sum by color using VBA in Microsoft Excel
- Count by color using VBA in Microsoft Excel
- Count cells in a range from all worksheets using VBA in Microsoft Excel
- Return every n-th item using VBA in Microsoft Excel
- Return random numbers using VBA in Microsoft Excel
- Adding non-contiguous ranges to a single contiguous range for printing in Microsoft Excel
- Hiding Errors in Cells Before Printing
- Printing page number in the opposite direction in landscape layout page in Microsoft Excel
- Removing All Page Breaks from the Sheet
- Unhide rows and columns by using Custom Views in Microsoft Excel.
- Printing a PivotTable Report
- Printing a Page Number in Portrait While the Page Is in Landscape Layout
- Hiding Data Before Printing
- Printing Non-Continuous Areas
- Printing a Page Number in Portrait While the Page Is in Landscape Layout in Excel 2007
- Hiding Cells before Printing in Excel 2007
- Printing Non-Continuous Areas in Excel 2007
- Hiding Errors in Cells before Printing in Excel 2007
- Mail the selection using VBA in Microsoft Excel
- Mail sheet(s) to one or more people using VBA in Microsoft Excel
- Calculating the Number of Business Days in a Specified Period
- Avoiding Errors When Subtracting Times
- Calculating Absolute Difference between Two Time Values
- Calculating the Number of Business Days in a Specified Period
- Avoiding Negative Values when Calculating the Number of Days between Two Dates
- Entering Times Quickly
- Converting a Decimal Value to a Time Value
- Converting Time Values from One Time Zone to Another
- Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
- Creating a Date and Time Matrix
- Finding the First Login and Last Logout Times of Employees
- Calculating Daily Pay, Incorporating Variable Hourly Rates
- Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
- Avoiding Errors when Using the And Function to Combine Multiple Conditions in Array Formulas
Lookup Formulas
- Retrieve information from a range in another Excel File when the Path & File Name strings stored in various cells.
- Retrieving Sale Price Based On Item And Color Criteria
- Retrieving Values Using References Based on Row and Column Numbers
- Retrieving Values Using Range Names as References
- Retrieving the Last Value and the Last Character in a Row
- Retrieving the Last Value in a Dynamic List
- Retrieving the Value of the First Non-Blank Cell in a List
- Retrieving the Closest Larger / Closest Smaller Values from a List when there is No Exact Match
- Retrieve Value Using Case-Sensitive Lookups
- Retrieve the Distance between Any Two Cities from Distance Table
- Retrieving Sale Price Based on Item and Color Criteria
- Retrieving the Entire Row of a Matched Value
- Returning the Entire Contents of the Row Containing the Highest Math Grade
- Import data from Access to Excel (ADO) using VBA in Microsoft Excel
- Import data from Access to Excel (DAO) using VBA in Microsoft Excel
- Import data from a closed workbook (ADO) using VBA in Microsoft Excel
- Transfer data from a recordset to a worksheet (ADO) using VBA in Microsoft Excel
- Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
- Find the most commonly repeated string in a column in Microsoft Excel
- Removing Redundant Characters from a Range of Cells and Resetting the Format
- Splitting a Full Address into Three Separate Cells
- Retrieve Value Using Case-Sensitive Lookups
- Separating a Number Into Digits
- Restricting Cell Entries to Text Only
- Preventing Duplicates When Entering Data
- Combining Text and Formatted Numbers into a Single Entity
- Combining the Contents of Every N Number of Cells into One Value
- Formulas Erroneously Appearing as Text
- Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells
- Checking Whether Cells in a Range are Blank, and Counting the Blank Cells
- Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters
- Replacing Substrings with Numbers from Adjacent Cells
- Rearranging a String in Alphabetic Order
- Distribute Data from a List of the day to day sheets using VBA
- Add page breaks to sorted data using VBA in Microsoft Excel
Links in VBA
- List all the workbook links in a workbook using VBA in Microsoft Excel
- List, change or delete external formula references (links) using VBA in Microsoft Excel
- Seperating Website Name or URL from Text
Applications - Word, Outlook in VBA
- Control Excel from Word using VBA in Microsoft Excel
- Control Outlook from Excel using VBA in Microsoft Excel
Using Loops
Other Q&A Formulas
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum positive value in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- Get the value of the last non blank cell in a column in Microsoft Excel
- Get the Row number of the last non blank cell in a column in Microsoft Excel
- Find duplicates items in combine columns in Microsoft Excel
- Create Calculated Column(s) in Excel 2007
- Table Sorting Rules in Excel 2007
- Drawing Lines between Sorted Groups in Excel 2007
- Coloring Based on Text Criteria in Excel 2007
- Applying Colors to Top/Bottom Values in a List in Excel 2007

