•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
When I copy and paste a table from excel into word, the formatting keeps getting changed. Any ideas?
Our take
Copying and pasting tables from Excel to Word can often lead to frustrating formatting issues, especially when you've manually arranged cells to mimic a table layout. In your case, it sounds like the formatting you carefully applied—highlighting input and calculation cells with conditional formatting—is being lost in translation. This can happen when Word interprets cell formatting differently than Excel.
I have a block of cells in Excel, which look like a table ofcourse but I didn't actually use the table function built in to excel, I just arranged some cells to look like one.
In this table, many of my cells are marked as input or calculation cells so to help direct the user to the key areas of interest. I also have conditional formatting for the same reason.
When I highlight the whole table and then copy and paste into Word, the formatting keeps being changed. Cells that weren't formatted as input cells suddenly appear to be that way. It makes no sense!
I've attached images in the comments.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel table colours changing when copied into email after recent updateJust wondering if anyone else is having a problem with their Excel table colours changing when copied into an email? I have multiple workbooks I’ve used for years where the formatting has not changed. But about 3-4 weeks ago, I noticed the colours of the tables copied into emails changing. I use standard stock blue tables and now they appear purple or teal in outlook and gmail. It's affecting both my home and office PCs. I’ve been using Ron de Bruin’s Excel-to-HTML copy/paste converter for years and this has never happened before. The problem persists if I copy/paste them manually. Has anyone else run into this, or found a reliable workaround? I've tried using all the different themes and colour choices but no luck. I am on Office 365 on both machines; the office one is the standard subscription and my personal account is the insider version. Any suggestions much appreciated. submitted by /u/carnasaur [link] [comments]
- Pasting to Excel isn't working correctly - updating text to column makes it worseI've been copying and pasting data into excel the past few weeks just fine, but recently it takes every line break as a new cell. I've tried resetting the text to column fields like everyone suggests, but all it does is keep the top row of my text. The other rows just disappear. submitted by /u/xturvr [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel#Word#copy and paste#formatting#table#input cells#calculation cells#conditional formatting#cells#user#areas of interest#arranged#images#comments