PC Review


Reply
Thread Tools Rate Thread

Chancing Excel worksheet

 
 
=?Utf-8?B?U2VyZ2lvIFRhbWFzc2lh?=
Guest
Posts: n/a
 
      15th Aug 2007
Chancing Excel worksheet

I have 240 filled excel worksheets. I need to change 1 formula over 1 cell.
I can open 1 by 1 and chance de formula. I will appreciate if some one could
help me to do it automatically.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?S2VpdGhsbw==?=
Guest
Posts: n/a
 
      15th Aug 2007
If the formula you wish to change is the same cell or range of cells in all
the sheets, you can select all the sheets (shift and click to select a
contiguous range of sheets, or Ctrl and click to select a non-contiguous
range of sheets), and make your change once, and it will automatically be
made on all the sheets you selected.

Hope this helps,

Keith

"Sergio Tamassia" wrote:

> Chancing Excel worksheet
>
> I have 240 filled excel worksheets. I need to change 1 formula over 1 cell.
> I can open 1 by 1 and chance de formula. I will appreciate if some one could
> help me to do it automatically.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
data from excel worksheet update with another excel worksheet tonycd Microsoft Excel Worksheet Functions 8 18th May 2009 09:14 AM
data from excel worksheet update with another excel worksheet tonycd Microsoft Excel Worksheet Functions 0 18th May 2009 04:54 AM
Chancing Excel worksheet =?Utf-8?B?U2VyZ2lvIFRhbWFzc2lh?= Microsoft Excel Misc 2 15th Aug 2007 09:30 PM
chancing numbers in contacts =?Utf-8?B?U2Vuc2F5?= Microsoft Outlook VBA Programming 0 20th Aug 2005 11:21 PM
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet Ant Waters Microsoft Excel Programming 1 3rd Sep 2003 11:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:33 PM.