Merge Cells in Table in Excel
We have a table with a list of students. Our example consists of three columns: Class, First name, and Last name. Because classes…
Category: examples
Replace Wildcard Characters in Excel
Wildcard characters such as a ? (question mark) and * (asterisk) are used to represent a single character or any number of characters….
Shortcut Key for Uppercase in Excel
Contrary to Word, Excel offers less advanced features when it comes to text modification. For example, there is no Change Case button. We…
Pivot Table Field Name not Valid
If you encountered the error with the very long text. The PivotTable field name is not valid. To create a PivotTable report, you…
Print on One Page in Excel
If you have a lot of data to print, there is no way you can fit it on one page. But there are…
How Many Rows and Columns in Excel
Excel worksheet consists of rows and columns. Rows run horizontally and are identified by numbers (1, 2, 3, 4, …). Columns run horizontally…
Standard Deviation Symbol in Excel
I used the standard deviation symbol in the lesson about calculating the z-score. There are a few ways you can add this symbol…
11+ Ways to Reduce Excel File Size
For most people who deal with small files, the reduction in file size is not that important. But for those who deal with…
Excel Formula Omits Adjacent Cells Error
The Excel formula omits adjacent cell errors that can occur with mathematical or statistical functions, such as SUM, AVERAGE, COUNT, MIN, and MAX….
Merge and Center Shortcut in Excel
There are a few ways to use the Merge & Center command in Excel. Accessing commands using a keyboard In the first method,…