Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-29-2016, 03:57 PM
cloa513 cloa513 is offline Is there a one step way of inserting cells with contents Windows 7 32bit Is there a one step way of inserting cells with contents Office 2007
Novice
Is there a one step way of inserting cells with contents
 
Join Date: Dec 2009
Location: Japan
Posts: 17
cloa513 is on a distinguished road
Default Is there a one step way of inserting cells with contents

I can't see any one step way of copying a block of cells (initially a part of a column) then inserting them. You seem to need insert cells that you want to post in and then paste the cells with contents onto those new cells. Its a bit of nuisance when you have to do that eight times. Is there a way?
Reply With Quote
  #2  
Old 09-29-2016, 06:41 PM
macropod's Avatar
macropod macropod is offline Is there a one step way of inserting cells with contents Windows 7 64bit Is there a one step way of inserting cells with contents Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you select part of a column or row, then paste the copied cells to:
• another location in the table, where there are sufficient cells (empty or not) to accommodate the copied data, the data will be pasted into the existing column or row;
• another location in the table, where there are insufficient cells (empty or not) to accommodate the copied data, the paste will add as many new columns or rows as are required to accommodate the pasted data; or
• an end-of-row marker, or immediately before the first paragraph following the table, a new set of cells will be added to the table.

If you copy an entire column or row, then paste the copied cells to:
• the start of another column or row in the table, the data should paste as a new column or row;
• somewhere in the table other than the start of another column or row, the paste will add as many new columns or rows as are required to accommodate the pasted data; or
• an end-of-row marker, or immediately before the first paragraph following the table, a new set of cells will be added to the table.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a one step way of inserting cells with contents Copy a cell's contents across many cells cloa513 Word Tables 13 09-19-2016 11:11 PM
How to merge two columns & replace contents of cells conditionally? mag Excel 3 10-24-2012 01:07 PM
Is there a one step way of inserting cells with contents Can I bring contents of slide step-by-step yabi PowerPoint 1 12-17-2011 03:13 AM
Is there a one step way of inserting cells with contents Concatenate/merge contents of multiple cells PSYloco Excel 2 05-14-2011 03:46 PM
Trouble Inserting Cells ebolton Excel 4 07-21-2010 11:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft