How to copy a table and retain the table format

D

ddub25

Well-known Member
Joined
Jan 11, 2007
Messages
613
Office Version
  1. 2016
Platform
  1. Windows
I have a table formatted as a table. I have tried copying it to another location on the sheet, but only formulas, formatting etc are copied down. The table formatc with it drop down buttons does not get copied. How can I copy down the table format also?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
Sorry, question answered. I wasn't highlighting the entire table before copying as columns on the right were hidden. Excel obviously didn't realise I was copying a table and so only pasted formulas, formats etc.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
table with wrong selenium vba formatting
Replies
0
Views
123
cgpa
C
P
  • Question
Conditional Formatting based on table to calendar
Replies
1
Views
373
hajiali
H
O
  • Question
VBA Email Formatting - Charts and Tables
Replies
0
Views
473
oddzac
O
RoyalRife
  • Question
Excel is hard... I tell you hwhat!
Replies
2
Views
226
RoyalRife
RoyalRife
S
  • Question
Copy a specific range to another sheet without formatting, while preserving the formatting
Replies
0
Views
219
sofas
S

Forum statistics

Threads
1,203,681
Messages
6,056,708
Members
444,885
Latest member
Mark Prillman

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top