Archive for the 'Beginner' Category

Inserting comments

Download example commenting.xls Description You will learn how to insert comments, hide comments, always show comments, format your comments, and delete them. Menu Link Insert > Comment

Paste Special

Download example paste-special.xls Description Paste special is used for only pasting specific information like formulas, numbers only, and performing on the fly addition, subtraction, multiplication, and division. Alternate Route Edit > paste special…

Borders and Shading

Download example shading-borders.xls Learn how to create simple yet effective borders and advanced shading.

Freeze Panes

Download example freeze-panes.xls Description This is so easy to perform and very helpful with large amounts of rows and columns. Menu Link Window > Freeze Panes

Cut and Paste

Download example cut.xls Short cut Cut = ctrl+x Paste = ctrl+v Alternate Route Edit > Cut Edit > Paste