Symbols and signs
Degree symbol
Degree symbol from menu, Insert to a cell btý formula or use keyboard shortcut to get the degree symbol.
Select
Select a row
Pressing SHIFT+SPACEBAR will select the entire row where the current activated cell is.
Select
Extend a selection
This is a simple but yet very useful shortcut. It extends a selection by a single cell. You cjoose the direction ov the extension by the arrow keys. Example: The shortcut is useful for example when you are working with Read more…
Select
Select cells containing data or the whole sheet
This shortcut will select cells in the whole worksheet if it is empty. If it contains information the shortcut will select the region that contains information except summary rows. Use the shortcut once again and all fields with information including Read more…
Data Entry
Delete one character or clear the active cell
This Data Entry shortcut has two functions. It can clear the information in a cell or it can delete one character at a time. Clear cells If you press BACKSPACE all information (characters and formulas) in the cell selected will Read more…
Select
Select all cells to the beginning
This schortcut will instantly select all cells used (any information in the cell) from the cell you have marked to the the beginning of the sheet (Cell A:1). The keys you use are: CTRL+SHIFT+HOME.
Select
Select an area with all used cells to the right and to the lower corner
This schortcut will instantly select all used (any information in the cell) cells from the cell you have marked to the last cell in the lower right corner of the sheet.
Select
Select cells containing data or the entire worksheet
This shortcut selects the entire worksheet if it does’nt contain any data. If there are data in the current cell the shortcut will select all cells with data in the same region. If you press CTRL+A again the entire worksheet Read more…
Text
How can I insert a new row/line in an Excel cell?
Is it possible to insert a new row inan Excel cell? Many people think of Microsoft Excel as an extended calculator but if you’ve dug into it a little bit you know it is much much more than that. To Read more…