Copy a table or table text from another program in Publisher (2024)

Publisher for Microsoft 365 Publisher 2021 Publisher 2019 Publisher 2016 Publisher 2013 Publisher 2010 Publisher 2007 More...Less

Copy a table or spreadsheet from Word or Excel

  1. Open the table or spreadsheet you want to copy.

  2. Select the cells you want, and then press CTRL+C to copy them.

  3. Open Publisher.

  4. Press CTRL +V to paste the cells.

    The copied table or spreadsheet appears in Publisher as a table.

Note:Publisher has a limit of 128 rows and 128 columns in a table. If you try and import or copy a table into Publisher that exceeds those limits, Publisher will prevent you from importing or copying the table. Reduce the number of rows and columns in your data before trying to import or copy the table into Publisher,

Copy table text from any Microsoft Windows-based program

  1. Open the program that contains the text you want.

    If the text isn't already in a table, press TAB between each entry in a row, and ENTER at the end of each row.

  2. Select the text, and then press CTRL+C to copy it.

  3. In Publisher, click Insert > Table > Insert Table.

  4. In your publication, click where you want the table to appear.

    The Create Table dialog box will appear.

  5. Enter the number of rows and columns you want, and then click OK.

  6. Click inside the table where you want the upper-left cell of the copied text to appear.

  7. Click Home > Paste > Paste Special.

  8. In the As list, click Table Cells Without Cell Formatting, and then click OK.

Need more help?

Want more options?

Discover Community

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Copy a table or table text from another program in Publisher (2024)

FAQs

Copy a table or table text from another program in Publisher? ›

Formatting attributes like color and fill can be copied from one object to another. To do so, click on the object whose attributes you wish to copy. Select Format Painter under the Clipboard group of the Home tab. After that, click on the object you want to paste the attributes to.

How do I copy and paste in Publisher without losing formatting? ›

Formatting attributes like color and fill can be copied from one object to another. To do so, click on the object whose attributes you wish to copy. Select Format Painter under the Clipboard group of the Home tab. After that, click on the object you want to paste the attributes to.

How do I copy and paste a table from one document to another? ›

Copy a table and paste it in a new location
  1. In Print Layout view, rest the pointer on the table until the table move handle. appears.
  2. Click the table move handle to select the table.
  3. Do one of the following: ...
  4. Place the cursor where you want the new table.
  5. Press CTRL+V to paste the table in the new location.

How do I copy formatting from another table? ›

Select the cell with the formatting you want to copy. Select Home > Format Painter. Drag to select the cell or range you want to apply the formatting to. Release the mouse button and the formatting should now be applied.

How do I copy and paste from one Publisher document to another? ›

Hold down SHIFT and click the objects you want to copy. Right-click the objects and click Copy. Right-click where you want to copy the objects, and under Paste Options, click Paste.

How do I copy and paste without copying formatting? ›

Paste Text Without Formatting
  1. Mac: Cmd + Shift + V.
  2. Windows: Ctrl + Shift + V.
Feb 22, 2023

How do I copy one table from another? ›

You can use INSERT INTO statement in any of RDBMS (Oracle, PostgreSQL etc.) for copying data from one table (source table) to another (destination table). Syntax: INSERT INTO <destination table> (column1, column2, ...., columnN)

How to copy and paste a table of contents? ›

Select Edit > Copy to copy the TOC. You can also use CTRL+C or the Copy toolbar button for this operation. 5. Select Edit > Paste to paste the TOC.

Which command is used to copy data from one table to another? ›

The INSERT INTO SELECT statement copies data from one table and inserts it into another table. The INSERT INTO SELECT statement requires that the data types in source and target tables match. Note: The existing records in the target table are unaffected.

How do you copy a table style from one workbook to another? ›

Open the workbook that you want to copy the styles into. next to the cell styles box that contains previews of styles. Click Merge Styles. In the Merge Styles dialog box, in the Merge styles from box, click the workbook that contains the styles that you want to copy, and then click OK.

How do I copy a table from one spreadsheet to another? ›

Here's how:
  1. Select all the data in the worksheet. Keyboard shortcut: Press CTRL+Spacebar, on the keyboard, and then press Shift+Spacebar.
  2. Copy all the data on the sheet by pressing CTRL+C.
  3. Select the plus sign to add a new blank worksheet.
  4. Select the first cell in the new sheet and press CTRL+V to paste the data.

