# Searched for: "insert multiple rows and columns in excel windows"

## About 19 results for "insert multiple rows and columns in excel windows"

• ### Office Q&A: A dynamic lookup solution for matching partial lists to a master list in Excel

When you need to accommodate an existing worksheet structure, the easiest solution isn't always possible. Susan Harkins shows a member how to get around this limitation.

Susan Harkins · March 4, 2016, 5:34 AM PST

• ### Office Q&A: A SUMIFS() matrix and absolute Table referencing

In this month's Q&A, we tackle two Excel techniques: summarizing transactions via a SUMIFS() matrix and setting up the correct syntax for absolute column references.

Susan Harkins · November 30, 2015, 5:01 PM PST

• ### Master sorting basics in Excel

Learning Excel's sort basics gives you a firm foundation for implementing more complex sorting tasks.

Susan Harkins · November 17, 2015, 5:57 AM PST

• ### Office Q&A: Conditionally count unique lists in Excel

This month, Susan Harkins helps readers conditionally count unique lists in Excel with two user-friendly solutions: a simple matrix and a PivotTable.

Susan Harkins · August 3, 2015, 10:21 AM PST

• ### Office Q&A: Add custom AutoComplete items; evaluate groups in an Excel data set

Susan Harkins helps readers with simple Office solutions. This month, she shows how to reclaim custom AutoComplete items and how to evaluate groups using aggregate functions.

Susan Harkins · July 6, 2015, 11:06 AM PST

• ### Three ways to return the average age for a group using Excel

Summarizing data is a common task in Excel, and there's usually more than one way to do so. Susan Harkins explains three ways to return averages for multiple groups.

Susan Harkins · April 13, 2015, 9:32 AM PST

• ### How to count duplicates and unique values in Excel

Duplicates aren't bad, but you may need to know how many times a value is repeated or how many unique values are in a data range. Here's how to tackle these tasks in Excel.

Susan Harkins · July 2, 2014, 12:56 PM PST

• ### Office Q&A: How to unhide columns and use Office 365 on Mac

Not every problem is large in scope. Susan Harkins finds simple solutions for three readers. Find out how to unhide columns and rows, use Office 365 on the Mac, and perform page numbering in sections.

Susan Harkins · February 10, 2014, 12:35 PM PST

• ### How to find duplicates in Excel

You'll need more than one trick up your sleeve to find duplicates in Excel.

Susan Harkins · March 5, 2013, 2:56 AM PST

• ### How do I... Display multiple values in an Access value list control?

You can populate a list control with an explicit list of values and generally, that list consists of one column, although you can display more. Creating a multi-column value list control is the easy p...

Susan Harkins · January 23, 2008, 4:12 AM PST