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
The most useful autofill feature in Microsoft Excel is probably the Series autofill. If you want to do something simple like a number sequence 1,2,3 etc, enter 1 in the first cell, select the range you want to fill, including … Read More
There are some autofill features in Microsoft Excel, which automatically populate cells based on copying data. If you want to duplicate data down the cells in a column, select the group of cells in the column, including the entry to … Read More
If you need to find or change something in your spreadsheet, you can use the Find and Replace feature. To find some data/text info, press Control + F and type in the info you are trying to find. Press Enter … Read More
Select your cells first, copy with Control + C, or cut them with Control + X, and then move to the destination cell(s) and paste them with Control + V. But there is a very handy shortcut if you just … Read More
A great way of finding specific things in an Excel spreadsheet is with Go To Special. Press Control + G for the Go To dialogue box, then press Alt + S for the Go To Special list. In here you … Read More