Steve Scott 
Copying and pasting are probably one of the most used actions in an Excel spreadsheet. But when it comes to filtered data, copy-pasting data is not always smooth. Ever tried …
Randomness is often just as necessary as order and symmetry, whether you are dealing with life or an Excel worksheet. Sometimes, you need it to ensure every value has an …
Picture this – you’ve worked hard to get your spreadsheet to look just right. You’ve sized the columns correctly, you’ve put nice colored headings, and everything looks great on the …
When working with spreadsheets that contain names, keeping first and last names in separate columns is often convenient. This is because it makes filtering and querying easier. However, there may …
When working with data and spreadsheets, readability, and structure matter a lot. It makes the data easier to skim through and work with. One of the best ways to make …
A neat looking worksheet is always better than a shabby and unorganized one. You can tell if a sheet has been handled repeatedly by different people by just one look …
You may have come across situations where you needed to add a certain number of days to a date. It’s a common use case for people to add 7 days …
When entering telephone numbers, it’s always preferable to format the numbers into bite-sized chunks, either using dots, hyphens, spaces or parentheses. Most phone numbers can go anywhere from 9 to …
We know that it is much easier to work with data when it’s organized and sorted. When you have data collected over a course of time, sorting your data by …
Excel provides a wide range of functionality, a lot of which most users are not even aware of. One of its most fascinating features is the versatility of its Filters. …
A few readers had shared their concerns about situations where some of their sheets seem to be stuck together. So, any changes they make to one sheet are also affecting …
Commas serve multiple purposes when working with spreadsheets. They make numbers more readable. For example, the number 1,452,346 is much clearer than the number 1452346. Commas also help delimit related …