How to Remove Dotted Lines in Excel
The topic for this tutorial is slightly fuzzy because what one may see as a dotted line may actually be a dashed line or even a light-colored solid line. Whatever …
How to Convert Radians to Degrees in Excel (Easy Formula)
When working with mathematical data, there might be instances where you need to work on angles. Excel has a number of built-in trigonometric functions that let you easily calculate the …
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 …
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 in a 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 …