Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 12 of 60 · 540 articles
Developing Applications with Tabular Data
Working with tables on web applications can be far more challenging than it is in Excel, the primary reason being the lack of real estate.
Merge Two Columns in Excel
Traditional Copy+Paste might do all you want, but when working with large tables that are constantly updated, it's a tedious task to merge multiple columns of data. Using this formula combination instead will save you time and prevent errors.
How to Add Double Quotes in Excel
Excel uses double-quote characters to identify text. Add double quotes in Excel in two ways: with and without a function.
How to SUM Cells in Excel by an Equal Criteria
Do you have a data table where you must pick all the highest, lowest, best, worst, or equal to 2? SUMIF and its bigger brother SUMIFS formulas can help sum cells of your choice.
How to Roll Dice in Excel in 3 Ways
did you know you can roll dice using Excel? In this guide, we’re going to show you How to roll dice in Excel in 3 ways.
How to Highlight Cells in Excel Based on Value
Click to learn to highlight cells based on value using conditional formatting in Excel.
How to get size of an array in Excel
Learn how to get size of array in Excel using VBA.
How to Copy Formula in Excel
In this article we're going to show you another method to copy a formula in Excel between workbooks without links, in a hassle-free fashion.
Online Calculator Creation with Excel
SpreadsheetWEB allows you to create fancy online calculators using Excel and then distribute them to whoever you want.