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 · 1319 articles

Olivia · Nov 15, 2021

North Country Insurance Company

See how North Country Insurance Company used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.

Olivia · Nov 11, 2021

Convert Pricing Spreadsheets Into Sales Quoting Applications on Pipedrive

SpreadsheetWeb converts pricing spreadsheets into web applications and embed them into Pipedrive to calculate and generate sales quotes.

How to round date values in Excel
Ilker · Nov 11, 2021

How to round date values in Excel

In this guide, we’re going to show you how to round date values in Excel.

How to round time values in Excel
Ilker · Nov 10, 2021

How to round time values in Excel

In this guide, we’re going to show you how to round time values in Excel with MROUND, CEILING.MATH and FLOOR.MATH.

How to export each sheet as CSV in Excel
Ilker · Nov 9, 2021

How to save each sheet as CSV in Excel

Learn how to save each sheet as CSV in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.

Olivia · Nov 8, 2021

Turn Pricing Spreadsheets into Sales Quoting Applications on Close CRM

Convert Excel-based pricing models into web applications using SpreadsheetWeb, and embed them into Close CRM to create sales quotes.

Olivia · Nov 4, 2021

Converting Pricing Spreadsheets into Sales Quoting Applications on Zendesk

quoting applications converted from pricing spreadsheets with SpreadsheetWeb can be embedded seamlessly into Zendesk CRM.

Ilker · Nov 4, 2021

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.

Olivia · Nov 4, 2021

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 fill blank cells in an Excel Table
Ilker · Nov 2, 2021

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 a cell in Excel
Ilker · Nov 2, 2021

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.

Olivia · Nov 2, 2021

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
Ilker · Nov 1, 2021

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.

Olivia · Oct 28, 2021

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
Ilker · Oct 27, 2021

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.

Olivia · Oct 27, 2021

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
Ilker · Oct 26, 2021

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.

Olivia · Oct 26, 2021

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 in area charts in Excel
Ilker · Oct 18, 2021

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 in column or bar chart in Excel
Ilker · Oct 13, 2021

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.

Ugur · Oct 11, 2021

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
Ilker · Oct 5, 2021

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.

Adam · Oct 4, 2021

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
Ilker · Oct 1, 2021

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.