Tips and Tricks

Tip #1 – Create a Personal Contact from Your Call History in 3CX

You can create a Personal Contact in your 3CX Web Client from you Call History to keep important or frequently used phone numbers. All you need to do in your 3CX Web Client is go to your Call History and click on the "+" icon to the right of the call entry (it will say "Add Contact" if you hover your mouse cursor over it). Then just fill in the appropriate fields in the "Add Contact" window and click on "OK". You will now have this saved in your Personal Contacts. Then you can call them just by clicking on the phone icon in the contact.


Tip #2 - How to rename multiple files at the same time

Many of us are familiar with the ability to select a series of files by using methods like +click, +click, , or click+drag, among others. Selecting multiple files is often useful for copying and moving them all at once, but there's another obscure Windows feature available where a series of files is selected -- bulk rename. By right-clicking on any one of the selected files in the series and selecting 'Rename', you can simultaneously rename all of the files to the same name. Files with the same extension will automatically have sequential numbers appended to them. It's a neat tip, but we recommend testing on a sample group first!


Tip #3 – Quickly Delete Blank Cells in Excel

When copying/pasting data some cells may be blanks. If you need to delete these to maintain accuracy, especially when calculating the average value, the speedy way is to filter out all blank cells and delete them with one click.

Choose the column you want to filter, go to Data->Filter

After the downward button shows, uncheck Select All and then check the last option, Blanks.

All blank cells will show immediately.

Click the triangle at the top left of the cells/rows to select all cells

Press Delete to delete all blank cells