View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Nikolaus Nikolaus is offline
external usenet poster
 
Posts: 2
Default Change the column width

I press F5, selecting Objects , pressing enter and receive the message: No
objects found

what nnow?

"Socko" wrote:

You can solve your problem by preventing the objects from moving or
sizing with cells...

Select the object... If there more many objects, you can select them
all at once... Follow as given below...

Press F5 click on SPECIAL click option objects press
ENTER..

Once all objects are selected, keep mouse on any one of the objects,
right click the mouse Select FormatAutoShape select tab named
Properties click option "DONT MOVE OR SIZE WITH CELLS" press
ENTER.

Now you will be able to resize columns, rows and use formats as needed
on worksheet.

I hope this helps.

Selva V Pasupathy
For more on Excel, VBA, & other Resources
Please visit: http://socko.wordpress.com