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
Understanding SSO (Single Sign On) in Node.js
Knowing East Devon summary - Economy - East Devon
Worcester Weather Underground
Tyler Sis 360 Louisiana Mo
Http://N14.Ultipro.com
New Slayer Boss - The Araxyte
Minn Kota Paws
270 West Michigan residents receive expert driver’s license restoration advice at last major Road to Restoration Clinic of the year
Magic Mike's Last Dance Showtimes Near Marcus Cedar Creek Cinema
Fire Rescue 1 Login
Www.paystubportal.com/7-11 Login
Miami Valley Hospital Central Scheduling
1Win - инновационное онлайн-казино и букмекерская контора
What Time Chase Close Saturday
Aspen.sprout Forum
ocala cars & trucks - by owner - craigslist
Springfield Mo Craiglist
10-Day Weather Forecast for Florence, AL - The Weather Channel | weather.com
Define Percosivism
SF bay area cars & trucks "chevrolet 50" - craigslist
Persona 5 Royal Fusion Calculator (Fusion list with guide)
Self-Service ATMs: Accessibility, Limits, & Features
Ezel Detailing
Lisas Stamp Studio
2013 Ford Fusion Serpentine Belt Diagram
Cain Toyota Vehicles
Aliciabibs
Gs Dental Associates
Tim Steele Taylorsville Nc
Mini-Mental State Examination (MMSE) – Strokengine
Craigslist Texas Killeen
How does paysafecard work? The only guide you need
Exploring TrippleThePotatoes: A Popular Game - Unblocked Hub
2012 Street Glide Blue Book Value
Maybe Meant To Be Chapter 43
Agematch Com Member Login
Retire Early Wsbtv.com Free Book
Avance Primary Care Morrisville
Mta Bus Forums
Craigslist Boats Eugene Oregon
Ticket To Paradise Showtimes Near Marshall 6 Theatre
9 oplossingen voor het laptoptouchpad dat niet werkt in Windows - TWCB (NL)
Wal-Mart 140 Supercenter Products
Www.craigslist.com Waco
Mybiglots Net Associates
Gander Mountain Mastercard Login
Craiglist.nj
786 Area Code -Get a Local Phone Number For Miami, Florida
Denys Davydov - Wikitia
Overstock Comenity Login
Acellus Grading Scale
Invitation Quinceanera Espanol
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.