in this tutorial we’ll discuss how to easily unhide a row or column in a worksheet when you have multiple ones hidden, and you don’t want to have to unhide the entire group to see a single row or column.
Tag Archives | Columns
This video will take you through the steps of creating a chart that dynamically changes based on the selection you make from a Data Validation drop down list. We’ll use various functions including INDEX, MATCH, COLUMNS, and ROWS.
Previously I did a post to convert a data range to a single column. In this video I will do the opposite – convert a single column into a data range or table. We will use the OFFSET, ROWS, and COLUMNS functions in the process.
Here is how you can take a vertical list of products and their ingredients and convert that into a table for easier viewing. In the process we will use the COLUMNS, COUNTIF, and VLOOKUP functions.
Here is an alternative way to re-order your rows and column in your PivotTables in Excel…..
Here is how you can re-arrange columns or rows in a PivotTable to get the look you want…..