Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 58 of 60 · 540 articles
How to return an entire row
Learn how to return an entire row. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to return an entire column
Learn how to return an entire column. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to convert a URL into a hyperlink automatically
Learn how to convert a URL into a hyperlink automatically. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to Transpose The Rows and Columns of a Data Table
To transpose rows and columns in Excel in a data set, transpose table using single formula, also works with dynamic ranges.
Manage Tasks Better by Visualizing the Data in Gantt Chart
Gantt charts are very helpful for project management and time tracking purposes. Even though Excel doesn’t have a built-in Gantt chart, it’s possible to get the same result using workarounds like this one.
How to create a random secure password in Excel
Learn how to create a random secure password in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to shuffle a list of items in a random order
Learn how to shuffle a list of items in a random order. This practical guide covers the required setup, step-by-step process, and useful Excel options.
How to add comments into formulas
Learn how to add comments into formulas. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a calendar that only contain workdays
Learn how to create a calendar that only contain workdays. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.