#row

Note: screenshots and examples were taken using Microsoft Excel 2013, however older versions can be used.

Tags

No tags yet.

Rows to Columns, Columns to Rows

There are situations where it's easier to sort if values were in columns (vertical) than rows. Learn how to do it using "paste spe

All about pivot tables part 4: PivotChart

Pivot charts present data from a PivotTable visually. Learn the differences between a PivotChart and a standard chart and how to create them

Stop Moving! - Absolute Cell Reference

Copied a formula to another cell and noticed the result is not the same as the cell that you just copied? Read on to see how $ signs can pre

Freeze right there! - Freeze Panes

Freeze panes enables you to “freeze a portion of the sheet to keep it visible while you scroll through the rest of the sheet."