How to save Excel to Google sheets

Excel and Google sheets are two scripting applications that differ in the feature that each has. When one is working on data on excel may need to transfer it to…

Comments Off on How to save Excel to Google sheets

How to use wild cards in excel

Excel, as a program, is used by many users for ease of data analysis and documentation, which is done in columns and rows. On the other hand, Wildcards are very…

Comments Off on How to use wild cards in excel

How to merge two Excel tables

Excel is powerful and helpful in carrying out documentation and analysis. The spreadsheet contains some rows and columns. However, Excel tables describe the arrangement of data in columns and rows.…

Comments Off on How to merge two Excel tables

How to link information to another worksheet

Let's say you have data in one worksheet and you want to link the same data to another spreadsheet to use it; it's easy. Sometimes you can copy and paste,…

Comments Off on How to link information to another worksheet

How to create a custom template in excel

A template can be used to make new spreadsheets with predefined formulas and similar settings as it is a predesigned spreadsheet. Creating a custom template is helpful as you don't…

Comments Off on How to create a custom template in excel

How to activate a chart using Excel VBA

Excel VBA is a feature on excel that allows the user to use the programming language of excel to open or create a certain thing on excel. Chart drawing is…

Comments Off on How to activate a chart using Excel VBA

How to sort columns in pivot table in Excel

When the amount of data in a pivot chart or PivotTable is large, sorting it is quite important. Sorting is a way of keeping your data organized to make it…

Comments Off on How to sort columns in pivot table in Excel

How to delete filtered data in excel

Excel, as many know it, is a program that helps its users to organize their data. In other words, filtered data is data displayed in rows, and it must have…

Comments Off on How to delete filtered data in excel

How to make a cell inactive in MS Excel

Inactivating cell(s) in ms excel is pretty easy. Making the cell(s) inactive prevents the user from editing it, overwriting, or changing the content present on that particular cell. Through this…

Comments Off on How to make a cell inactive in MS Excel

How to create a placeholder in excel

Placeholders can be easily created on excel. If you are working with a big worksheet with many graphics or working on a document that the user can add and delete…

Comments Off on How to create a placeholder in excel