If I wanted the same formulas to be in several worksheets, worksheets that already contained too much other data or content that makes simply copying the worksheet impractical, is there a way to do this (Othan than copy pasting it into each worksheet)?
For example, I want the formulas found in A30:C31 to be in A30:C31 on another 10 worksheets.
Thanks.
Enter data in multiple worksheets at the same time. As an example, let's say you want to put the same title text into different worksheets. One way to do this is to type the text in one worksheet, and then copy and paste the text into the other worksheets. If you have several worksheets, this can be very tedious.
An easier way to do this is to use the CTRL key:
1.Start Excel. A new, blank workbook appears.
2.Press and hold the CTRL key, and then click Sheet1, Sheet2, and Sheet3.
3.Click in cell A1 in Sheet1, and then type:
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Thank you very much Blake! So simple! So elegant!
Can't wait to get into work and try it tomorrow...
I'm a very sad man. :P
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks