The shortcuts in this topic refer to the US keyboard layout. Keyboard shortcuts allow you to quickly complete commands and functions without using a mouse. A very important feature in Excel is the formula.This topic lists all keyboard shortcuts for the Office for Mac products. Microsoft for Microsoft Windows and Mac OS X.Select the table cell where you want your result. Insert a formula in a table cell. On the Table menu, click Formula. When complete, select Close and it will be available under the Insert.If your Word window is narrow, first click Data to open its menu, and then click Formula. ColumnsSelect Continue and the Equation Editor will be take a few minutes to install.One click will show all hidden columns in the used range, click again will set all hidden columns to be invisible. With this utility, you can quickly toggle hidden columns visibility with one click. Alternatively, on the Table menu, click Formula.One click to toggle hidden columns visibility in the used range. On the Layout tab, click Formula.
![]() To minimize the ribbon and hide the status bar Work AreaThis utility has embodied 3 types of working area settings in your Excel as follows: One click will toggle all hidden sheets to be visible, click again will toggle all hidden sheets to be invisible in the current workbook. This has not been verified with Equation Editor or Word for Mac.Quickly toggle all hidden sheets visibility in the current workbook. ![]() Unhide All Hidden Windows:Unhide all hidden workbooks with one click. Hide Inactive Windows:If you have opened multiple workbooks in Excel, this tool allows you to quickly hide all the other inactive workbooks with one click. Normally you have to unhide all hidden worksheets one by one in Excel. Unhide All Hidden Sheets:Unhide all hidden sheets of the active workbook with one click. For example, if you have a row data, such as: 1, 2, 3, you can quickly reverse its order horizontally to 3, 2, 1. This is a handy tool for you to handle a large workbook with a bundle of worksheets.Flip all cells in the selection horizontally with one click. Normally you have to hide or unhide the workbook and worksheet one by one in Excel. Hide/Unhide Workbooks and Sheets:Interactively hide or unhide multiple workbooks and worksheets at one time. For example, you may have a single column of data which contains your customer's information, and each customer consists of 5 rows information (such as, name, sex, Tel, Email, and Address). Transform Range:Quickly transform a vertical column into rows with multiple columns. Transpose Table Dimensions:With this handy Transpose Table Dimension utility, you can conveniently convert a cross (two-dimensional) table to a flat (one-dimensional) list at once, and vice verse. For example, if you have selected a column, containing the number 1, 2 and 3, this utility will reverse the order vertically to 3, 2, and 1. The formatting of cells will also be swapped, and the swap operation does not affect the formulas in the two ranges, and they continue referring to the original cells. You can quickly swap the cells or ranges on the same worksheet, on different worksheets or different workbooks. For example, you can't swap two columns with one column. The ranges for swapping must be identical in the same size. Swap Ranges:Quickly swap ranges, columns, rows, and cells in your workbook. ![]() This feature will set data validation for one or multiple selections simultaneously. Validate Phone NumberThis feature will quickly set data validation to accept only phone numbers entered in the specified format. Validate IP AddressThis feature will quickly set data validation to accept only IP address entries in the selected range(s). Only allow specific characters to be entered in a range of cellsThis feature is designed to set up data validation for selected range(s), which only allows Email addresses to be entered. Easily prevent special or certain characters from being typed in cells This utility achieves the same function as Excel's Data validation feature, but you just need to select a single column and then apply this utility, then you cannot type in duplicate values in the same column. Emulator for mac el capitanPicture Drop-down ListThis feature can help you create multiple drop down lists with their relative images with only several clicks. Colored Drop-down ListThis feature can help you color (add conditional formatting to) drop-down list vales or rows based on corresponding selected at ease. It supports to create 2-level drop-down lists, and 3-5 level drop-down lists. Does Microsoft Accept Formulas Update The 2Update Dynamic Drop-down ListThis feature helps to update the 2-5 level dynamic drop down list created by the Dependent Drop-down List feature of Kutools for Excel when the original data change. When you type the corresponding characters, only the matching items are displayed in the drop down list Create Simple Drop-Down ListThis feature will help you quickly add data validation (drop-down list) for the selections with only 2 steps in Excel. Searchable Drop-down ListThis feature helps to create a searchable drop down list. If you enable this feature, you can tick the check boxes to select multiple items from the drop-down lists. Drop-down List with Check BoxesThis feature will add a check box before each list of the drop-down list in the data validation (drop-down list) range. Multi-select Drop-down ListAfter enabling this feature, you can select multiple items from the drop-down lists in the specified data validation (drop-down list) range. Convert to Date:With this utility, you can quickly identify and convert some non-standard date format which cannot be identifying by Excel as the normal data format. Convert Text to Formula:With this utility, it will convert formulas which have been stored as text format into real formulas. Convert Formula to Text:With this utility, you can easily convert formulas to text format in selection. It can also convert values in cells that are preceded by an apostrophe to the number. Video downloader for mac reviewsOne click to convert time to an hour only 4. One click to convert time to minutes only 3. One click to convert time to seconds only 2. Unit Conversion:Quickly convert measurements from one unit to another in your Excel. You can easily convert a single value or volume values from range cells, and get the latest exchange rates at any time by updating from the reliable website (requires an Internet connection). Currency Conversion:It's a handy currency utility, which brings you a quick way to convert more than 50 currencies in your Excel by using the latest exchange rates from the reliable Internet website. Convert between Roman and NumberWith this feature, you can quickly convert a range of Roman data to normal decimal numbers in bulk, and vice versa. For example, it can spell out the "12.75" to "Twelve Dollars and Seventy-five Cents". Number to WordsThis utility can spell out numbers into English and Chinese words in Excel. It includes converting binary to hex, octal to decimal, decimal to hex, ascii to hex, etc. Conversion of Number SystemsThis feature can quickly convert among different number systems with only several clicks, without using any formulas.
0 Comments
Leave a Reply. |
AuthorJared ArchivesCategories |