Copy From Active to Last Selected Cell

Use this tool to copy the active cell to all other cells of a selection of cells.

In difference to the Build-In functions this tool allows to copy functions into two directions in one go. Use the Build-In function EDIT, FILL [Direction] alternatively. Use [Ctrl]+D to fill down, [Ctrl]+R to fill to the right. Choose other directions from the menu.

Tip: Use this tool in combination with other XLplus tools.

Enter the function into the first cell it is needed.

Run XLplus, Select Until Last to build a selection from the active to the last filled cell. Adjust the selection according to your needs by use of the keyboard.

Alternatively, run XLplus Last Row in Column or Last Column in Row. Press the [SHIFT] key prior to selecting one of these tools from the menu to select the area.

Run XLplus, Copy From Active to Last Selected Cell to fill all cells with this function.

 

 

 

 

Social Networks

Twitter Facebook studiVZ meinVZ schülerVZ MySpace deli.cio.us Google Bookmarks Mister Wong StumbleUpon Windows Live Yahoo! Bookmarks