How to delete a column permanently
To delete a column permanently, go to settings > Hide / Display / Sort columns.Once there, hit the “X” in the column you want to delete permanently.If you…
To delete a column permanently, go to settings > Hide / Display / Sort columns.Once there, hit the “X” in the column you want to delete permanently.If you…
To import or export something on the spreadsheet, go to settings > advanced settings > Import / Export. Once there, select the import options: “Import from file” or…
If you want to load 500 rows at once in the spreadsheet, then you need to go to advanced settings, and then go to speed and performance. Note,…
To copy values between columns, you have two options: 1. Do it on the spreadsheet: Simply select the content from column 1 and then paste it on column 2…
To disable the loading of rows on scroll, Go to settings > Load more rows on scroll and leave it unchecked.
Go to the spreadsheet > Settings > Advanced settings > Customize features > Remove help messages from the cells.
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…
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…
To add extensions to the plugin, open the “Extensions” tool by clicking “Extensions” on the toolbar.
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…
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
To disable cells lazy loading, go to Settings > Advanced settings > Customize Features> Disable cells lazy loading?, and tick/untick the checkbox
To disable usage stats widget, go to settings > advanced settings > Customize Features> Disable usage stats widget?, and tick/untick the checkbox
To suspend object cache invalidation, go to Settings > Advanced settings > Solution to weird errors > Suspend Object Cache invalidation?, and tick/untick the checkbox
To disable extension offerings, go to Settings > Advanced Settings > Misc > Disable extension offerings? and tick/untick the checkbox
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…
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…
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 >…
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…
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 >…
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”…
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”…
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…
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…
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
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…
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…