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 33 of 55 · 1312 articles
Single Record per User and Query Triggers Featured in Version 6.17
SpreadsheetWEB 6.17 features new workflow capabilities, database query trigger customization, and the new Google Sheets Connector.
How to customize the Excel status bar
Status Bar displays various information about the Excel workbook. In this guide, we’re going to show you how to customize Excel Status bar.
How to transpose Excel data using the Paste Special feature
Transposing means to rotate a range. In this guide, we’re going to show you how to transpose Excel data using the Paste Special feature.
How to add a diagonal line to a cell in Excel
In this guide, we’re going to show you how to add a diagonal line to a cell in Excel and some examples for when this format can be handy.
How to save an Excel chart template
In this guide, we’re going to show how to save an Excel chart template, and also go over re-using and deleting any existing templates.
How to use Paste Special to modify formulas in Excel
In this guide, we’re going to show how to use Paste Special to modify formulas in Excel. You can add, subtract, multiply or divide formulas.
How to multiply multiple cells in Excel using Paste Special
In this guide, we’re going to show you how to multiply multiple cells in Excel using Paste Special, which can also Add, Subtract, Divide.
How to create an Excel summary table using UNIQUE and SUMIFS
In this guide, we’re going to show you how to use UNIQUE and SUMIFS functions in combination to generate an Excel summary table.
How to do a cell count if not equal to a variable or even an error code
In this guide, we’re going to show an alternative way to count if not equal to a variable, or even an error message in Excel, using formulas.
How to use COUNTIFS Excel Function with Unequal Ranges
In this guide, we’re going to show how to use COUNTIFS Execl with unequal ranges. COUNTIF function is also a viable alternative for this.
NoCode in the Enterprise
NoCode enterprise reach can require a significant amount of effort to make the product compatible with rigorous requirements.
What's New in SpreadsheetWEB 6.16
With this version, we now have a OneDrive connector and page icons! OneDrive is one of the most popular cloud services for storing files.
Version 6.16 Introduces the OneDrive Connector and Page Icons
Pagos, Inc. has just announced the release of version 6.16, introducing the OneDrive connector, and the ability to add page icons.
How to count if not equal to x or y in Excel
In this guide, we’re going to show you how to count cells not equal to x or y in Excel with COUNTIFS and SUMPRODUCT functions.
How to make complex formulas easier to read with line breaks in Excel
In this guide, we’re going to show you how to make complex formulas easier to read by separating them using line breaks in Excel.
Handling Business Logic in NoCode
While there are numerous NoCode platforms for designing presentation and data layers, the market is sparse when it comes to business logic.
How to switch to Excel full screen mode
Full screen view can greatly increase the work area visibility. In this guide, we’re going to show you how to switch to Excel full screen.
How to Make Excel Show Formula Bar or Hide It
You can hide the formula bar to limit unwanted access. In this guide, we’re going to show you how to make Excel show formula bar or hide it.
The Rise of NoCode in Numbers
Over the past few years, a surge of new technology platforms has triggered a cascade in the popularity of NoCode.
The First NoCode Platform: Spreadsheet Software
NoCode is not a new concept: the tools for nonprogrammers to build their own applications without coding has been around for a long time.
Color coded parentheses in Excel for easier formula creation
It's easy to lose track when writing complex formulas. In this guide, we're going to explain color coded parentheses in complex formulas.
How to how to debug an Excel formula using the F9 key
F9 is an easy way to break a formula down into pieces. In this guide, we're going to show you how to debug an excel formula using F9.
How to analyze complex formulas with the Excel Evaluate formula feature
In this guide, we're going to show you step through complex formulas with the help of the Excel Evaluate formula, and go over some examples.
Relative Named Range in Excel
In this guide, we're going to show you relative named ranges in Excel. References of relative names get updated by used cell's position.