excel

Fix: Excel Sheet is grayed problem in Windows 10

February 11, 2020 By Sambit Koley

Is Excel sheet appears to be grayed when you are trying to open a worksheet on your computer? If you are facing this problem and looking for a solution, you are in the right place. There are some …

How To Copy/ Paste Values Without Including Formulae In Microsoft Excel

October 11, 2016 By CoderGirl

How To Copy/ Paste Values Without Including Formulae In Microsoft Excel:- In Microsoft Excel, if you perform a normal copy and paste on a cell whose value is generated using a formula, the pasted …

How To Format Text In Excel Using UPPER, LOWER & PROPER Functions

September 20, 2016 By CoderGirl

How To Format Text In Microsoft Excel Using UPPER, LOWER & PROPER Functions:- Forget deleting all the text just because you forgot to enter in its proper format. Now you can type in the text in …

How To Hide Sheets, Gridlines And Cells In Excel

September 19, 2016 By CoderGirl

How To Hide Sheets, Gridlines And Cells In Excel Sheets:- Are you looking for ways to hide Sheets, Gridlines or Cells in your excel sheet? You are in the right place. We have got the perfect results …

how to set a minimum and maximum value in excel column

January 12, 2018 By CoderGirl

Do you want the data entered to your excel sheets to be within a specified range? Do you have multiple cells to be data validated all at once? Well, we have the perfect solution for you. All you need …

How To Freeze Rows Or Columns In Excel Sheets

July 21, 2016 By CoderGirl

How To Freeze Rows Or Columns In Excel Sheets:- Let's say you have a really long excel sheet. The first row contains the names of all the columns and is being used by you as a reference to enter …

How To Insert An Excel Sheet To Microsoft Word

March 28, 2016 By Sukanya K M

Microsoft Office has always been powerful and the new updates made to it in its newer 2016 version have proved it to be more useful, both in terms of features and enhancements. We all use …

How To Apply Parsing To Names In Microsoft Excel

March 17, 2016 By Sukanya K M

Excel is the most widely used form of spreadsheet and this feature is different from other Microsoft Office tools. Any numerical data can easily be entered, calculated upon, analyzed, stored and …

Use Excel AutoRecover and AutoBackup Features To Secure Data

March 10, 2016 By CoderGirl

How to Use Excel AutoRecover and AutoBackup Features To Secure Data:- You have an important report to submit the next day and you, with great effort, have managed to get it to the end with perfection. …

Create a Funnel Chart in Excel, PowerPoint and Word 2016

March 7, 2016 By Sreelakshmi Menon

Funnel charts can be used in sales representations which can be used to show the sales in each stages and the potential revenue. It gives a unique representation to the business data that you are …

How to Create Sparklines in Excel 2016

March 10, 2016 By Sreelakshmi Menon

Sparklines is a feature you have in Excel which can help you in a quick analysis of data. Suppose you want to check the range of marks of a particular student or check the trend of sales of a …

How to Insert and Change the Color of Hyperlinks in Word 2016

March 10, 2016 By Sreelakshmi Menon

Hyperlinks are references to data.These references can be to a website, or an email id or say to a particular page in a document. A user reading a document can click on the hyperlink and visit to some …

How to Use Watch Window to Monitor Selected Cells In Excel 2016

March 11, 2016 By Sreelakshmi Menon

If you are a frequent Excel user, then mostly you'd be handling large amount of data. Each file might be having many entries. But most of the time, you would be only interested in certain cells in the …

How to prevent images from Automatic Compression in MS Office

March 11, 2016 By Sreelakshmi Menon

Image content in a file can change the size of the document considerably. If there are too many pictures in a document, it is likely to have a significant size. Due to this reason, in MS Office, the …

How to Disable Field Shading in Microsoft Word 16

March 11, 2016 By Sukanya K M

Field shading feature is a new concept which you find in the Microsoft Word 16 .It helps you to find the various fields in the documents as quickly as possible.This happens when you simply select the …

How to Clear and reset Cache in Microsoft Office 16

April 15, 2019 By Sukanya K M

It is a common practice for everyone of us to save the file created using Office say, excel, word or powerpoint. This is a different case with the new Microsoft Office 16. Whenever you save a file …

How to sort Microsoft Excel columns by color

March 19, 2016 By CoderGirl

How to sort Microsoft Excel columns by color: - Sorting an Excel document must have never been a tough job. We are all familiar with sorting the excel sheets by a specific or a collection of columns, …