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
You can explore a data block, or jump to the next data block, wherever it is, using the Control + Arrow keys. This shortcut moves to the edges of a block of data, or it jumps to the next block of data, … Read More
To jump to any cell in an Excel spreadsheet by press Control + G or F5, enter the cell reference and press Enter. Press Tab in the Go To dialogue box to get a history of where you have jumped … Read More
The general Select All shortcut is used in Excel spreadsheets. But it behaves differently depending on where you are in a spreadsheet. If you are on a cell within a block of data, Control + A will just select the … Read More