Text Join in excel
It is used to join two or more cells and have more useful than concatenate function in excel. It can…
Excel
How to Unlock Scroll Lock
When scroll lock is on you can not move from one cell to next cell in excel when you press…
Alt+Enter,Alt+F4,Ctrl+W Keys In Excel
Alt+Enter: If we want to move to next row in same cell in Excel then...
Convert Images to png and gif format
To convert and save images in png and gif format.First open new excel file paste...
Compress Images Using Excel
Sometimes Excel file contains images which increases it size. It could be 30 to 50 Mb. We can use external…
Undo and Redo In Excel
For Undo Press CTRL+Z and For Redo Press CTRL+Y. Both are reverse of each other...
Concatenate Function In Excel
If you want to join some text or two cell then concatenate function in excel...
How to Rename File and Take Screenshot
To rename a file we can use shortcut “F2” or it can be done using...
How To Import Data From Web Using Excel
Import data from Web using excel 1 From Excel Bar Click On Data Option and...
Left Right Function In Excel
With the Use Of Left formula you can extract desired no of strings from a...