How to keep formatting when copying and pasting? ›

Set default paste options
  1. Go to File > Options > Advanced.
  2. Under Cut, copy, and paste, select the down arrow for the setting to change. Pasting within the same document When you paste content into the same document from which you copied the content. ...
  3. Each setting has options you can set: Keep Source Formatting. ...
  4. Select OK.

How do I copy and paste with exact format? ›

To apply the formatting you copied to a different text selection: Press Ctrl + Alt + v (Windows or Chrome OS) or ⌘ + Option + v (Mac).

What is the shortcut to copy and paste but keep formatting? ›

PCs:
  1. Keep Source Formatting will preserve the text as you copied it (keyboard shortcut: CTRL + K after pasting)
  2. Merge Formatting will force the text you're pasting to match the text around it (keyboard shortcut: CTRL + M after pasting).

How do you copy and paste without changing formatting in docs? ›

Now, let's move on to the main focus of this guide: preserving formatting when pasting content into Google Docs.
  1. Open Google Docs. ...
  2. Copy the Content You Want to Paste. ...
  3. Right Click on Your Mouse. ...
  4. Click on "Paste Without Formatting" ...
  5. Your Content Will Be Pasted.
Jul 22, 2024

Top Articles
5 Mortgage REITs for Yield-Hungry Investors
Chapter 13 Bankruptcy Timeline | Sirody & Assoc.
Craigslist Niles Ohio
FFXIV Immortal Flames Hunting Log Guide
Mileage To Walmart
Txtvrfy Sheridan Wy
Boggle Brain Busters Bonus Answers
Best Theia Builds (Talent | Skill Order | Pairing + Pets) In Call of Dragons - AllClash
Hallowed Sepulchre Instances &amp; More
Our Facility
Https://Gw.mybeacon.its.state.nc.us/App
Leeks — A Dirty Little Secret (Ingredient)
Labor Gigs On Craigslist
Ess.compass Associate Login
Honda cb750 cbx z1 Kawasaki kz900 h2 kz 900 Harley Davidson BMW Indian - wanted - by dealer - sale - craigslist
Band Of Loyalty 5E
Hobby Stores Near Me Now
Ceramic tiles vs vitrified tiles: Which one should you choose? - Building And Interiors
Обзор Joxi: Что это такое? Отзывы, аналоги, сайт и инструкции | APS
Avatar: The Way Of Water Showtimes Near Maya Pittsburg Cinemas
Pensacola Tattoo Studio 2 Reviews
Bj타리
Table To Formula Calculator
Wku Lpn To Rn
Unity Webgl Car Tag
Mjc Financial Aid Phone Number
Funky Town Gore Cartel Video
Wells Fargo Bank Florida Locations
Street Fighter 6 Nexus
Fairwinds Shred Fest 2023
CARLY Thank You Notes
Scanning the Airwaves
Trizzle Aarp
Mixer grinder buying guide: Everything you need to know before choosing between a traditional and bullet mixer grinder
The Holdovers Showtimes Near Regal Huebner Oaks
Omaha Steaks Lava Cake Microwave Instructions
Armageddon Time Showtimes Near Cmx Daytona 12
Craigslist Boats Dallas
Promo Code Blackout Bingo 2023
Anthem Bcbs Otc Catalog 2022
Citizens Bank Park - Clio
Brown launches digital hub to expand community, career exploration for students, alumni
Autozone Battery Hold Down
Truck Works Dothan Alabama
Craigslist Pet Phoenix
Lorton Transfer Station
3367164101
A jovem que batizou lei após ser sequestrada por 'amigo virtual'
Bradshaw And Range Obituaries
The Plug Las Vegas Dispensary
What Responsibilities Are Listed In Duties 2 3 And 4
Latest Posts
Article information

Author: Domingo Moore

Last Updated:

Views: 6298

Rating: 4.2 / 5 (73 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Domingo Moore

Birthday: 1997-05-20

Address: 6485 Kohler Route, Antonioton, VT 77375-0299

Phone: +3213869077934

Job: Sales Analyst

Hobby: Kayaking, Roller skating, Cabaret, Rugby, Homebrewing, Creative writing, amateur radio

Introduction: My name is Domingo Moore, I am a attractive, gorgeous, funny, jolly, spotless, nice, fantastic person who loves writing and wants to share my knowledge and understanding with you.