Few Simple Excel Tips – Excel Learner Should Know
1. Change Direction When You Press Enter Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very simple. Do you…
While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and Formula Bar. This can give WOW experience to…
Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to make unnecessary editing because it can change…
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet at the end of Excel file…