Paste Special

How to copy a table with databars from Excel to Word, retaining table properties instead of picture or PDF?

In this article, KulfiSoftware will provide you how to copy a table with data bars from excel to word without retaining its properties. As you always know, KulfiSoftware gives you the easiest way to solve any issue with the simplest steps. Copying table with data bars from excel to word is very easy but we cannot retain their properties. But, KulfiSoftware will show How to copy a table with databars from Excel to Word, retaining table properties instead ...

Continue Reading →
import csv file to excel

Download and Import .CSV File Into Excel-Step By Step

In this article, KulfiSoftware will provide you how can one Import .CSV file to excel with the simplest steps. Import  .CSV file can prove very helpful for you. So, here are the steps you can follow and import .CSV file into excel. CSV file is best viewed through a spreadsheet program such as Microsoft Excel. What is CSV text file- It stores tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated ...

Continue Reading →

How can I have a shared Excel spreadsheet with an user-defined function while making sure nobody adds any other VBA code?

You can have a shared excel spreadsheet with an user-defined function while making sure nobody adds any VBA code. How? This way, KulfiSoftware is providing not one, two, three but, four ways to make the excel spreadsheet protected and with this no one can change the VBA code.

There are four ways are:

I know of to make sure somebody hasn’t added any other VBA code to your workbook.

The minimalist approach would be adding your digital signature to the ...

Continue Reading →

How do I add a checkbox to an Excel spreadsheet?

Introduction – Add checkbox to Excel

In this article, you will learn how to add a checkbox to Excel spreadsheet. Adding checkbox make our Excel spreadsheet professional. Let’s learn how to add a checkbox to an excel spreadsheets step by step guide by KulfiSoftware.

Steps:

1. Let’s suppose the columns are ‘A’ ‘B’ and ‘C’. First, we will delete the data of column ‘C’.

clear-column-c

2. After deleting, Click ...

Continue Reading →
Spreadsheets VS Excel

Which is better for a company to use Google Sheets or MS Excel for spreadsheets?

Question: Which is better for a company to use Google Sheets or MS Excel for spreadsheets?

In this article, we will discuss Google Sheets VS MS Excel Spreadsheets. Sheets VS Excel? Which is better? let’s discuss. KulfiSoftware will explain you this.

Sheets VS Excel

sheets VS Excel

What is Google Spreadsheet:

Google Spreadsheets is a Web-based form that enables users to build, renew and transform spreadsheets and give ...

Continue Reading →
Success in merging excel spreadsheets

Merge Two Spreadsheets In Excel Effectively

Merge spreadsheets in excel effectively

Merging two spreadsheets in excel is not that difficult you think, And if you think it’s difficult then just read this post by KulfiSoftware. I guaranty yo after reading this article your question will be simplified.

” How To Merge Two SpreadSheets In Excel Effectively”
As you may know, there are many articles on the internet on How to merge spreadsheets in excel and also everyone has the same content but another way to represent you. So ...

Continue Reading →
Paste Special

Is there a Microsoft Excel formula to extract a portion of text by specifying characters to exclude on the left and right?

Is there a Microsoft Excel formula to extract a portion of text by specifying characters to exclude on the left and right?

This seems like a tricky problem but it is actually simple. You just need to summon the power of Text Formulas! Microsoft Excel formula.

I’ve recreated your data and written a solution for you, but first, let’s look at Text formulas and decide which ones we need.

There are eight main types of Text Formulas:

=Trim – eliminates extra ...

Continue Reading →
google-contacts

Google Contacts: How to force MS Excel to import a CSV file without messing up with leading numbers like ‘0’ or ‘+’ sign automatically?

Google Contacts: How to force MS Excel to import a CSV file without messing up with leading numbers like ‘0’ or ‘+’ sign automatically?

Here’s how I do it. (Google Contacts)  I standardize everything with +International Code. So taking an INDIAN example:
A phone number is 91 1234567890 (91 is the area code and the phone number follows). So in this example, I’ll enter the number as follows:

+91 1234567890

Then using Excel or Google Sheets, set the Phone Number Column as Text.
Continue Reading →

highlight word in an excel file

How can I mark or highlight word in an Excel file?

Mark Or Highlight Word In An Excel File:

Today, we will show you how to mark or highlight word in an Excel File. Highlight words in an excel file are very easy as it looks, some of them think that highlighting or marking an excel file is hard but NO! Kulfisoftware will show you the easiest and quickest way to highlight words in an excel file. So, Stay Tuned!

A spreadsheet is a special way of organizing data into rows and columns to make it simpler to read ...

Continue Reading →