Input fractions in Excel
How to input ordinary fractions in Excel.
How to align the autoshapes on the edges of cells.
How to do an indent while entering text to the cell
Make an indent while entering text to the cell in Excel.
Changing the direction of data entry
Changing the direction of data entry, when after pressing Enter, cursor move not to down, but to any other direction.
Cell with secret
How to hide the cell content without sheet protection.
Hint during filling in data into cell
Hint during filling in data into cell.
How to insert macros in Excel
How to insert macros in Excel.
Merging of two columns with data
How quickly merge data from two mutually non-overlapping columns with blank cells. Without any formulas, macros, etc. - only using mouse.
Quick jump between worksheets
How does quickly jump into required sheet in a workbook, if we have many sheets?
Hotkeys in Excel
Convenient table with hotkeys in Excel.
Filling in blank cells in the list
How quickly fill in blank cells in the column, inserting there values from higher cells.
Fast input todays date (TODAY)
Two quick ways to input today's date.
Autofill of cells
How to automatic fill in the cells.