Examples of using Close this code in English and their translations into German
{-}
-
Colloquial
-
Official
-
Ecclesiastic
-
Medicine
-
Financial
-
Ecclesiastic
-
Political
-
Computer
-
Programming
-
Official/political
-
Political
Then close this code, and click File.
Then close this code, and click File.
Save and close this code, click Design Mode to turn off the design mode.
Then save and close this code, and go to click View> Page Layout to view the result.
Then save and close this code, go back to the worksheet, and enter this formula.
Then save and close this code, and now, when you enter text values with some special characters in the range A1.
Then save and close this code, go back to your worksheet, type this formula =countnostrikeA2.
Then save and close this code, go back to your worksheet, and enter this formula:=isleapyear(A2), see screenshot.
Then save and close this code, and now when you try to print this specific worksheet, you will get the following warning.
Then save and close this code, go back to your worksheet, enter this formula=pivotexist("salereport") into a blank cell, see screenshot.
Step 3: Save and close this code, return to the worksheet, in a blank cell, enter the formula of=CreateDate(), and press the Enter key.
Then save and close this code, go back to your worksheet, and enter this formula=sortnumsincell(A1) into a blank cell next to your data, see screenshot.
And then save and close this code, go back to the worksheet, and enter this formula:=reversestr(A2) into a blank cell to put the result, see screenshot.
Then save and close this code, go back to your worksheet, in a blank cell, please enter this formula=Namerefersto("domains") into a blank cell, see screenshot.
Then save and close this code, when you enter“No” or other text in cell G1, Sheet1 is hidden, but if you enter“Yes” in the cell, Sheet1 is displayed at once, see screenshots.
Then save and close this code, now, when you enter duplicate values in cell A1:A1000, a warning message is popped out to remind you the duplicate entry is not allowed, see screenshot.
Then save and close this code, go back to your worksheet, and now, when you click the hyperlink in your pivot table, the hyperlink will be activated and link to its webpage.
Then save and close this code, go back to the worksheet, and enter this formula:=removespecial(A2) into a blank cell where you want to put the result, see screenshot.
And then save and close this code, go back to the worksheet, right click the Select All checkbox, and choose Assign Macro from the context menu, see screenshot.
Then save and close this code, now, when you click a hyperlink cell, the destination linked cell will be highlighted at once, when click another hyperlink, the first one goes back to normal.
Then save and close this code, go back to the worksheet, and now, when you enter the date into cell K4, the columns which date is less than this specific date will be hidden automatically.
Then save and close this code, go back to the worksheet, now, when you double click a cell between the data, a new row will be inserted below the active cell and the formula is auto filled as well.
Then save and close this code, and go to back the workbook, and now when you print one worksheet or the entire workbook, they will not allowed to be printed and you will get the following warning.
Then save the code and close this code, now, when you double click a cell once, a cross mark is inserted, and when double clicking a second time, a tick mark is displayed, see screenshot.
Then save and close this code, go back the worksheet, and now, when you enter some positive numbers into the cells you specified in the code, the positive numbers will be converted to negative ones automatically.
Then save and close this code, go back to your worksheet, type this formula=excstrike(B2:B14) into a blank cell, and press Enter key, and you will get the summation of all the numbers without the strikethrough cells.
Then save and close this code, return to your worksheet, and enter this formula=RowHeight(A1) into any blank cell of first row, then drag the fill handle down to the range cells which you want to display the row height of each row.
And then save and close this code, now, while clicking Save button to save this workbook, the modified header or footer content will be return to the original ones automatically if you have tried to change the header or footer, see screenshot.
Then save and close this code, go back to the worksheet, enter this formula=SplitText(A3,FALSE) into a blank cell to get the only the text string and then drag the fill handle down to the cells that you want to fill this formula.
Then save and close this code, go back to the worksheet and enter this formula:=easterdate(A2) into a blank cell beside your corresponding data, and then drag the fill handle down to the cells that you want to apply this formula, you will get some five-digits numbers, see screenshot.