Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 45 of 60 · 540 articles
How to unhide sheets in Excel and restore the worksheets tab
In this guide, we're going to show you how to unhide sheets and various methods to restore disappeared worksheet tabs.
Excel UNIQUE Function: Spill Range Operator
The unique function in Excel is a tool for handling dynamic arrays and spill concepts. Also, it introduces the spill range operator(#).
All you need to know about Excel's new Spill feature
Excel formulas can now return (spill) an array of values into neighboring cells by starting with cell containing the formula.
How to delete blank rows and columns at the end of worksheets using VBA
Learn how to delete blank rows and columns at the end of worksheets using VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
Area Chart in Excel
Learn how Area Chart in Excel works, including its structure, available chart types, and the steps for creating it in Excel.
How to use IFS and SWITCH formulas instead of nested IF statements
Learn how to use IFS and SWITCH formulas instead of nested IF statements. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to apply conditional formatting to Pivot Tables
Conditional formatting works differently in Pivot Tables. Let us show you how to apply conditional formatting to Pivot Tables.
How to make a line graph in Excel
In this article, we’re going to show you how to make a line graph in Excel for creating compelling reports.
How to compare two columns in Excel
In this guide, we’re going to show you how to compare two columns in Excel for a row-by-row analysis of data.