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.
EnjOy..=))
MamoOn..