What is the work of option (across worksheets) in Microsoft Excel 2003?
There is an option in the edit menu by the name of "Fill" and under that another option you can see its name is "Across worksheets" can someone plz tell me what does that option work?
First, "tutoring" is a troll sending people to web sites that load trojans. Don’t click the link.
To answer your question, that feature is so that you can copy something to all of your sheets at one time. Example: if you have a formula on sheet 1 that you will also use on Sheets 2 thru 100 (or whatever number of sheets you have) then rather than type the formula over on multiple sheets, you can use this feature.
Example:
On sheet 1, cell a1, i put a formula that says =b1+b2 and I want to put that formula on all the sheets. So hold your shift key down then take your mouse and click on the last sheet (let’s say you have 3 sheets so click on sheet 3 while holding the shift key down). This selects all sheets into a group. Now click in the cell a1 (the one we’re trying to copy), right click select copy, now click the fill/across worksheets, select all, and there you go it copies that to all sheets.
September 28th, 2009 at 11:30 pm
First, "tutoring" is a troll sending people to web sites that load trojans. Don’t click the link.
To answer your question, that feature is so that you can copy something to all of your sheets at one time. Example: if you have a formula on sheet 1 that you will also use on Sheets 2 thru 100 (or whatever number of sheets you have) then rather than type the formula over on multiple sheets, you can use this feature.
Example:
On sheet 1, cell a1, i put a formula that says =b1+b2 and I want to put that formula on all the sheets. So hold your shift key down then take your mouse and click on the last sheet (let’s say you have 3 sheets so click on sheet 3 while holding the shift key down). This selects all sheets into a group. Now click in the cell a1 (the one we’re trying to copy), right click select copy, now click the fill/across worksheets, select all, and there you go it copies that to all sheets.
References :