#1
|
|||
|
|||
Table Formatting Issue
I have a sheet with banking data in it and I converted the data to a table (for pivot table). The table was then formatted.
However, when I now copy data into the table, the format is applied to some of the cells, but not to all cells (see attached). I am copying the data directly from my online banking page on my pc and when I come to paste in excel, I only have one option = Paste. Any ideas? Tommy |
#2
|
|||
|
|||
As you anyway are coping data manually from web page, the simplest way is:
Have an empty sheet, and paste your data there; Copy data you just pasted, and PasteSpecial them as values into your table (be sure columns there are formatted properly); Clear all data from another sheet, so they don't mess you up when you get your next batch of data from web. |
#3
|
|||
|
|||
Thanks ArviLaanemets
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Irritating formatting issue in Table of Contents - page number "dots" disappear | Eriks | Word | 9 | 04-19-2019 06:18 PM |
Unexpected formatting issue | kcvinu | Word | 6 | 03-29-2017 02:26 PM |
Table style - first, last and odd column formatting issue | BartS | Word Tables | 2 | 08-16-2016 04:10 AM |
TOC Formatting Issue | Caroline | Word | 1 | 03-15-2011 01:59 PM |
TOC Formatting Issue | Angstromm | Word | 0 | 09-22-2010 11:49 AM |