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 23 of 55 · 1312 articles
How to format axis labels individually in Excel
Learn how to format axis labels individually in Excel. This practical guide covers the required setup, step-by-step process, and useful Excel options.
Convert Pricing Spreadsheets into Sales Quoting Applications on Zoho CRM
A focused overview of convert Pricing Spreadsheets into Sales Quoting Applications on Zoho CRM, explaining the main ideas, practical considerations, and relevant examples.
How to replace blank cells in an Excel Table
In this guide, we’re going to show you how to replace blank cells in an Excel Table.
How to trigger a macro by hovering over a cell in Excel
we’re going to show you how to trigger a macro by hovering over a cell in Excel.
Convert Pricing Spreadsheets into Sales Quoting Applications on HubSpot
pricing spreadsheets created in Excel can be transformed into web applications, embedded into HubSpot and used in your company’s workflow to calculate and generate quoting proposals.
How to highlight selected row and column in Excel
In this guide, we’re going to show you how to highlight selected row and column in Excel with help of VBA.
Turn Pricing Spreadsheets into Sales Quoting Applications on monday.com
SpreadsheetWeb offers businesses an easy and effective way to transform their pricing spreadsheets into web applications.
How to generate unique random numbers in Excel
In this guide, we’re going to show you how to generate unique random numbers in Excel.
Turn Invoice Spreadsheets into Web Applications on monday.com
many businesses still prefer using invoice spreadsheets, owing to its ease of use, customization capabilities, and the capacity to integrate highly complex calculation logic.
How to hide formula errors in Excel
In this guide, we’re going to show you how to hide formula errors in Excel to improve look and feel of your worksheet.
Create Timesheet Applications from Excel Spreadsheets on monday.com
timesheet applications are an important tool for businesses of all sizes and across various industries, as they aid with workload management, salary calculations, and time tracking.
How to set different colors to positive and negative numbers in area charts in Excel
Learn how to set different colors to positive and negative numbers in area charts in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to set different colors to positive and negative numbers in a column chart in Excel
In this guide, we’re going to show you how to set different colors to positive and negative numbers in a column chart.
What's New in SpreadsheetWeb 6.25: XLOOKUP Support
Review What's New in SpreadsheetWeb 6.25: XLOOKUP Support, including the product features, platform improvements, and workflow enhancements covered in this update.
How to protect a worksheet except for individual cells in Excel
In this guide, we’re going to show you how to protect a worksheet except for individual cells in Excel.
SpreadsheetWeb 6.25 Features Support for the XLOOKUP Formula
Pagos announces the release of SpreadsheetWeb 6.25, now introducing support for Excel’s new and powerful XLOOKUP formula.
How to split worksheet in Excel
In this guide, we’re going to show you how to split worksheet also known as splitting panes in Excel.
Integration of Custom Pricing Algorithms with CRM Systems
With SpreadsheetWeb CRM integrations, you can connect your Excel-based web applications into your CRM tools in just a few minutes.
How to create five-star rating chart in Excel
In this guide, we’re going to show you how to create five-star rating chart in Excel by using conditional formatting.
How to spell check using VBA in Excel
Excel's spell check does not run as you type. In this guide, we’re going to show you how to automate spell check using VBA in Excel.
How to calculate exponential moving average in Excel
In this guide, we’re going to show you how to calculate exponential moving average in Excel.
How to calculate weighted moving average in Excel
In this guide, we’re going to show you how to calculate weighted moving average in Excel.
How to calculate simple moving average in Excel
In this guide, we’re going to show you how to calculate simple moving average in Excel in three ways.
How to insert a picture into a note in Excel
In this guide, we’re going to refer legacy comments as Notes and show you how to insert a picture into a note in Excel.