Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 5 of 60 · 540 articles
How to Enter in Excel and Change Its Behaviour
In this guide, we're going to show you how to change pressing Enter behavior in Excel. You can move in another direction or even disable it.
How to Sort Numbers by Using Excel Formulas
In this article we will show how to use Excel sort function using SMALL, ROW, SORT, and SORTBY functions.
How to Highlight Empty Cells in Excel | SpreadsheetWeb
Highlighting the empty cells can help easily identify the outliers. Find out how to highlight empty cells using Conditional Formatting.
Show Formulas in Excel
In this guide, we're going to show how to find formulas in Excel with Go to Special and Show Formulas features.
How to Spell Check in Excel
In this guide, we’re going to show you how to spell check step by step in Excel and how it differs from spell check in Word or PowerPoint.
Date in Excel: How to Enter Dates Only in the Current Week?
In this article, we are going to show you how to allow users to enter date values only for the current week in Excel.
Excel Forms: A VBA-Free Approach to Data Entry
In this guide, we’re going to show you how to enter data by using Excel Forms. You can use Forms to enter data without any knowledge in VBA.
How to Use Excel Sparklines for Better Looking Tables
Excel sparklines are the perfect tool for visualizing tabular data with the idea of placing the visualizations ‘in-line with other data’.
Scatter Chart in Excel
A scatter chart is a graphic representation of data by placing a collection of points on Cartesian Coordinates.