Tips and Tricks of Excel

Learn some most practical, simple and incredible Excel Tips. And, understand different aspect of spreadsheet making your life easier.

Filter Wildcard Characters

In this post, you are going to learn how to use wildcard characters in the filter to easily extracts.
We have a worksheet that has big data with multiple values in a column to know how many items payment we get in cash form.

Print Entire Sheet with Same Text

Is it Possible to Print the same text (headings) at Top of each Page or any Sheet? Yes, you can do it with the header/footer and Under Sheet option. So, in this article, you are going to learn how to add a row or column headings repeat at the top at every page and how to change default settings.

Add lines on Printing Page

After reading this article, you will be able to display Sheet with lines on each printing page. By default, gridlines are shown in the sheet but not in Print Page.

Convert Excel Sheets to PDF

To Present your work easy to read and share in Excel we change sheet to PDF Form. After reading this article, you will learn how to transfer Workbook or Worksheet to PDF format.

Check Formulas Step by Step in Excel

One thing you’ll regularly do in Excel is debugged or check formulas for error. Function keys in Excel are a handy and faster way of doing certain tasks by using the keyboard instead of the mouse.

How to rotate text or data in Excel

In this article, you will cover to rotate Text clockwise, anticlockwise at a certain degree moreover, the same you can apply on the data label of an Excel Chart.