Title: Copy/Paste Background colour
Last modified: February 28, 2024

---

# Copy/Paste Background colour

 *  Resolved [knowlych](https://wordpress.org/support/users/knowlych/)
 * (@knowlych)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/copy-paste-background-colour/)
 * Hello, we are trying to copy and paste a larger table from Excel into your simple
   table. The text and numbers are pasting, but the background color is missing.
   There are various colors involved. Is there a trick to retain the background 
   colors in the copy-paste process?
 * Thanks and best regards,
   David
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcopy-paste-background-colour%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/copy-paste-background-colour/#post-17476379)
 * Hello,
   To begin, I want to extend my heartfelt apologies for the delayed reply,
   which is due to an unexpectedly high volume of inquiries.
 * We truly value your patience during this period.
   I am sorry to disappoint you,
   but there is no way to pass any formatting or styling such as colors, font type
   etc, when you are copying the data from Excel to our Plugin.It can only paste
   the ‘raw values’.But you will be able to add custom colouring to columns/cells/
   rows in our Plugin.In [Simple Tables](https://wpdatatables.com/documentation/creating-new-wpdatatables-with-table-constructor/creating-a-simple-table-with-wpdatatables/)​,
   you can easily select multiple cells at the same time and set a background color(
   and text color) for the selected cells.An example screenshot if I want to color
   multiple cells in red background color at the same time.​
 * ​
 * ![](https://i0.wp.com/ticksy_attachments.s3.amazonaws.com/9625943372.png?ssl=
   1)
 * ![](https://i0.wp.com/ticksy_attachments.s3.amazonaws.com/9841003691.png?ssl=
   1)
 * ​So, you can use the Table’s Tools above to set text color and background color
   manually like that.
 * ![](https://i0.wp.com/ticksy_attachments.s3.amazonaws.com/1881974219.png?ssl=
   1)
 * 2. There are also ways with Custom CSS to add any styles you need.
 * If you wish to use CSS , here is an example if we wanted to set a custom Column
   Width.
 * You can add a CSS class directly in a cell of a table,  and then you can edit,
   for example, for cell number 1 :
 *     ```wp-block-code
       <div class="abc">Some text 123</div>
       ```
   
 * Then on the front end, we would add this custom CSS:
 * td .abc {  
 *  width: 350px;
 *  }
 * and this will change the column width on the front end.
 * It is a similar method to do any CSS rules that you wish to apply.
 * In order to apply this CSS,  you can either apply it directly to the WordPress
   page where the table is :
 * Custom code needs to be applied to the page where the booking form is. Depending
   on what you’re using (Gutenberg blocks, or some page builder), adding the CSS
   or JS can be done in a few different ways. 
 * If you need help with adding custom CSS to the page, please take a look at [this article](https://www.wpbeginner.com/plugins/how-to-easily-add-custom-css-to-your-wordpress-site/).
 * –
 * Or you can add this CSS in the main plugin settings/Custom JS and CSS/Custom 
   CSS.
 * If you need to ‘target’ only a specific Simple Table with ID, you can add the
   Table ID like this :​
 * #wpdtSimpleTable-2 td .abc {  
 *   width: 350px;
 * }
 * I hope that helps.

Viewing 1 replies (of 1 total)

The topic ‘Copy/Paste Background colour’ is closed to new replies.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [2 years, 3 months ago](https://wordpress.org/support/topic/copy-paste-background-colour/#post-17476379)
 * Status: resolved