Tips and Tricks of Excel
Learn some most practical, simple and incredible Excel Tips. And, understand different aspect of spreadsheet making your life easier.
Delete format, comment, or other data of a given range of cells based on the selected option by a user.
In this post, you are going to learn how to use wildcard characters in the filter to easily extracts.
You will learn how to add a row or column headings repeat at the top of every page and how to change default settings in Preview.
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.
After reading this article, you will learn how to get rid of a Page break in a Page or how to adjust or change the dotted line when we take Print of any Sheet.
You are going to know how to add Print Preview & Print directly into the Quick Access toolbar to ignore fault on the page before taking Printing.
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 out 2 methods to display a text while doing a mouseover over a hyperlink or Text box content of an Excel worksheet or Cell using the Screen Tip tool and Notes.
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.
Count Unique Text using Pivot Tables of a specific category in Row or Column without falling for any complicated formula.
In Excel double negative or dash operator converts Boolean result (TRUE or FALSE) back to its original logical value (1 ot 0), respectively.
Learn the essential aspect of Excel wildcard characters like ‘?,*,~’ for advanced search and partial match using three different examples.
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.
Adjust and fit the text in such a manner that it is within the cell boundary of a worksheet. And, the Excel cell automatically adjust to fit the cell text.