wp-sheet-editor-logo-15px
  • AI
  • Google Sheets Sync
  • Plugins
    • Automations
    • WooCommerce Products Spreadsheet
    • Posts, Pages, and Custom Post Types Spreadsheet
    • Courses Spreadsheet
    • Media Library Spreadsheet
    • WordPress Users Spreadsheet
    • WooCommerce Coupons Spreadsheet
    • Comments and Reviews Spreadsheet
    • Categories, Tags, Product Attributes, Taxonomies Spreadsheet
    • WooCommerce Orders Spreadsheet
    • Universal Frontend Editor
    • Easy Digital Downloads Spreadsheet
    • GiveWP Spreadsheet
    • Events Spreadsheet
    • WooCommerce Customers Spreadsheet
    • Custom Database Tables Spreadsheet
    • All Plugins
  • Help
    • Guides and Tutorials
    • FAQ
    • Contact
    • Developers
  • Account
  • Toggle website search
Menu Close
  • AI
  • Google Sheets Sync
  • Plugins
    • Automations
    • WooCommerce Products Spreadsheet
    • Posts, Pages, and Custom Post Types Spreadsheet
    • Courses Spreadsheet
    • Media Library Spreadsheet
    • WordPress Users Spreadsheet
    • WooCommerce Coupons Spreadsheet
    • Comments and Reviews Spreadsheet
    • Categories, Tags, Product Attributes, Taxonomies Spreadsheet
    • WooCommerce Orders Spreadsheet
    • Universal Frontend Editor
    • Easy Digital Downloads Spreadsheet
    • GiveWP Spreadsheet
    • Events Spreadsheet
    • WooCommerce Customers Spreadsheet
    • Custom Database Tables Spreadsheet
    • All Plugins
  • Help
    • Guides and Tutorials
    • FAQ
    • Contact
    • Developers
  • Account
  • Toggle website search

Help articles

  1. Home>
  2. Help articles>
  3. Page 19

How to disable the loading of rows on scroll

  • Post author:Jonathan Gomez
  • Post published:December 11, 2020
  • Post category:FAQ/How to use the spreadsheet

To disable the loading of rows on scroll, Go to settings > Load more rows on scroll and leave it unchecked.

Continue ReadingHow to disable the loading of rows on scroll

How to remove the help messages on the spreadsheet columns?

  • Post author:Jonathan Gomez
  • Post published:December 11, 2020
  • Post category:FAQ/How to use the spreadsheet

Go to the spreadsheet > Settings > Advanced settings > Customize features > Remove help messages from the cells.

Continue ReadingHow to remove the help messages on the spreadsheet columns?

Why do the columns appear in different order?

  • Post author:Jonathan Gomez
  • Post published:December 11, 2020
  • Post category:FAQ/How to use the spreadsheet

By default, the columns are ordered based on the code execution of the related Sheet Editor module. We have the serialized columns module, ACF module, etc. That’s why…

Continue ReadingWhy do the columns appear in different order?

How to change dates in the spreadsheet

  • Post author:Jonathan Gomez
  • Post published:December 11, 2020
  • Post category:FAQ/How to use the spreadsheet

To change dates in the spreadsheet you need to locate in the “Date” column and change the date using the calendar popup in the cells. This applies to…

Continue ReadingHow to change dates in the spreadsheet

How to add extensions

  • Post author:Jonathan Gomez
  • Post published:December 11, 2020
  • Post category:FAQ/How to use the spreadsheet

To add extensions to the plugin, open the “Extensions” tool by clicking “Extensions” on the toolbar.

Continue ReadingHow to add extensions

Use slower execution method

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

The default way uses a faster execution method, but it might not work in all cases. In such cases, go to “Bulk Edit” and check the “Use slower…

Continue ReadingUse slower execution method

Disable post actions while saving

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To disable post actions while saving, go to Settings > Advanced settings > Solution to weird errors > Disable post actions while saving?, and tick/untick the checkbox

Continue ReadingDisable post actions while saving

Disable cells lazy loading

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To disable cells lazy loading, go to Settings > Advanced settings > Customize Features> Disable cells lazy loading?, and tick/untick the checkbox

Continue ReadingDisable cells lazy loading

Disable usage stats widget

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To disable usage stats widget, go to settings > advanced settings > Customize Features> Disable usage stats widget?, and tick/untick the checkbox

Continue ReadingDisable usage stats widget

Suspend object cache invalidation

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To suspend object cache invalidation, go to Settings > Advanced settings > Solution to weird errors > Suspend Object Cache invalidation?, and tick/untick the checkbox

Continue ReadingSuspend object cache invalidation

Disable or enable extension offerings

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To disable extension offerings, go to Settings > Advanced Settings > Misc > Disable extension offerings? and tick/untick the checkbox

