A collection of 14 posts

How to Use AutoFill in Excel

When you are pressed for time, every single minute counts. So you need to know every way to automate daily spreadsheet tasks. AutoFill in Excel is a popular feature, and I’m
31 January 2020

How To Create A Custom List In Excel

A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone
31 January 2020

How to Insert comments in Excel

When you’re collaborating with others on your spreadsheet, inserting comments can save you a lot of time. Instead of emailing your comments back and forth or trying to communicate in the cells
31 January 2020

How to Skip Blanks in Microsoft Excel

You can use Skip Blanks feature in Paste Special when you do not want these blank cells get copied to existing values. Most of the excel users are aware of Paste Special command
31 January 2020

How To Use Flash Fill in Excel

Let’s say column A contains first names, column B has last names, and you want to fill column C with first and last names combined. If you establish a pattern by
31 January 2020