Examples of using Active worksheet in English and their translations into Thai
{-}
-
Colloquial
-
Ecclesiastic
-
Ecclesiastic
-
Computer
A: In the Scope drop-down list, you can choose the active worksheet.
Delete or remove all blank rows from active worksheet, selected worksheets or whole workbook.
You can quickly unhide all the hidden ranges in active worksheet.
Selects all cells on the active worksheet with a formula that produce an error value such as DIV/0!, N/A.
This handy feature will quickly insert page breaks after every specified number of rows in the active worksheet.
How to use Command Button to save active worksheet as PDF file in Excel?
Click any cell in the active worksheet, and you will see the logo or image has been inserted as header or footer. See screenshot.
B: All page setup settings of the current or active worksheet will be listed in here.
With this utility, you can easily print only odd or even pages, or the specified range of pages in active worksheet.
This utility can print all pages of active worksheet in backward order by only one click in Excel.
With this feature, you can one click to quickly add borders to each page in the active worksheet in bulk.
Quickly copy the page setup setting from active worksheet to the other worksheets in the same workbook.
With Select Last Cells utility, you can quickly find and locate the last used cell of the used range in active worksheet.
Then press F5 key to run the code, all data in the active worksheet are split into multiple worksheets by the column value.
After finishing the settings, click Apply or Ok button, and the text watermarks have been inserted into the active worksheet, see screenshot.
This feature will reverse the printing order and print the active worksheet from the last page to the first one with only one click.
Quickly insert complete content of worksheet, CSV file, text file or PRN file into current cursor position of active worksheet.
It can list all links(external reference) of the active worksheet and break all broken links by replacing it with appreciate value in Excel.
This smart feature will resize all comments to fit their contents accordingly in bulk in active worksheet or the entire workbook.
Quickly make multiple copies of the active worksheet, or to insert multiple worksheets with customized worksheet names into your workbook.
Quickly convert a range(and the graphic objects displayed in the range) of the active worksheet to an image in Gif, JPEG, TIF or PNG format.
Use the print settings from the current worksheet: with the option, the page setup of the multiple selections will be the same as the current active worksheet.
But Kutools for Excel's Print Pages in Reverse Order can reverse the printing order, and print active worksheet from last page to the first one with only one click in Excel.
List all columns(in active worksheet): you can click on the column letter to quickly go to the specific column in the active worksheet(click for details);
With this tool, you can quickly delete blank rows in the selected range, selected worksheets, active worksheets, and all worksheets. .
Click the Kutools Plus> Printing> Print Pages in Reverse Order, and then all pages in active worksheets are printed from the last page to the first one immediately.
With this feature, you can one click to reset all comments back to the default positions in the active worksheet or the whole workbook immediately.
This feature will save you time greatly to batch add, remove, and change user names in all comments of the active worksheet or the entire workbook.
Supposing you have to import or insert data from text files(such as CSV file, text file or PRN file) in the cursor position(to start insert the data from a cell) of the active worksheet in Excel, you can do it easily as following steps.
Active the worksheet and select the range you want to convert the cell contents to comments.