Sunday, March 19, 2017

Microsoft Excel 2010 Interface

At first; Microsoft Excel 2010 interface (screen) looks as divided into two parts; 1) Command buttons and 2) Worksheet; but; there are many other parts as well, if you have knowledge about them you will have an ease to read and understand whenever they referred- in any process either downloaded from internet, book or even by a teacher.

Below is a snap along-with parts names. Click to enlarge.

.

Friday, March 17, 2017

Add or Delete Cell Borders (Shortkeys)

Shortkeys to add or remove a cell or range of cells borders

Ctrl + H + B + S ... Border Outline on a selected range
Ctrl + Shft + 7 .... Border Outline on a selected range
Ctrl + H + S + A ... Border all cells on selected range

Ctrl + H + B +N  ... Clear/delete borders
Ctrl + Shft + -  ... Clear/delete borders

Example: