Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 3 of 60 · 540 articles
How to Create a Time Calculator in Excel
SpreadsheetWeb • In this article, we will show you how to calculate shift time calculator in Excel using IF function.
How to calculate percentage in Excel
In this article, we’re going to show you how to calculate percentage in Excel with samples and also go over some tips and examples.
Add a New Line in Excel Cell
SpreadsheetWeb • Excel Tips & Tricks In this guide, you will learn how to add a new line in Excel cell just in minutes.
How to Add Header and Footer in Excel
In this guide, we’re going to show you how to add header and footer in Excel with screenshots and examples.
Hide Scroll Bar in Excel
SpreadsheetWeb • In this guide, we’re going to show you how to Hide Scroll Bar in Excel and how to unhide it.
How to lock cells in Excel
In this article, we’re going to show you how to lock cells in Excel to protect them and prevent other users from editing.
How to Generate Diceware Passwords in Excel
In this guide, we're going to show you how to generate Diceware passwords in Excel. The Diceware method is a password generation method.
How to hide formulas in Excel using the Number Formatting feature
You can number formatting to hide the value of a cell without changing it. Let us show you how to hide formulas in Excel using formatting.
Highlighting the Top Values with the LARGE Function in Excel
In this article, you will learn how to use the LARGE function in Excel to highlight the top values on a data set.