1 min readfrom 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?

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.

submitted by /u/NefariousnessLate275
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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