Lam: 25 Excel Shortcut Keys

Ya ndai gaw Excel hpe galaw ai shaloi grau na loi ai hku glaw mai ai 25 Excel Shortcut Keys mara dat ya ai re. chye sai nig aw hpa nra ai re tim n chye shi ai nye manaw manang ni na matu gaw grai nkyu nga na re ngu kam ai. Ndai zawn shortcut ni hpe chye lang mat wa jang gaw mouse the hkrai click na galaw ai wa hta manu mana lawan ai hku lu lagaw na re. chye ma chye n ging ai hpaji langai re nga ai. Mai na shaman mung gai shaman la ra ai re. chye gaw chye da na nalang shaman yang gaw hpa akyu nnga ai hku re, dai majaw chye da sai nga jang gaw galoi mung lawan ai hku na galaw lu na matu gaw gai shaman la ga ngu gahtap na tsun mayu ai hku re law.

Shortcut Keys to Manipulate & Edit Cells:
We all know how it can get frustrating working with hundreds and hundreds of cells in a worksheet. Here are a few shortcuts that can turn that frustration into jubilation!
[CTRL + 9] - Hide the currently active row
[CTRL + 0] - Hide the currently active column
[Shift + Spacebar] - Select the entire row

Useful when you're in a cell whose row you want to select

Shift+Spacebar does it for you!
[CTRL + Spacebar] - Select the entire column
[CTRL + - ] - Displays the Delete dialog box to delete the selected cells.

Now you can select and delete multiple cells without having touch the mouse!
[CTRL + 1] - open format dialog. I use this to set borders, fills, cell-formats, alignment etc.

Replaces the tedious Click Cell -> Right Click -> Format Cell series of clicks
[F4] - to repeat last action, like adding rows or adjusting formats.
[CTRL + D] - fills down.

Select the cells you want to fill. Make sure the first cell contains the basis for the rest.

This avoids the hassle of having to drag down multiple pages just to fill several cells.
[CTRL + Shift + $] - Formats the number in the current cell to currency format

Select the cells you want to change, then press CTRL+Shift+$
[CTRL + Shift + %] - Formats the number in the current cell to percentage format

Ensure that your values are in decimal value for proper conversion, similar to the values above (i.e 0.50 = 50%)
[CTRL + ' (apostrophe)] - Inserts the value of the cell above the current one into the currently selected cell
[CTRL + Shift + ; (semicolon)] - Enter the current time into the current cell
[CTRL + ; (semicolon)] - Enter the current date into the current cell
[Alt + = (equal sign)] - Inserts a formula in the current cell to add up all of the numeric cells above it (assuming no gaps)

Replaces the hassle of having to type the formula

Just ensure there are no gaps in between the cells

Keyboard Short Cuts to Help Navigate Excel:
Let's face it, only a handful of us are lucky enough to work with Microsoft Excel and only be working on 1 worksheet. The rest of us have to deal with around 5 worksheets in every Excel workbook we have open. How do we manage and navigate through these worksheets properly and easily?
[CTRL + Page up] - Jump to previous worksheet in the workbook
[CTRL + Page down] - Jump to next worksheet in the workbook
[CTRL + F6] - Jump to the next workbook you have open
[CTRL + F9] - Minimize the current workbook
[CTRL + F10] - Maximize the current workbook
[CTRL + W] - Closes the selected workbook
MS Excel Shortcuts we should've been taught a long time ago!
The next set of shortcuts is a set of shortcuts that you can't really categorize other than in the "I-wish-you-taught-me-these-sooner" category. As these shortcuts have no similarity other than they're quite really useful but are scarcely used.
[F9] - Shows the result of a part of a formula

Select the part of the formula you want to view the of

VERY VERY useful for long and complex formulas
[CTRL +F2] - Open Print Preview
[Shift + F3] - Launch the Insert Function dialog
[F7] - Launch the spell checker

Nobody wants to look like a fool in front of their bosses just because they can't spell "Failled" properly.
[F12] - Launch Save As to save the current document