How to Center the Worksheet Horizontally on the Page in Excel
When you start out using Microsoft Excel, you’ll notice that printing Excel sheets do not quite feel the same as printing an MS Word document. The idea of ‘What You …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Add Cell Borders in Excel?
When working with large amounts of data, it can sometimes be hard to read the data, if not formatted properly. Moreover, there are usually parts of the dataset that are …
How to Paste into Filtered Column Skipping the Hidden Cells?
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 …
How to Generate Random Numbers in Excel (Without Duplicates)
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 …
How to Fit to Page in Excel (Print on One Sheet)
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 …
How to Merge First and Last Name in Excel?
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 …
How to Split One Column into Multiple Columns in Excel
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 …
How to Make all Cells the Same Size in Excel (AutoFit Rows/Columns)
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 …
How to Add Days to a Date in Excel
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 …
How to Format Phone Numbers in Excel
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 …
How to Sort by Date in Excel (Single Column & Multiple Columns)
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 …
How to Delete Filtered Rows in Excel (with and without VBA)
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. …