Continue ReadingDisable or enable extension offerings

How to set a different taxonomy separator

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

If you want to select a different taxonomy separator, go to Settings > Advanced settings > Solution to Weird Errors > Separator for taxonomy terms cells, and enter…

Continue ReadingHow to set a different taxonomy separator

How to load rows from a specific row number

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

When you have 1000 posts, you might want to open the spreadsheet and start editing from post 200. For that, go to settings > advanced settings > Misc…

Continue ReadingHow to load rows from a specific row number

How to enable/disable the fixing of the first 2 columns at the left side

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To disable or enable the fixing of the first 2 columns at the left side of the spreadsheet, go to Settings > Advanced settings > Increase productivity >…

Continue ReadingHow to enable/disable the fixing of the first 2 columns at the left side

How to add values at the beginning or end of columns or rows

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To prepend or append something to columns or rows, open the “Bulk Edit” tool. Select the fields you’ll edit and select the type of edit you’ll apply: prepend…

Continue ReadingHow to add values at the beginning or end of columns or rows

How to set new values on columns

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To set new values on columns, go to the “Bulk Edit” tool. Select the column you’ll edit >Choose “Set value” as the type of edit you’ll apply >…

Continue ReadingHow to set new values on columns

How to replace words or phrases in an entire column

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To replace words or phrases in an entire column, go to “Bulk Edit” on the toolbar. Select the column you’ll edit in the “Field you want to edit”…

Continue ReadingHow to replace words or phrases in an entire column

How to delete everything in one column

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To delete everything in one column, you have two options: manual and bulk. Manually, select the column by clicking the above part of it and then hit “Delete”…

Continue ReadingHow to delete everything in one column

How to edit post or product URL

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To edit a product/post URL, go to the “Slug” column, and hit “Enable”. Then, paste the URL in the “Slug” cell.   Note: If the products are not…

Continue ReadingHow to edit post or product URL

How to copy paste from Excel

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To copy from excel, go to the spreadsheet in Excell and copy what you need from a specific cell, row, column, and then go to Sheet Editor and…

Continue ReadingHow to copy paste from Excel

How to copy paste images

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To copy/paste images from one cell to another, just copy from one cell and then paste into another cell using CTRL + C and CTRL + V

Continue ReadingHow to copy paste images

How to edit images as plain text/URLs

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To edit images as plain text/URLs, you need to go to the cell you want to edit and double click it; it converts into a plain text field…

Continue ReadingHow to edit images as plain text/URLs

How to create a new column

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

For most cases, our spreadsheet will recognize all the columns in the spreadsheet immediately if you go to Settings > Scan DB. This action will show all the…

Continue ReadingHow to create a new column

How to save changes faster

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

Sheet Editor saves products in batches, so if you want to increase the number of products to save in each batch go to the spreadsheet and click on…

Continue ReadingHow to save changes faster

How to show cells as simple texts

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To show date columns as simple texts, you need to go to settings > Show cells as simple text.

Continue ReadingHow to show cells as simple texts

How to hide a column

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To hide columns from the spreadsheet, you need to right-click on the column you want to hide and click “Hide column”. You can also use the Columns Manager…

Continue ReadingHow to hide a column

How to display a new column in the spreadsheet

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To display hidden columns in the spreadsheet, go to settings > Hide / Display / Sort columns. Drag the disabled columns to the enabled columns.

Continue ReadingHow to display a new column in the spreadsheet
  • Go to the previous page
  • 1
  • …
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • …
  • 31
  • Go to the next page

Help

  • Guides and Tutorials
  • FAQ
  • Technical support
  • Request refund
  • My account

Product

  • AI
  • Google Sheets Sync
  • All Spreadsheets
  • Features
  • Testimonials and reviews
  • Changelog
  • Suggest new features

Company

  • Company
  • Contact Us
  • Development services
  • Affiliate Program
  • Sitemap
  • Privacy Policy of our Google Sheets Sync service
  • Privacy Policy of the Bulk AI API

Guides

  • How to Export WooCommerce Failed Orders to CSV File
  • How to Find and Export High-Value Orders in WooCommerce
  • Find WooCommerce Orders Placed by the Same Customer
  • Export WooCommerce Customers who Paid with PayPal or Stripe
  • Import WooCommerce Prices and Stock from FTP Server
  • License
  • Privacy Policy
  • Cookies
  • Terms and Conditions
Copyright © 2016 - 2025 VegaCorp S.A. de C.V. All Rights Reserved. Sheet Editor® is a registered trademark.
Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
  • Manage options
  • Manage services
  • Manage {vendor_count} vendors
  • Read more about these purposes
View preferences
  • {title}
  • {title}
  • {title}