Microsoft Excel Best Tips – Shortcuts

About Microsoft Excel

Microsoft Excel is the best office software for us. Microsoft Excel has the basic features of all spreadsheets. we work with daily. It is the best calculation application for windows operating system. it can display data as line graphs, histograms and charts. Excel forms part of Microsoft Office.

Microsoft Excel Best Ten Tips

1 – Summation of some numbers

Summation of some numbers in Excel with the shortcut key. First, enter numbers in Excel, After entering select all number in Excel. Then, press ALT + (Plus or Negative key)

Sum Function

Sum Function

Finally Sum Function

Finally Sum Function

2 – Inserting the correct Time

Ctrl + Shift + : (Colon)

Correct Time

Correct Time

3 – Inserting the correct Date

Ctrl + : (Colon)

Correct Date

Correct Date

4 – Highlighting a column

Ctrl + Space Bar

Highlighting a column

Highlighting a column

5 – Highlighting Row

Shift + Space Bar

Highlighting a row

Highlighting a row

6 – Removing the column

Ctrl + ) Close bracket

Removing column

Removing column

7 – Removing the Row

Ctrl + ( Open bracket

Removing the row

Removing the row

8 – New line in a cell

Alt + Enter Key

New line in cell

New line in cell

9 – Show your formulas

Ctrl + ~

Show your formulas

Show your formulas

Leave a Reply

Show Buttons
Hide Buttons