Tips and Tricks of Excel
Learn some most practical, simple and incredible Excel Tips. And, understand different aspect of spreadsheet making your life easier.
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.
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.
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.
If you are looking a way to display a text while doing a mouseover over hyperlink content on an Excel worksheet use Screen Tip box tool.
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.