Archive for the 'Fundamentals' Category

Arranging multiple windows or panes

Download example multiple-panes.xls Description Learn how to manage multiple windows at one time for optimal viewing. Menu Link Window > Arrange…

Inserting a picture

Description Learn how to insert any picture into excel in under 60 seconds. Download example Picture.xls Insert clipart You can insert clipart the same way… Insert > picture > clip art

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…

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