BLOG
EXCEL TRICKS

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 want to change the direction? So let’s do it Click on below highlighted button “File”: …

Read More
Excel Tricks
EXCEL TRICKS

Impress your Clients by Hiding these Simple Features

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 your bosses, clients because after hiding these features, you excel sheet looks like a software …

Read More
EXCEL TRICKS

Lock Cells to avoid editing, Hide Formulas

Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and prevent users to make any editing via “Protect Workbook” Option However you need an additional feature along with the “Protect Sheet” to …

Read More
EXCEL TRICKS

Protect Sheets, Share Workbook, Protect Workbook

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 calculations, sheets and sometimes, finish the essence of the project So here we are talking …

Read More
FREE VBA UTILITIES
5

Excel VBA Tool to Get File Properties

Here is one more interesting VBA tool from ExcelSirJi team. File Properties Tool is an Excel VBA tool which gets the following properties of the file. File Name Date Created Date Last Accessed Date Last Modified Size (MB) Type  You just need to browse the folder where your files are …

Read More
Excel Tricks
EXCEL TRICKS

Hide Excel Sheet/Tab – Complete Guide

When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any changes on it. So I found very awesome feature to hide an excel tab: Though there are multiple ways to hide the excel sheet tab: 1. …

Read More
EXCEL TRICKS

TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?

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 this amazing excel formula to remove these spaces: Excel Formula: =Trim(text)   Below is an …

Read More
FREE VBA UTILITIES
3

Excel VBA Tool to Create Folders

In VBA, you can use MkDir function to create folders in your system or shared drive. To make your work simple, we bring a free Excel VBA tool to create folders. To use this tool, enter Base folder path where you want to create folders and the name of the …

Read More
VBA TRICKS

VBA Code to Re-link MS Access Link Tables

In MS Access, the best way to create a multiuser tool is to divide your solution. One part acts as interface and other one acts as database. You can have multiple copies of the interface distributed to users which are connected to central MS Access database saved at common shared …

Read More
VBA TRICKS
1

VBA Code to List Files in Folder

To work on multiples files through VBA programming, you need to have VBA code which can list files in a folder. Here is a simple code for you, this function list files in a folder on Excel sheet. Note that if there are sub-folders available in the folder then this …

Read More
VBA TRICKS
1

VBA Code to Check if File Exist in Folder

To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the …

Read More

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn