Excel for Microsoft 365 automatically creates one worksheet in each new workbook, but you can force it to create as many spreadsheets as you need.

Unfortunately, when you try to paste a series of cells with blank cells, the Paste special with Skip blanks option doesn't seem to work.

Using simple tricks, you can convert your Excel spreadsheet from a table with rows and columns to an interactive application that will help you represent the data more appealingly and conveniently.

Although Excel is used for calculating and presenting data, sometimes it is necessary to show the underlying formulas. Like Microsoft Word, Excel lets you use the Equation Editor to insert a beautifully designed math equation as a graphical object:

You can usually view formulas in an Excel cell when the cell is selected, but you can protect a spreadsheet by hiding the formulas in some cells.

Column letters and Row numbers are principal features of Excel spreadsheets. Using Column letter and Row number, you can address any cell - the main element in Excel.

When calculating the difference between two dates, you may want to exclude weekends and holidays. You can see how to calculate the number of Working Days between two dates for the usual, standard working week where weekends are Saturdays and Sundays.

Applying a number format to a cell doesn't change the value but only how the value appears in the worksheet. Formatting can play a joke with you, e.g., the sum of values seems incorrect because Excel displays a limited number of decimal places, and their sum is not equal to the real sum.

In some cases, you may want to change columns and rows in your data range for a more convenient and impressive view. Excel proposes a fast and simple way to change columns and rows in the data range.

To move around the worksheet with your keyboard, use the key combinations: