How to return a set number of consecutive numbers in Excel By combining ROW () and ROUND () with a couple of input values, you can create a very flexible consecutive numbering function.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

How to Insert a Return in an MS Excel Cell. The "Enter" key or "Return" key on your keyboard doesn't always work the same way in Microsoft Excel as it does in many other programs, where pressing ...

How to Sum a Column of Zeros in Excel. You can use the Sum function in Microsoft Office Excel to sum columns of data, whether your data is in an Excel table or is simply a range in a column of ...

You can insert or add Header and Footer in Excel spreadsheet using this tutorial. Insert page number, current date and time, etc.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.