SpreadsheetWeb blog
Practical thinking for spreadsheet-powered teams
Deep guides on Excel, Google Sheets, web applications, product workflows, and the quiet technical traps worth knowing about.
Page 47 of 55 · 1319 articles
How to find named ranges in Excel by highlighting them using VBA
Highlighting them on your worksheets can help you identify their properties easily. Let us show you how to find named ranges in Excel.
How to lock a cell in Excel formula using VBA
In this article, we're going to show you how to lock a cell in Excel formula using VBA and prevent your users from changing formulas or data.
How and Why of Running a Simulation in Excel
Excel is commonly used to create data models and simulations. Let's examine a simulation in Excel and the tools available for this purpose.
How to un-protect a protected worksheet and vice versa - the VBA method
In this article, we're going to show you how to 'un-protect' protected worksheets and how to protect un-protected worksheets using VBA.
How to alphabetize Excel tabs using VBA
In this article, we're going to show you how to alphabetize Excel worksheets in ascending or descending alphabetical order using VBA.
Create Tables and Manipulate Data in an Instant with Excel Flash Fill
You can use the Flash fill to manipulate data quickly. Let us show you how Excel Flash Fill can save you time and drudgery.
How to unhide sheets in Excel with VBA
Learn how to unhide sheets in Excel with VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to hide formulas in Excel using the Protect Sheet feature
This article shows how to hide formulas in Excel using the Protect Sheet feature to prevent users from editing or seeing your formulas.
How to use a wildcard in Excel formula
Excel supports wildcard characters in formulas. Let us show you how to use a wildcard in Excel formula to find data that is partially known.
What's New in SpreadsheetWEB 6.4
In SpreadsheetWEB 6.4, we’ve added a completely new way to interact with input grids and a new way to bring visualizations to life.
SpreadsheetWEB 6.4 Now Available
Pagos, Inc. today announced the release of SpreadsheetWEB 6.4 version, featuring form-based grids, and enhanced visualization capabilities.
With Autofill Excel Shows Its Smarts and Saves You Time
Copy-paste tasks to automatically creating entire tables, with autofill Excel will save you a ton of headache and time.
Data Validation: Excel Doing the Data Cleaning for You
Data validation Excel doing your data cleaning for you by preventing data entry errors before they happen.
How to delete blank rows in Excel using Power Query
There are various methods to do this, but in this article we're going to focus on how to delete blank rows in Excel using Power Query.
How to remove blank rows in Excel using sorting
In this article, we're going to show you one of the easiest methods for organizing data and how to remove blank rows in Excel using sorting.
The crux of organizing your data: How to sort in Excel
In this article, we’re going to show you the best ways to organize data, how to sort in Excel, and walk you through available tools.
How to calculate standard deviation in Excel
In this article, we're going to show you how to calculate standard deviation in Excel using the STDEV.S and STDEV.P functions.
How to calculate mean in Excel
Learn how to calculate mean in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to stop excel from changing numbers to dates
Excel changes numbers or strings into dates to be "user-friendly". We're going to show you how to stop Excel from changing numbers to dates.
How to Disable Excel Automatic Calculations
In this article we're going to show you how todisable excel automatic calculations and avoid recalculating at every step.
How to merge cells in excel without losing data
Merge & Center feature removes cell data. In this article, we're going to show you how to merge cells in Excel without losing your data.
Connect Your Data Sources and Automate Updates with Excel Data Connection
Periodically updating spreadsheet data can be time consuming. Data connection features establish links with other data sources.
A Guide to Custom Sorting in Excel
Say you want to sort data starting with "Low", then "Medium", and "High". Let us show you how to sort in Excel in a custom order.
How to copy a formula in Excel between workbooks without links using a text editor
In this article we're going to show you how to copy a formula in Excel between workbooks without links, in a hassle-free fashion.