excel
-
Excel - transferring the formatting of a cell to other cells
Excel - formatting with one click
apply to any number of cells
If you want to apply the formatting of a cell, whether text or graphics, etc. to other cells, this is very easy with the function "Transfer format"
The function can be found as a small brush symbol in the area Start> Clipboard ..... -
Fix or freeze Excel row
Fix or freeze Excel row
Anyone who works on larger tables with Excel knows the problem.
When scrolling down, for example, the relevant information in the column description disappears from the field of view.
In the case of large tables, it is not always immediately apparent which value belongs to which column assignment.
With Excel it is easy to quickly fix the top line or several, so that they always remain visible even when scrolling. -
Office - Ribbon quick access via keyboard shortcuts
Work faster with the MS Office ribbon keyboard shortcuts
The menu ribbon of the office programs Excel, Word etc. is extremely extensive. Again and again you move the mouse pointer to find the right function.
With keyboard shortcuts you are much faster here. But who can memorize them in view of the variety of functions.
Microsoft will have thought that too and has a very useful function ready, which of course does not only work in the Office package 2010 ...