Often it is very time consuming to switch to a specific cell with the scroll function. To jump to the last cell of a table column, select the top cell of the column. Then, move the mouse cursor to the lower bounding line of the selected cell. The cursor changes to an arrow. Now double-click on the lower bounding line and end up in the last cell of the respective tab column.
Excel: The fast cell jump
This trick works in all directions, depending on which boundary line of the selected cell you double-click. If you want to jump to the last cell of a table, press the key combination "Ctrl + End" on your keyboard. You reach the first tab cell (for example, A1) with the key combination "Ctrl + Pos 1". To jump to any cell of the worksheet, there are two simple ways.
Word: Address input automatically
If you press the key combination "Ctrl + G", an input field appears. Here, just type the cell reference, such as "C6", in the entry line under "Reference" and click on "OK". Even faster is the cell jump over the input line above the column name "A". Enter the desired jump destination, such as "F6", and confirm with "Enter."
Excel: line break in a cell
Open a blank Word document, and then click the File menu. Then select "Options" in the lower left corner and "Advanced" in the next window. Then scroll down to the "General" entry in the right-hand side of the window. Here you will find the entry field "Postanschrift". Enter your address data and confirm with "OK".
Also interesting is
To call up the stored address, move the cursor to the corresponding location in the document and go to the "Insert" tab. Here you select the menu "Fast blocks" and the option "Field" in the selection menu. In the following window, click on the entry "UserAddress" in the selection field under "Field names" and on "OK"
Often the fixed width of a cell is not sufficient to record a longer text. The manual line break in a cell is quickly done at the desired position with the key sequence "Alt + Enter". If you want Excel to do this work, automatically generate the break automatically, select the corresponding cells, rows, or columns, and press the key combination "Ctrl + 1."
The Format Cells menu is available. Here you select the "Orientation" tab and click on the "Line break" entry under the "Text control" option with a mouse click. Confirm your request with "OK."
Often it is necessary to comment on a text. Here you can use the commentary function of Word. Just select specific text passages, or place the cursor in the text, and go to the "Review" menu tab. Then click on the "New comment" option.
On the right-hand side of the document, a text box is generated, in which you can enter your comment. After reviewing the comment, it can be deleted. Click the right mouse button in the comment buttons and select "Delete Comment."
Whether in a contiguous area or distributed across the worksheet, the same content can be entered into multiple cells simultaneously without much effort. Select the relevant contiguous area. To mark individual, distributed cells or non-connected areas, use the mouse and hold down the "Ctrl" key. If the cells are visible, enter the term that should appear in all selected cells in the form field above the table structure (input field next to "fx"). Then press the key combination "Ctrl + Enter". All previously marked cells or cell areas receive the same entry.
If you want to write a text in multiple columns, start a new document and the Page Layout tab. Next to the "Columns" button, click the small arrow. Select the "Multiple columns" entry. Now you can choose an already prefabricated column variant under "presets" or enter the desired number next to "column number". To distribute column layout evenly across the page, place a checkmark next to the same column width.
When you type a break in Excel, such as "1/2" is automatically converted to a date, in our example "01.Feb". In order for a break to be displayed correctly, you must enter a "0" before the break, then a space and then the break. In our example "0 1/2". In the cell, the fraction is displayed correctly as "1/2", the decimal value is then visible as "0.5" in the form bar.
If the decimal number "1.5" appears in the break layout, enter "1 1/2" and so on. You can now also perform calculation operations in this display. Need an example? Enter the multiplication formula "A1 * B1" in cell "A1" "1 1/2", in cell "B1" "1 4/5" and in cell "C1". As a result you get "2 5/7". This fraction view is the counterpart to the decimal "1.5 * 1.8 = 2.7".
Word: Comment on text
Excel: Same content for cells
Word: Write in columns
Excel: Calculating with correct fractions
No comments:
Post a Comment