Forum Discussion

Jerry1385's avatar
Jerry1385
Copper Contributor
Feb 20, 2020

Excel table formatting best practices question

I am an Excel intermediate user. My issue is not easy for me to explain, perhaps if I had more knowledge with Excel I could to a better job. Therefore, I beg for your patience and thank you for same....
excel
Jerry1385's avatar
Jerry1385
Copper Contributor
Feb 20, 2020

PReaganThanks!

 

What if I copied and pasted the data to an existing table that was already formatted, how do I apply the same format to the data I pasted to either the bottom of the table or the top after a header row?

PReagan's avatar
PReagan
Bronze Contributor
Feb 21, 2020

Jerry1385

 

As in the pasted data has the new table's format? That could be:

  1. Ctrl + P to paste
  2. Ctrl > F (for formulas) or Ctrl > V (for values)

As a note... after pasting data, press Ctrl and explore through the list of paste options to see how you can format your data after pasting.

Resources