by ProTec Solutions | Apr 5, 2020 | Excel
Ever used a formula and wanted to keep only the results (or answers) and delete some or all of the data that the formula use to do the calculations with? As soon as you delete any data that the formula refers to it will result in an Error message. With a simple drag...
by ProTec Solutions | Mar 22, 2020 | Excel
This shortcut allows you to enter the same data at multiple locations at the same time. This can be a great time-saver whenever you are either entering data or making corrections. Hold down the Control key while selecting the cells to be populated with the same data....
by ProTec Solutions | Sep 22, 2019 | Excel
Excel has a variety of methods for entering dates quickly and easily. You can instantly fill any series you’re working with, for instance dates with 7-day intervals, or you might want to exclude weekends and fill with just using weekdays. There are various...
by ProTec Solutions | Sep 9, 2019 | Excel
Often, while working in Excel, we need to insert the current date. Instead of typing it, rather use the available shortcut. It’s fast and easy, and the date entered by making use of this shortcut is the current date as at the time of entry, it will not change or...
by ProTec Solutions | Aug 18, 2019 | Excel
If you are viewing a worksheet in Microsoft Excel that you’re not familiar with, you might need to have a look at where formulas have been used and what formulas were used. Instead of clicking cell by cell to view what displays in each cell’s formula bar – which can...
by ProTec Solutions | Aug 4, 2019 | Excel
For most proficient excel users adjusting column widths doesn’t even involve using commands, usually it’s just a simple double click or a drag. If you for instance want to increase the column-width for column D because the content doesn’t fit properly, you would...