Submitted by Jaymon Hung from the University of Toronto Scarborough
At everyone’s point in life, you will have to experience using the wonders of Excel. To be honest, Excel can be your best friend, but there are moments when little tricks that can make the word of a difference.
1. Multiple lines in a cell
Press Alt+Enter to start typing on a second line
To add a new line while typing in a cell, you will realize that it isn’t just the Enter key. Instead, while typing in a cell, hold Alt+Enter together to get that second line in a cell.
2. AutoFit row/column
Use keyboard shortcuts to auto-fit columns or rows
Has this happened to you? Your cell has excess space either with the row height or column width. Usually this would be a simple fix. All you would do is double-click the top row or column and the cell will adjust. However, what if this is the case for the entire worksheet, where you have thousands of cells?
This would be a cumbersome task to complete.
Well instead of suffering, all you would need to do is select all the cells, then Alt+H+O+A/I. Alternatively; you can select the Home Tab -> Format option -> AutoFit
3. Cell Merge
Make your Excel spreadsheets look better by merging cells
Got a cell that has a lot of text in it? Well you can leave it and have the text hover over the neighbouring cells. But why not make it look more aesthetically pleasing.
Cell merge provides the solution by combining the selected cells into one cell. All you need to do is select the cells, alignment, and then click the “Merge Cells” option.
4. Switching between worksheets in a workbook
Have you ever created an excel sheet that has a couple of worksheets in one Excel file? Normally, you can use your mouse to navigate through each sheet, but this does get tiring.
Why not use keyboard shortcuts and avoid having to leave the comfort of your keyboard? All you need to do is click Ctrl+PgUp/PgDn to scroll through multiple sheets in a workbook
5. Formula check
Reveal complicated formulas easily with this quick keyboard shortcut
We’ve all experienced the super complicated formulas in an Excel, all the IF statements or Vlookups. Sometimes we need to review the formula and make sure the according cells are included in the formula. A quick way to do that check is through F2 on your keyboard.
Select the cell you want to view and simply click F2. It will show all the cells included in the formula, as well as a breakdown of the formula.
it makes me happy koiwnng I have great fans like you who support my shows. Really glad to have you watching here on youtube. Thanks buddy =]