Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
Marc[_2_] Marc[_2_] is offline
external usenet poster
 
Posts: 1
Default I need help with locking or protecting cells.

I use Excel to import data into my proposal software. I format the data add
description off of vendors web sites. I have the browser open in the top
half of the screen and Excel in the bottom. When I C&P the data into the
cell it expands to the size of the data and the one cell now fills the
screen. No I have to size the cell back to the original size. Can I lock
the cell size byt still C&P into the cell.

Thanks,

Marc


  #2   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default I need help with locking or protecting cells.

The first thing to do when creating a table of this sort is to turn off auto
resizing. On the Table tab of Table Properties, click Options and clear the
check box there, or use Table | AutoFit | Fixed Column Width.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Marc" wrote in message
ink.net...
I use Excel to import data into my proposal software. I format the data

add
description off of vendors web sites. I have the browser open in the top
half of the screen and Excel in the bottom. When I C&P the data into the
cell it expands to the size of the data and the one cell now fills the
screen. No I have to size the cell back to the original size. Can I lock
the cell size byt still C&P into the cell.

Thanks,

Marc



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking/Protecting LawFirmTechie Tables 1 July 19th 06 03:27 AM
Protecting Cells Baggy Tables 2 March 26th 06 11:45 PM
Protecting cells The Big Smelly Ogre Tables 2 March 2nd 06 04:31 PM
Protecting certain cells in a table HT New Users 1 September 2nd 05 06:37 AM
protecting cells in a table DeniseD Tables 1 February 10th 05 04:52 PM


All times are GMT +1. The time now is 03:41 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"