Learn how to use basic Formulas for mathematical operations & insert Functions like sum, average, count, max, min, date, time, etc. in Excel.

Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, Alt+N to Insert, and so on. Once in a tab, additional letters appear for ...

Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.

You worked hard to put that Excel sheet together, now protect it from unintended damage.

Macros in Excel can perform functions like inserting pictures, copying data from one cell to another, etc. In order to write an effective macro to insert images in excel, you will need to use a loop.

Please note: This item is from our archives and was published in 2003. It is provided for historical reference. The content may be out of date and links may no longer function. Answering your ...

Let's say you're working in an Excel worksheet and realize that you need to insert additional rows of data. Luckily, Excel has a built in feature to allow users to insert multiple blank rows.