Have you ever wondered how to freeze rows in Excel? Or how to freeze panes? Click here to learn these important functions!
Author Archive | Patric Welch
Have you ever noticed those “extra” paste options like Paste Special in Excel and Excel Paste Values? Ever wonder what they do? Click here to find out!
Did you know that you can use the autofill feature in Excel to quickly create a series? Click here to learn how to use autofill Excel!
What is the difference between an Excel relative cell reference and an absolute cell reference? Click to learn about how to use an Excel cell reference!
Do you love to use spreadsheets but get confused when you need to print the sheet, or portions thereof? Click here to learn how to set print area in Excel!
The concept of setting a page break in Excel may seem strange at first. After all, Excel feels like an endless stream of blank cells in both horizontal and vertical directions. So what exactly defines a page, and why would need to insert a page break in Excel? Similar to a Word Document It might […]
Your spreadsheet is done and want to print it out, but it won’t fit on one page! Click here to learn how to fix it this with the “autofit excel” function.
It is not that difficult to remove extra spaces in Excel by using the Excel TRIM Function. Click here to find out how easy it is!
The Excel REPLACE function is a shortcut that can save you time and aggravation! Click here to find out how to use this useful and simple function.
There are three Excel substring functions that are very powerful, yet easy to use. These functions are used to extract a substring of text from a cell on your spreadsheet. Which one you use depends on how you want to extract the text. The three text substring functions are LEFT, RIGHT and MID. Let’s look […]