Tips and Tricks of Excel
Learn some most practical, simple and incredible Excel Tips. And, understand different aspect of spreadsheet making your life easier.
Clear Cell based on Condition
Delete format, comment, or other data of a given range of cells based on the selected option by a user.
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.
How to Remove or Adjust the Dotted Line
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.
To fix / Adjust the Print Preview 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.
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.
Text Display Hovering to Hyperlink
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.
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.
Count Unique Text with Excel Pivot Table
Count Unique Text using Pivot Tables of a specific category in Row or Column without falling for any complicated formula.
What is – – (double negative or dash) in Excel?
In Excel double negative or dash operator converts Boolean result (TRUE or FALSE) back to its original logical value (1 ot 0), respectively.
Excel Wildcard characters for Advanced Search and Partial Match
Learn the essential aspect of Excel wildcard characters like ‘?,*,~’ for advanced search and partial match using three different examples.
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.
Wrap or Shrink to adjust large Text in Excel
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.