There is a shortcut where you can go into more details on number formatting, for example, increase decimal places, change date format, etc. Press Control + 1 for the Format Cells dialogue. Then use Tab and Arrow Keys to move … Read More
Another type of number format, with a direct shortcut, is Scientific. The Scientific format is used for very large numbers. It displays a decimal number, followed by an E (for exponent), and then the power that the decimal number is raised … Read More
There are shortcuts to input the current date and the current time into cells. To enter the current date, press Control + ; (semi-colon). To enter the current time, press Control + Shift + : (colon). To insert the current date … Read More
To set Time format, select the cells and press Control + Shift + @. Although, if you use a colon between the numbers, such as 6:34, Excel will automatically treat it as Time format. As mentioned before, Screen Reader users can … Read More
To set Date format, select the cells and press Control + # You may not need this shortcut so much though, because Excel will automatically detect a date when input. For example, on our setup here, if we enter 6/2, … Read More
Percentage format will convert a decimal into a whole number percentage with no decimal places, and adds the percentage sign %. To set Percentage format, select the cells and press Control + Shift + % As mentioned before, Screen Reader … Read More
Currency format will add your regional currency symbol, put in comma separators for thousands, millions etc, and display two decimal places. It will also display red text for negative numbers. To set Currency format, select the cells and press Control + … Read More
Number format is similar to the General format but it puts in comma separators for thousands, millions etc, as well as displaying the two decimals places. To set Number format, select the cells and press Control + Shift + ! … Read More
General is the default number format setting for cells in Excel. Select the cells and press Control + Shift + ~ (Tilde). Note: The tilde character is a little wavy line and is generally found on a key to the right of … Read More
The general shortcuts for bold, italic and underline. They are Control + B, Control + I and Control + U. These work in Excel too! You can select text and change it when editing a cell. Or you can just … Read More