Format Painter being the most unfamiliar feature in Microsoft Excel helps to apply the same formatting to a cell or group of cell. Read this till the End to know a small hack which will help you to use format painter faster.
You are doing data Entry the WRONG WAY !!
Shocked to know this. Here is how to fix it
When Excel was launched couple years back (Around 30 Years or so). The main reason for Excel launch and success was it helped in data Entry work. People Even today uses Excel for data entry purposes but now its on a higher scale of data sorting and creating reports. But till today over 60% of Excel users use Excel for data entry purposes.
There is a good news for all those who use Excel for Data Entry as a SECRET KEYBOARD SHORTCUT has been spotted and which creates User forms for data entry with just a click of button.
(Professionals knowing Excel VBA Must know about user forms and with the help of user forms one can capture details and automate various processes)
Let's get into the point of creating a user form in click of a button for data Entry Purposes
We are confident that you must have enjoyed this Excel Hack a lot and must be waiting to try it out. But WAIT. Before you try it out on your own, I would like to present you with one golden opportunity to join my newest FREE Course on all by Best Excel Hacks. (Liked the above hack, why not check out some more which are exclusively available for our subscribers)
You must be aware that when you write Monday in a cell and you click and drag it you could see that all the names of the days are populated in those cells which you have selected and even if you drag more than 7 it again starts the list from Monday. Do you know that you could also create these types of list at an ease. Such lists are known as custom list. Today i will be showing you 2 different ways by which you can create your own custom list. One method is the regular method and another one is a bit difficult method by using Excel VBA. Learning Excel VBA method is useful for 2 reasons:
1. Learn a bit of coding to implement in further projects
2. You want your clients to create their own list and hence give them ease of use by creating a list
If you have extracted your data from CSV file or downloaded a report from online you may dont want blank rows in the data. those blank rows may affect your reports. Hence you need to delete those rows where data is not presented.
Many of the Excel Lovers uses sort and Filter to select blank rows and then delete it. But there is a good replacement method which can be accompanied in just 5 simple steps. The 5 simple click procedure will get your blank rows deleted. Check out the scenario
Scenario : You are required to delete blank rows from the list of USA States.